Re: BUG #2712: could not fsync segment: Permission

From: "Magnus Hagander" <mha(at)sollentuna(dot)net>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Thomas H(dot)" <me(at)alternize(dot)com>
Cc: "Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #2712: could not fsync segment: Permission
Date: 2006-10-24 06:05:28
Message-ID: 6BCB9D8A16AC4241919521715F4D8BCEA0FCC2@algol.sollentuna.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-patches

> > i've installed Filemon
> > (http://www.sysinternals.com/Utilities/Filemon.html)
> > now. this gives more insight what happens to the file.
> > ...
> > D:\DB\PostgreSQL-8.2\data\base\3964774\6422806 DELETE PEND Options:
> > Open
> > Access: 0012019F
>
> This is quite interesting, because it says that Filemon knows
> how to distinguish a "delete pending" error from other
> errors. If we could do that, then my prior worries about
> ignoring all EACCES errors would go away. What's it looking
> at exactly?

filemon is a kernel mode filter driver. So it's looking at kernel-only
datastructures. AFAIK, there is no way to see that from userspace.

//Magnus

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Frank Schmidt 2006-10-24 08:46:24 BUG #2714: Wrong Result with static number
Previous Message Tom Lane 2006-10-24 05:58:54 Re: BUG #2712: could not fsync segment: Permission

Browse pgsql-patches by date

  From Date Subject
Next Message Heikki Linnakangas 2006-10-24 07:20:13 WAL logging freezing
Previous Message Tom Lane 2006-10-24 05:58:54 Re: BUG #2712: could not fsync segment: Permission