Re: PANIC: heap_update_redo: no block - Mailing list pgsql-general

From Tom Lane
Subject Re: PANIC: heap_update_redo: no block
Date
Msg-id 15168.1143477904@sss.pgh.pa.us
Whole thread Raw
In response to Re: PANIC: heap_update_redo: no block  ("Qingqing Zhou" <zhouqq@cs.toronto.edu>)
List pgsql-general
"Qingqing Zhou" <zhouqq@cs.toronto.edu> writes:
> Actually I tried to simulate your situation, but everytime I got a neat
> recovery --

You probably filled the test table and then vacuumed within a single
checkpoint cycle, so that the replay sequence included loading data into
page 1 in the first place.  The risk case is fill table, checkpoint,
vacuum, crash; because then the replay starts from the checkpoint and
won't re-create page 1.

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Advantages of PostgreSQL over MySQL 5.0
Next
From: Scott Marlowe
Date:
Subject: Re: Advantages of PostgreSQL over MySQL 5.0