Re: Permission denied on fsync / Win32 (was right

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov>
Cc: pgsql-bugs(at)postgresql(dot)org, "<Magnus Hagander" <mha(at)sollentuna(dot)net>
Subject: Re: Permission denied on fsync / Win32 (was right
Date: 2006-04-18 17:04:16
Message-ID: 14717.1145379856@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov> writes:
> The error messages refer to the old relfilenode (in 3 out of 3
> occurrences today).

So it'd seem the problem is with fsync on recently-deleted files.
Is it possible that we are getting EACCES (ERROR_SHARING_VIOLATION
maybe) in the situation where we try to fsync a file that's been
unlinked but isn't fully gone yet due to open handles?

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-04-18 17:09:09 Re: [Win32] Problem with rename()
Previous Message Peter Brant 2006-04-18 15:50:39 Re: [Win32] Problem with rename()