On Tue, Jul 26, 2011 at 05:04:28PM -0400, Alvaro Herrera wrote:
> ***
> /home/pgbuildfarm/workdir/HEAD/pgsql.20950/src/test/isolation/expected/fk-deadlock2.out
>Sun Jul 24 08:46:44 2011
> ---
> /home/pgbuildfarm/workdir/HEAD/pgsql.20950/src/test/isolation/results/fk-deadlock2.out
> Sun Ju
After committing Noah's patch to fix the isolation tests, there have
been two more failures in Rémi's machines pika and coypu:
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=pika&dt=2011-07-24%2006%3A45%3A45
http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=coypu&dt=2011-07-23%2021%3A
Excerpts from Noah Misch's message of sáb jul 16 13:25:03 -0400 2011:
> On Sat, Jul 16, 2011 at 05:50:45PM +0200, Rémi Zara wrote:
> > Isolation tests seem to deadlock on buildfarm member coypu (NetBSD/powerpc
> > 5.1).
>
> Thanks for the report and detailed analysis. I believe the patch here wi
On Sat, Jul 16, 2011 at 05:50:45PM +0200, Rémi Zara wrote:
> Isolation tests seem to deadlock on buildfarm member coypu (NetBSD/powerpc
> 5.1).
Thanks for the report and detailed analysis. I believe the patch here will fix
the problem:
http://archives.postgresql.org/message-id/20110716171121.gb2
Rémi Zara wrote:
> Isolation tests seem to deadlock on buildfarm member coypu
> (NetBSD/powerpc 5.1).
It looks to me like both the extreme logging of "waiting" messages
and the days-long unrecognized deadlocks are coming from the new "fk"
tests added to the isolation testing schedule.
-Kevin
Hi,
Isolation tests seem to deadlock on buildfarm member coypu (NetBSD/powerpc 5.1).
Here are the process for one deadlock (several days) :
pgbuildfarm 2405 0.0 1.2 26948 7916 ? Is Wed02AM0:00.25 postgres:
pgbuildfarm isolationtest [local] INSERT waiting
pgbuildfarm 6559 0.0 0
