Re: org.postgresql.util.PSQLException: PANIC: could not write to log file 6 - Mailing list pgsql-general

From Alban Hertroys
Subject Re: org.postgresql.util.PSQLException: PANIC: could not write to log file 6
Date
Msg-id C7097320-CEC3-404C-994A-A063FFFC887D@solfertje.student.utwente.nl
Whole thread Raw
In response to org.postgresql.util.PSQLException: PANIC: could not write to log file 6  (mzhang@ilww.com)
List pgsql-general
On 29 Jul 2009, at 14:43, mzhang@ilww.com wrote:

> Hello,
>
> In our customer site, the following error occurred. I tried to find
> some
> indication what this means. Is this log file used for the roll back
> purpose? In what scenario that one gets such fatal error?

It's likely part of the WAL, in which case there would be data loss if
it can't write there.

> Caused by: org.postgresql.util.PSQLException: PANIC: could not write
> to
> log file 6, segment 176 at offset 14991360, length 8192: Read-only
> file
> system

You missed the interesting part: "Read-only file system".

Alban Hertroys

--
If you can't see the forest for the trees,
cut the trees and you'll see there is no forest.


!DSPAM:737,4a71877c10135591761324!



pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Clients disconnect but query still runs
Next
From: Craig Ringer
Date:
Subject: Re: Clients disconnect but query still runs