Re: Invalid pages in WAL - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Invalid pages in WAL
Date
Msg-id 494916C4.4050801@enterprisedb.com
Whole thread Raw
In response to Invalid pages in WAL  (Simon Riggs <simon@2ndQuadrant.com>)
Responses Re: Invalid pages in WAL
List pgsql-hackers
Simon Riggs wrote:
> 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.

Hmm, could well be related to the visibility map or FSM. Although those 
messages suggest that it's a heap/index page that's missing, not FSM or 
VM page. Any idea how to reproduce that?

--   Heikki Linnakangas  EnterpriseDB   http://www.enterprisedb.com


pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Invalid pages in WAL
Next
From: Martin Pihlak
Date:
Subject: Re: SQL/MED compatible connection manager