From: | "Cyril VELTER" <cyril(dot)velter(at)metadys(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | PANIC: could not write to log file |
Date: | 2012-11-21 16:51:27 |
Message-ID: | 2674.3528728@A0B26CC9.AE6B.4C00.9DB4.128BBA13E61B |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
After upgrading a pretty big database (serveral hundred gig) from 8.2 to 9.2 I'm getting some "PANIC: could not write to log file" messages. Actually I got two of them. One yesterday and one today.
* postgres 9.2.1 is running on a windows 2003 server (downloaded the zip archive binaries)
* Data is on an iscsi san (the same postgres 8.2 was running on perfectly since several years)
* Full messages are :
PANIC: could not write to log file 118, segment 74 at offset 12189696, length 475136: Invalid argument
STATEMENT: COMMIT
PANIC: could not write to log file 117, segment 117 at offset 5660672, length 4096000: Invalid argument
STATEMENT: COMMIT
* I have no other messages from the san nor from windows
* Here are the non default parameters in postgresql.conf
listen_addresses = '*' # what IP address(es) to listen on;
max_connections = 200 # (change requires restart)
shared_buffers = 320MB # min 128kB
work_mem = 50MB # min 64kB
maintenance_work_mem = 700MB # min 1MB
checkpoint_segments = 15 # in logfile segments, min 1, 16MB each
Any idea on what might be going on ?
Cyril VELTER
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2012-11-21 17:07:16 | Re: Database object names and libpq in UTF-8 locale on Windows |
Previous Message | Andrew Dunstan | 2012-11-21 16:33:14 | Re: Database object names and libpq in UTF-8 locale on Windows |