Skip site navigation (1) Skip section navigation (2)


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
Cc: Josh Berkus <josh(at)agliodbs(dot)com>,Noah Silverman <noah(at)allresearch(dot)com>,pgsql-performance(at)postgresql(dot)org
Subject: Re: WEIRD CRASH?!?!
Date: 2003-01-25 01:12:06
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-performance
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> writes:
> The question is why did it get confused and end up linking to a filename
> that already existed?

The message comes from InstallXLogFileSegment(), which is careful to
ensure that the link() cannot fail, either by unlinking the previous
file, or searching for an unused name.  But it failed anyway.

It seems to me that there are only two possible explanations: a race
condition (but holding ControlFileLock should prevent that) or 
BasicOpenFile() failed for a reason other than nonexistence of the file.

Hmm ... I wonder if Noah's machine could have been running out of kernel
file table slots, or something like that?  It does seem that it'd be
more robust to use something like stat(2) to probe for an existing file.

			regards, tom lane

In response to


pgsql-performance by date

Next:From: Noah SilvermanDate: 2003-01-25 01:14:09
Subject: Re: WEIRD CRASH?!?!
Previous:From: Rod TaylorDate: 2003-01-25 01:08:24
Subject: Re: WEIRD CRASH?!?!

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group