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

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

From: "Peter Brant" <Peter(dot)Brant(at)wicourts(dot)gov>
To: "Thomas H(dot)" <me(at)alternize(dot)com>,<pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #2712: could not fsync segment: Permission
Date: 2006-10-23 16:42:39
Message-ID: 453D0D1E.E840.00BE.0@wicourts.gov (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-patches
The same problem exists in 8.1 too.  See this thread

http://archives.postgresql.org/pgsql-bugs/2006-04/msg00177.php 

Tom and Magnus tracked down a cause, but I don't think a fix was ever
implemented.

FWIW, we were bitten by the fsync problem which you noticed too. 
Unfortunately we were never able to track down a cause (see the mailing
list archives).  They are separate problems though.

Pete

>>> "Thomas H." <me(at)alternize(dot)com> 23.10.2006 18:21 >>>
there is defenitely something terribly wrong in the windows 8.2b1
regarding 
file access/locking. 2nd total db lockup today due to file access locks
(all 
hold by postmaster):

2006-10-23 17:48:10 LOCATION:  exec_simple_query, postgres.c:1007
2006-10-23 17:48:14 LOG:  00000: could not rename file 
"pg_xlog/00000001000000040000002E" to
"pg_xlog/000000010000000400000037", continuing to try


In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-10-23 17:49:14
Subject: Re: BUG #2712: could not fsync segment: Permission
Previous:From: Thomas H.Date: 2006-10-23 16:21:34
Subject: Re: BUG #2712: could not fsync segment: Permission denied

pgsql-patches by date

Next:From: Tom LaneDate: 2006-10-23 17:49:14
Subject: Re: BUG #2712: could not fsync segment: Permission
Previous:From: Thomas H.Date: 2006-10-23 16:21:34
Subject: Re: BUG #2712: could not fsync segment: Permission denied

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