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

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

"Thomas H." <me(at)alternize(dot)com> writes:
>> Do you actually mean it's trying to write that file? Or is it just
>> sitting there holding the open filehandle?

> well, hard to tell :-)
> according to the log-messages i would assume it is *trying* to write.

The log messages you have don't make it clear which process is trying to
do the fsync, but I would expect it to be the bgwriter. (Possibly you
should modify log_line_prefix to include PID so we can tell a bit
better.)

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Thomas H. 2006-10-23 22:26:50 Re: BUG #2712: could not fsync segment: Permission
Previous Message Thomas H. 2006-10-23 21:56:19 Re: BUG #2712: could not fsync segment: Permission

Browse pgsql-patches by date

  From Date Subject
Next Message Thomas H. 2006-10-23 22:26:50 Re: BUG #2712: could not fsync segment: Permission
Previous Message Thomas H. 2006-10-23 21:56:19 Re: BUG #2712: could not fsync segment: Permission