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:02heron   | 2008-03-11 18:06:01heron   | 2008-03-11
23:06:01heron  | 2008-04-20 00:06:01cobra   | 2008-04-26 04:15:02heron   | 2008-04-27 00:06:01
 
(6 rows)


So, nothing before March.


cheers

andrew