Recent buildfarm failures involving statement_timeout - Mailing list pgsql-hackers

From Tom Lane
Subject Recent buildfarm failures involving statement_timeout
Date
Msg-id 15025.1209276906@sss.pgh.pa.us
Whole thread Raw
Responses Re: Recent buildfarm failures involving statement_timeout
Re: Recent buildfarm failures involving statement_timeout
List 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


pgsql-hackers by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: we don't have a bugzilla
Next
From: Shane Ambler
Date:
Subject: Re: we don't have a bugzilla