Re: [Fwd: Re: race condition for drop schema cascade?]

From: "Jim Buttafuoco" <jim(at)contactbda(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(at)dunslane(dot)net>
Subject: Re: [Fwd: Re: race condition for drop schema cascade?]
Date: 2004-12-16 13:01:11
Message-ID: 20041216125930.M70465@contactbda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I have rebuild the filesystem on my indy (MIPS) that Andrew reported on. The first run completed 100%, I would give
it a couple more runs before we can say its the filesystem not Postgresql that was causing the drop to fail.

---------- Original Message -----------
From: Andrew Dunstan <andrew(at)dunslane(dot)net>
To: jim(at)buttafuoco(dot)net
Sent: Wed, 15 Dec 2004 16:42:59 -0500
Subject: [Fwd: Re: [HACKERS] race condition for drop schema cascade?]

> Jim, please advise?
>
> thanks
>
> andrew
>
> -------- Original Message --------
> Subject: Re: [HACKERS] race condition for drop schema cascade?
> Date: Wed, 15 Dec 2004 16:29:01 -0500
> From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> To: Andrew Dunstan <andrew(at)dunslane(dot)net>
> CC: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
> References: <41C0A720(dot)9050803(at)dunslane(dot)net>
>
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> > I have seen this failure several times, but not consistently, on the
> > buildfarm member otter (Debian/MIPS) and possible on others, and am
> > wondering if it indicates a possible race condition on DROP SCHEMA CASCADE.
>
> Hard to see what, considering that there's only one backend touching
> that tablespace in the test. I'd be inclined to wonder if there's
> a filesystem-level problem on that platform. What filesystem are you
> running on anyway?
>
> regards, tom lane
------- End of Original Message -------

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Cave-Ayland 2004-12-16 14:30:26 Re: join selectivity
Previous Message Neil Conway 2004-12-16 11:07:31 Re: bgwriter changes