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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
