Recent buildfarm failures involving statement_timeout

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: Recent buildfarm failures involving statement_timeout
Date: 2008-04-27 06:15:06
Message-ID: 15025.1209276906@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The buildfarm has shown several intermittent failures recently:

http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=heron&dt=2008-04-20%2000:06:01
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=cobra&dt=2008-04-26%2004:15:02
http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=heron&dt=2008-04-27%2000:06:01

all with the same signature:

*** ./expected/prepared_xacts.out Sun Apr 27 02:06:33 2008
--- ./results/prepared_xacts.out Sun Apr 27 02:10:19 2008
***************
*** 161,166 ****
--- 161,167 ----
SELECT * FROM pxtest3;
ERROR: canceling statement due to statement timeout
reset statement_timeout;
+ ERROR: canceling statement due to statement timeout
-- Disconnect, we will continue testing in a different backend
\c -
-- There should still be two prepared transactions

which so far as I recall is not a failure we've seen in the past
(though we still don't have buildfarm infrastructure that makes it
easy to confirm or refute that opinion).

One explanation for this is that these buildfarm machines were so
heavily overloaded that it really did take more than 1 sec to execute
"reset statement_timeout". That's not very plausible, though,
especially not considering that both machines logged session times
(via log_disconnect) that don't seem very far out of line.

Another theory is that we broke something recently, but I see no obvious
candidates in the CVS logs --- and I've spent the evening running 488
cycles of the parallel regression tests here, with no error.

Anyone have a theory?

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Shane Ambler 2008-04-27 07:05:23 Re: we don't have a bugzilla
Previous Message Andrew Sullivan 2008-04-27 02:22:34 Re: we don't have a bugzilla