diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-04-28 23:48:16 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-04-28 23:48:16 +0000 |
| commit | 98c4ebd38cb7ce22cb50724653bdcdff985b811f (patch) | |
| tree | 0210b8eb7454b48a8dde476fa506a1a9ab9ac227 /src | |
| parent | d7379b76244a038d540ccbd3e0c25fb80aed28b7 (diff) | |
| download | postgresql-98c4ebd38cb7ce22cb50724653bdcdff985b811f.tar.gz postgresql-98c4ebd38cb7ce22cb50724653bdcdff985b811f.zip | |
Increase the statement_timeout value used in the prepared_xacts regression
test. We have seen some buildfarm failures that seem to be due to this
limit being unexpectedly exceeded when the machine is under load.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/prepared_xacts.out | 4 | ||||
| -rw-r--r-- | src/test/regress/sql/prepared_xacts.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/prepared_xacts.out b/src/test/regress/expected/prepared_xacts.out index 514a706ba6c..258706da8e6 100644 --- a/src/test/regress/expected/prepared_xacts.out +++ b/src/test/regress/expected/prepared_xacts.out @@ -157,7 +157,7 @@ SELECT gid FROM pg_prepared_xacts; (2 rows) -- pxtest3 should be locked because of the pending DROP -set statement_timeout to 1000; +set statement_timeout to 2000; SELECT * FROM pxtest3; ERROR: canceling statement due to statement timeout reset statement_timeout; @@ -172,7 +172,7 @@ SELECT gid FROM pg_prepared_xacts; (2 rows) -- pxtest3 should still be locked because of the pending DROP -set statement_timeout to 1000; +set statement_timeout to 2000; SELECT * FROM pxtest3; ERROR: canceling statement due to statement timeout reset statement_timeout; diff --git a/src/test/regress/sql/prepared_xacts.sql b/src/test/regress/sql/prepared_xacts.sql index 39de88faab6..337567271de 100644 --- a/src/test/regress/sql/prepared_xacts.sql +++ b/src/test/regress/sql/prepared_xacts.sql @@ -102,7 +102,7 @@ SELECT * FROM pxtest2; SELECT gid FROM pg_prepared_xacts; -- pxtest3 should be locked because of the pending DROP -set statement_timeout to 1000; +set statement_timeout to 2000; SELECT * FROM pxtest3; reset statement_timeout; @@ -113,7 +113,7 @@ reset statement_timeout; SELECT gid FROM pg_prepared_xacts; -- pxtest3 should still be locked because of the pending DROP -set statement_timeout to 1000; +set statement_timeout to 2000; SELECT * FROM pxtest3; reset statement_timeout; |