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

From Qingqing Zhou
Subject Re: [GENERAL] PANIC: heap_update_redo: no block
Date
Msg-id e0ls0h$1fdi$1@news.hub.org
Whole thread Raw
In response to Re: [GENERAL] PANIC: heap_update_redo: no block  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
"Qingqing Zhou" <zhouqq@cs.toronto.edu> wrote
>
> "Tom Lane" <tgl@sss.pgh.pa.us> wrote
>>
>> What we should be seeing, and don't see, is an indication of a backup
>> block attached to this WAL record.  Furthermore, I don't see any
>> indication of a backup block attached to *any* of the WAL records in
>> Alex's printout.  The only conclusion I can draw is that he had
>> full_page_writes turned OFF, and as we have just realized that that
>> setting is completely unsafe, that is the explanation for his failure.
>>
>

According to Alex, seems the problem is not because of full_page_writes OFF

>
>> According to the discussion in pgsql-hackers, to finish this case, did 
>> you
>> turn off the full_page_writes parameter? I hope the answer is "yes" ...
>>
>
> If by off you mean full_page_writes = on then yes.


Regards,
Qingqing





pgsql-hackers by date:

Previous
From: Thomas Hallgren
Date:
Subject: Remote PL/Java, Summary
Next
From: Andrew Dunstan
Date:
Subject: Re: Remote PL/Java, Summary