Re: ERROR: found multixact from before relminmxid

From: Adrien NAYRAT <adrien(dot)nayrat(at)anayrat(dot)info>
To: <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: ERROR: found multixact from before relminmxid
Date: 2018-11-07 12:05:15
Message-ID: 101e1579-47e6-7b60-b587-b2dc96c70a0a@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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,

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alexandre Arruda 2018-11-07 12:21:57 Re: ERROR: found multixact from before relminmxid
Previous Message Ravi Krishna 2018-11-07 11:54:27 Re: why select count(*) consumes wal logs