From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | cyril(dot)velter(at)metadys(dot)com |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [Re] [Re] Re: PANIC: could not write to log file |
Date: | 2012-11-23 16:24:48 |
Message-ID: | 20330.1353687888@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
"Cyril VELTER" <cyril(dot)velter(at)metadys(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Fujii Masao | 2012-11-23 16:40:54 | Re: Proposal for Allow postgresql.conf values to be changed via SQL |
Previous Message | Tom Lane | 2012-11-23 16:18:29 | Re: [v9.3] Extra Daemons (Re: elegant and effective way for running jobs inside a database) |