Re: Recent buildfarm failures involving statement_timeout

Tom Lane wrote:
> 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).
>

pgbfprod=# select sysname, snapshot from build_status_log where branch =
'HEAD' and log_stage = 'check.log' and log_text ~ $$\+ ERROR: canceling
statement due to statement timeout$$;
sysname | snapshot
---------+---------------------
fennec | 2008-03-06 01:10:02
heron | 2008-03-11 18:06:01
heron | 2008-03-11 23:06:01
heron | 2008-04-20 00:06:01
cobra | 2008-04-26 04:15:02
heron | 2008-04-27 00:06:01
(6 rows)

So, nothing before March.

cheers

andrew