Re: [GENERAL] PANIC: heap_update_redo: no block

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: [GENERAL] PANIC: heap_update_redo: no block
Дата
Msg-id e0ls0h$1fdi$1@news.hub.org
обсуждение исходный текст
Ответ на Re: [GENERAL] PANIC: heap_update_redo: no block  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Thomas Hallgren
Дата:
Сообщение: Remote PL/Java, Summary
Следующее
От: Andrew Dunstan
Дата:
Сообщение: Re: Remote PL/Java, Summary