Re: 12.3 replicas falling over during WAL redo

Поиск
Список
Период
Сортировка
От Ben Chobot
Тема Re: 12.3 replicas falling over during WAL redo
Дата
Msg-id f0990521-9839-5317-a91a-66bd919f5202@silentmedia.com
обсуждение исходный текст
Ответ на Re: 12.3 replicas falling over during WAL redo  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: 12.3 replicas falling over during WAL redo  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-general
Alvaro Herrera wrote on 8/3/20 12:34 PM:
> On 2020-Aug-03, Ben Chobot wrote:
>
> Yep. Looking at the ones in block 6501,
>
>> rmgr: Btree       len (rec/tot):     72/    72, tx:   76393394, lsn:
>> A0A/AB2C43D0, prev A0A/AB2C4378, desc: INSERT_LEAF off 41, blkref #0: rel
>> 16605/16613/60529051 blk 6501
>> rmgr: Btree       len (rec/tot):     72/    72, tx:   76396065, lsn:
>> A0A/AC4204A0, prev A0A/AC420450, desc: INSERT_LEAF off 48, blkref #0: rel
>> 16605/16613/60529051 blk 6501
> My question was whether the block has received the update that added the
> item in offset 41; that is, is the LSN in the crashed copy of the page
> equal to A0A/AB2C43D0?  If it's an older value, then the write above was
> lost for some reason.

How do I tell?



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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: 12.3 replicas falling over during WAL redo
Следующее
От: Shankar Bhaskaran
Дата:
Сообщение: Configuring only SSL in postgres docker image