Re: ERROR: found multixact from before relminmxid

Поиск
Список
Период
Сортировка
От Adrien NAYRAT
Тема Re: ERROR: found multixact from before relminmxid
Дата
Msg-id 101e1579-47e6-7b60-b587-b2dc96c70a0a@anayrat.info
обсуждение исходный текст
Ответ на Re: ERROR: found multixact from before relminmxid  (Adrien NAYRAT <adrien.nayrat@anayrat.info>)
Ответы Re: ERROR: found multixact from before relminmxid  (Alexandre Arruda <adaldeia@gmail.com>)
Список pgsql-general
On 11/5/18 5:41 PM, Adrien NAYRAT wrote:
> We "solved" with a dump/restore on another server, also we kept previous 
> cluster to investigate. I want to be sure we encountered the bug solved 
> in 9.6.9 and it is not a new one.

FYI, I am not sure I will be able to keep previous cluster many days.

> 
> If we confirm it, maybe we should advise users to perform integrity 
> check? I was surprised 9.6.9 avoid new appearance of corruption but 
> nothing to ensure if database is already corrupted.

If I understand correctly, it seems related to vacuum skipping page 
already frozen. Maybe we should advise to do a VACUUM FREEZE with 
DISABLE_PAGE_SKIPPING option?

Regards,


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

Предыдущее
От: Ravi Krishna
Дата:
Сообщение: Re: why select count(*) consumes wal logs
Следующее
От: Alexandre Arruda
Дата:
Сообщение: Re: ERROR: found multixact from before relminmxid