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 been 4 failures: > >> > >> > > > > > > > >>pgbuildfarm=# select sysname, snapshot, stage, branch from build_status > >>where log ~ 'tablespace "testspace" is not empty.*tablespace "testspace" > >>is not empty' and not log ~ 'No space left'; > >> sysname | snapshot | stage | branch > >> --------+---------------------+--------------+-------- > >> hare | 2004-12-09 05:15:05 | Check | HEAD > >> otter | 2004-12-11 15:50:09 | Check | HEAD > >> otter | 2004-12-15 15:50:10 | Check | HEAD > >> gibbon | 2004-12-28 23:55:05 | InstallCheck | HEAD > >> > >> > > > >Why does the last show as an "install" failure? > > > > > > > We run the standard regression suite twice - the failure on Gibbon > occurred on the second of these. Clearly this is very transient. > > > >Anyway, given the small number of machines involved, I'm once again > >wondering what filesystem they are using. They wouldn't be running > >the check over NFS, by any chance, for instance? > > > >The theory that is in my mind is that the bgwriter could have written > >out a page for the table in the test tablespace, and thereby be holding > >an open file pointer for it. On standard Unix filesystems this would > >not disrupt the backend's ability to unlink the table at the DROP stage, > >but I'm wondering about nonstandard filesystems ... > > > > > > > > Jim Buttafuoco reported on December 16th that he had rebuilt the > filesystem on his MIPS box - I assume this means that he isn't using > NFS. In any case, we have not seen the problem since then. His Alpha box > has not been reporting buildfarm results since before then. > > The Cygwin box is running on NTFS - and we know we've encountered plenty > of problems with unlinking on Windows. > > I know it's not much to go on. > > cheers > > andrew > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend