PANIC: could not write to log file

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

Responses

Browse pgsql-hackers by date

  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