aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2006-06-18 16:21:32 +0000
committerTom Lane <tgl@sss.pgh.pa.us>2006-06-18 16:21:32 +0000
commit63b103aac83e41dd418113d0e252bacfd5cb98d6 (patch)
tree50cf7deff55f0e8ca6bb312a98d3976c4d8fb614
parentb243d3945647002321353d1c4360c1f684a07bf7 (diff)
downloadpostgresql-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.out4
-rw-r--r--src/test/regress/sql/plpgsql.sql4
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();