Re: root cause of corruption in hot standby

Поиск
Список
Период
Сортировка
От Mike Broers
Тема Re: root cause of corruption in hot standby
Дата
Msg-id CAB9893gk+xUQrvhn7NnE7EukjtBn9+whkeQF2uoivBnobCM5eg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: root cause of corruption in hot standby  (Andres Freund <andres@anarazel.de>)
Список pgsql-admin
Дерево обсуждения
No I havent.  Not sure how to or what it would reveal but willing to give it a try.

On Wed, Oct 10, 2018 at 2:25 PM Andres Freund <andres@anarazel.de> wrote:
Hi,

On 2018-09-06 12:28:18 -0500, Mike Broers wrote:
> So I have discovered corruption in a postgres 9.5.12 read replica, yay
> checksums!
>
> 2018-09-06 12:00:53 CDT [1563]: [4-1] user=postgres,db=production WARNING:
> page verification failed, calculated checksum 3482 but expected 32232
>
> 2018-09-06 12:00:53 CDT [1563]: [5-1] user=postgres,db=production ERROR:
> invalid page in block 15962 of relation base/16384/464832386

Have you compared whether that block looks significantly different on
the primary from the standby with a hex editor?

Greetings,

Andres Freund

В списке pgsql-admin по дате отправления:

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: root cause of corruption in hot standby
Следующее
От: Mariel Cherkassky
Дата:
Сообщение: does work_mem is used on temp tables?