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

Re: Permission denied on fsync / Win32 (was right sibling is not next child)

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
Subject: Re: Permission denied on fsync / Win32 (was right sibling is not next child)
Date: 2006-04-13 18:30:52
Message-ID: 28899.1144953052@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov> writes:
> It turns out we've been getting rather huge numbers of "Permission
> denied" errors relating to fsync so perhaps it wasn't really a precursor
> to the crash as I'd previously thought.  

> I've pasted in a complete list following this email covering the time
> span from 3/20 to 4/6.  The number in the first column is the number of
> times the given log message appeared.

Wow.  What was happening to your pg_xlog directory while this was going
on?  I would expect that the system would plow ahead after this error,
but having failed to complete the checkpoint, it would never be able to
free any back WAL segments.  Were you accumulating lots of gigabytes of
WAL files?  Or maybe the errors came and went, so that sometimes you
could get through a checkpoint?

> The interesting thing is that _none_ of the referenced relfilenode
> numbers actually appear in the file system.

Could they have been temporary tables?  Alternatively, if you routinely
use TRUNCATE, CLUSTER, or REINDEX (all of which assign new relfilenode
numbers), then maybe they were older versions of tables that still
exist.

>   - The file system is NTFS

OK, anyone know anything about permissions on NTFS?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2006-04-13 18:33:46
Subject: Re: Permission denied on fsync / Win32 (was right sibling is not next child)
Previous:From: Stephan SzaboDate: 2006-04-13 17:09:03
Subject: Re: BUG #2390: check constraint

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