Invalid pages in WAL

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Invalid pages in WAL
Date: 2008-12-17 15:07:35
Message-ID: 1229526455.4793.37.camel@ebony.2ndQuadrant
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I've had a private report of these error messages in a test of Hot
Standby, but IMHO these aren't related to that patch. It seems more
likely to be related to the new VACUUM code? Certainly hot standby does
nothing to the normal flow of existing WAL records.

LOG: database system was interrupted; last known up at 2008-12-16
12:56:57 EST
LOG: database system was not properly shut down; automatic recovery in
progress
LOG: redo starts at 0/655A68
LOG: record with zero length at 0/658150
LOG: redo done at 0/658080
WARNING: page 35 of relation base/11517/1249 did not exist
WARNING: page 32 of relation base/11517/1249 did not exist
WARNING: page 33 of relation base/11517/1249 did not exist
WARNING: page 34 of relation base/11517/1249 did not exist
PANIC: WAL contains references to invalid pages

The WAL record was destroyed before it could be analysed, so we can't do
much for now.

Ideas please?

--
Simon Riggs www.2ndQuadrant.com
PostgreSQL Training, Services and Support

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2008-12-17 15:12:04 Re: Invalid pages in WAL
Previous Message Pavel Stehule 2008-12-17 14:41:11 Re: Summary: changes needed in function defaults behavior