Re: BUG #2712: could not fsync segment: Permission - Mailing list pgsql-bugs

From Thomas H.
Subject Re: BUG #2712: could not fsync segment: Permission
Date
Msg-id 067901c70344$e7d824b0$0201a8c0@iwing
Whole thread Raw
In response to Re: BUG #2712: could not fsync segment: Permission  ("Magnus Hagander" <mha@sollentuna.net>)
List pgsql-bugs
> "Magnus Hagander" <mha@sollentuna.net> writes:
>> It seems to me that it's not been included in b3. Tom?
>
> I'm waiting for some report of whether it fixes the problems?

voilà:

> Sent: Tuesday, October 31, 2006 7:23 AM
> Subject: Re: [BUGS] xlog lockup patch (was: BUG #2712: could not fsync
> segment: Permission)
>
> i've loaded 1gb of data without any xlog-problems, whereas with the 8.2b2
> executable it locked up after ~100mb. the xlog-files are cycling...
>
> if i need to test for some specific behaviour let me know.


after using the patched b2 executable, the db system never locked up again,
and no xlog error messages in the logs either.

the other problem with locked files within the data directories is
unaffected by the patch, obviously - but as that does not lock up the
system, its not that severe (but still scary ;-))

regards,
thomas

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2712: could not fsync segment: Permission
Next
From: "JEAN-PIERRE PELLETIER"
Date:
Subject: Re: ERROR: failed to build any 4-way joins SQL state: XX000, PostgreSQL