Re: Server writing short WAL files

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: beamsplitter(at)gmail(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Server writing short WAL files
Date: 2012-07-05 22:00:02
Message-ID: 29860.1341525602@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

beamsplitter(at)gmail(dot)com writes:
> I'm having trouble with WAL files. Every 4th WAL file written by the server
> into pg_xlog is 24576 bytes instead of 16MB. A short WAL causes a fatal
> error during recovery.

Hm. It's fairly hard to see how you could get into such a state to
start with, but once there was a short WAL file present in pg_xlog,
the server might keep on recycling it for re-use. Try physically
deleting or padding out the short file.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-07-05 22:51:21 Re: Suboptimal query plan fixed by replacing OR with UNION
Previous Message Steven Schlansker 2012-07-05 21:57:49 Suboptimal query plan fixed by replacing OR with UNION