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

2005-01-03 Thread Bruce Momjian
Did this get resolved as an OS file system issue? --- Andrew Dunstan wrote: Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: You're right - my query was not sufficiently specific. There have in fact

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

2004-12-29 Thread Kurt Roeckx
pgbuildfarm=# select name, operating_system, stage, count from buildsystems b, (select sysname, stage, count(*) as count from build_status where log ~ 'tablespace testspace is not empty' group by sysname, stage) as s where s.sysname=b.name; Note that the expected log has that as error

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

2004-12-29 Thread Andrew Dunstan
Kurt Roeckx wrote: pgbuildfarm=# select name, operating_system, stage, count from buildsystems b, (select sysname, stage, count(*) as count from build_status where log ~ 'tablespace testspace is not empty' group by sysname, stage) as s where s.sysname=b.name; Note that the expected log

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

2004-12-29 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: You're right - my query was not sufficiently specific. There have in fact been 4 failures: pgbuildfarm=# select sysname, snapshot, stage, branch from build_status where log ~ 'tablespace testspace is not empty.*tablespace testspace is not empty'

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

2004-12-29 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: You're right - my query was not sufficiently specific. There have in fact been 4 failures: pgbuildfarm=# select sysname, snapshot, stage, branch from build_status where log ~ 'tablespace testspace is not empty.*tablespace

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

2004-12-29 Thread Jim Buttafuoco
-- Original Message --- From: Andrew Dunstan [EMAIL PROTECTED] To: Tom Lane [EMAIL PROTECTED] Cc: Kurt Roeckx [EMAIL PROTECTED], PostgreSQL-development pgsql-hackers@postgresql.org Sent: Wed, 29 Dec 2004 13:05:26 -0500 Subject: Re: [HACKERS] race condition for drop schema cascade? Tom Lane wrote

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

2004-12-29 Thread Jim Buttafuoco
: Wed, 29 Dec 2004 12:26:56 -0500 Subject: Re: [HACKERS] race condition for drop schema cascade? Andrew Dunstan [EMAIL PROTECTED] writes: You're right - my query was not sufficiently specific. There have in fact been 4 failures: pgbuildfarm=# select sysname, snapshot, stage, branch from

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

2004-12-29 Thread Andrew Dunstan
Jim Buttafuoco wrote: Andrew/all I have not seen any problems on my MIPS systems since the rebuild ext3 (I ran badblocks during fs creation). I should have the alpha running about soon, the disk died and I am waiting a replacement. I do believe there is a floating point problem with older

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

2004-12-28 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] 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,

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

2004-12-28 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] writes: I have just seen this error again, this time on Cygwin. I did a trawl thought the buildfarm history looking for other occurrences and found it happening on many platforms: [ yawning... ] I've got to go to bed now, but so far tonight my Fedora Core 3

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

2004-12-16 Thread Jim Buttafuoco
[EMAIL PROTECTED] To: [EMAIL PROTECTED] 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

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

2004-12-15 Thread Tom Lane
Andrew Dunstan [EMAIL PROTECTED] 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

[HACKERS] race condition for drop schema cascade?

2004-12-15 Thread Andrew Dunstan
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. == pgsql.30167/src/test/regress/regression.diffs