diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-18 16:21:32 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2006-06-18 16:21:32 +0000 |
commit | 63b103aac83e41dd418113d0e252bacfd5cb98d6 (patch) | |
tree | 50cf7deff55f0e8ca6bb312a98d3976c4d8fb614 | |
parent | b243d3945647002321353d1c4360c1f684a07bf7 (diff) | |
download | postgresql-63b103aac83e41dd418113d0e252bacfd5cb98d6.tar.gz postgresql-63b103aac83e41dd418113d0e252bacfd5cb98d6.zip |
Increase timeout in statement_timeout test from 1 second to 2 seconds.
We have once or twice seen failures suggesting that control didn't get
to the exception block before the timeout elapsed, which is unlikely
but not impossible in a parallel regression test (with a dozen other
backends competing for cycles). This change doesn't completely prevent
the problem of course, but it should reduce the probability enough that
we don't see it anymore. Per buildfarm results.
-rw-r--r-- | src/test/regress/expected/plpgsql.out | 4 | ||||
-rw-r--r-- | src/test/regress/sql/plpgsql.sql | 4 |
2 files changed, 4 insertions, 4 deletions
diff --git a/src/test/regress/expected/plpgsql.out b/src/test/regress/expected/plpgsql.out index 961fe9f46ee..a73ea635d80 100644 --- a/src/test/regress/expected/plpgsql.out +++ b/src/test/regress/expected/plpgsql.out @@ -2019,7 +2019,7 @@ begin begin x := x + 1; insert into foo values(x); - -- we assume this will take longer than 1 second: + -- we assume this will take longer than 2 seconds: select count(*) into x from tenk1 a, tenk1 b, tenk1 c; exception when others then @@ -2032,7 +2032,7 @@ begin insert into foo values(x); return x; end$$ language plpgsql; -set statement_timeout to 1000; +set statement_timeout to 2000; select blockme(); NOTICE: nyeah nyeah, can't stop me blockme diff --git a/src/test/regress/sql/plpgsql.sql b/src/test/regress/sql/plpgsql.sql index 6bffb3e13b6..cbb2bdc57c8 100644 --- a/src/test/regress/sql/plpgsql.sql +++ b/src/test/regress/sql/plpgsql.sql @@ -1755,7 +1755,7 @@ begin begin x := x + 1; insert into foo values(x); - -- we assume this will take longer than 1 second: + -- we assume this will take longer than 2 seconds: select count(*) into x from tenk1 a, tenk1 b, tenk1 c; exception when others then @@ -1769,7 +1769,7 @@ begin return x; end$$ language plpgsql; -set statement_timeout to 1000; +set statement_timeout to 2000; select blockme(); |