Re: wal_consistency_checking reports an inconsistency on masterbranch

Поиск
Список
Период
Сортировка
От Amit Langote
Тема Re: wal_consistency_checking reports an inconsistency on masterbranch
Дата
Msg-id 0c11a775-3ff8-27fa-a7d4-d4e89761db97@lab.ntt.co.jp
обсуждение исходный текст
Ответ на Re: wal_consistency_checking reports an inconsistency on masterbranch  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On 2018/04/13 19:08, Michael Paquier wrote:
> On Fri, Apr 13, 2018 at 02:15:35PM +0530, amul sul wrote:
>> I have looked into this and found that the issue is in heap_xlog_delete -- we
>> have missed to set the correct offset number from the target_tid when
>> XLH_DELETE_IS_PARTITION_MOVE flag is set.
> 
> Oh, this looks good to me.  So when a row was moved across partitions
> this could have caused incorrect tuple references on a standby, which
> could have caused corruptions.
> 
> wal_consistency_checking is proving to be worth its cost here...

+1

Thanks,
Amit



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: wal_consistency_checking reports an inconsistency on masterbranch
Следующее
От: Amit Langote
Дата:
Сообщение: Re: crash with sql language partition support function