Re: [GENERAL] org.postgresql.util.PSQLException: PANIC: could not write to log file 6

2009-07-30 Thread Alban Hertroys 

On 29 Jul 2009, at 14:43, mzh...@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!



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] org.postgresql.util.PSQLException: PANIC: could not write to log file

2009-07-29 Thread Ray Stell 
On Wed, Jul 29, 2009 at 09:05:37AM -0400, mzh...@ilww.com wrote:
> 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 need the sysadmin to examine the OS status.  It's possible the system did
not boot cleanly.  I've seen this state in the case of hardware issues.

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general