Re: [Re] [Re] Re: PANIC: could not write to log file - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [Re] [Re] Re: PANIC: could not write to log file
Date
Msg-id 20330.1353687888@sss.pgh.pa.us
Whole thread Raw
In response to [Re] [Re] Re: PANIC: could not write to log file  ("Cyril VELTER" <cyril.velter@metadys.com>)
Responses Re: PANIC: could not write to log file  ("Cyril VELTER" <cyril.velter@metadys.com>)
List pgsql-hackers
"Cyril VELTER" <cyril.velter@metadys.com> writes:
>    I follow up on my previous message. Just got two more crash today very similar to the first ones :

> PANIC:  could not write to log file 118, segment 237 at offset 2686976, length 5578752: Invalid argument
> STATEMENT:  COMMIT
> PANIC:  could not write to log file 118, segment 227 at offset 9764864, length 57344: Invalid argument
> STATEMENT:  COMMIT

> for memory the first ones are 

> PANIC:  could not write to log file 117, segment 117 at offset 5660672, length 4096000: Invalid argument
> STATEMENT:  COMMIT
> PANIC:  could not write to log file 118, segment 74 at offset 12189696, length 475136: Invalid argument
> STATEMENT:  COMMIT

Hm, those write lengths seem rather large.  What have you got
wal_buffers set to?  Does it help if you back it off to whatever you
were using in the 8.2 installation?  (The default back in 8.2 days
seems to have been 64kB, if that helps.)
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [v9.3] Extra Daemons (Re: elegant and effective way for running jobs inside a database)
Next
From: Fujii Masao
Date:
Subject: Re: Proposal for Allow postgresql.conf values to be changed via SQL