Re: [GENERAL] PANIC: heap_update_redo: no block - Mailing list pgsql-hackers

From Greg Stark
Subject Re: [GENERAL] PANIC: heap_update_redo: no block
Date
Msg-id 87lkuvtulu.fsf@stark.xeocode.com
Whole thread Raw
In response to Re: [GENERAL] PANIC: heap_update_redo: no block  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [GENERAL] PANIC: heap_update_redo: no block
Re: [GENERAL] PANIC: heap_update_redo: no block
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us> writes:

> I think what's happened here is that VACUUM FULL moved the only tuple
> off page 1 of the relation, then truncated off page 1, and now
> heap_update_redo is panicking because it can't find page 1 to replay the
> move.  Curious that we've not seen a case like this before, because it
> seems like a generic hazard for WAL replay.

This sounds familiar

http://archives.postgresql.org/pgsql-hackers/2005-05/msg01369.php


-- 
greg



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: proposal - plpgsql: execute using into
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] PANIC: heap_update_redo: no block