Re: ERROR: found multixact from before relminmxid - Mailing list pgsql-general

From Peter Geoghegan
Subject Re: ERROR: found multixact from before relminmxid
Date
Msg-id CAH2-Wzn=Y3aY_2F21EWGYPonBjzMHb18wN_HND51hSD3BKGXdQ@mail.gmail.com
Whole thread Raw
In response to Re: ERROR: found multixact from before relminmxid  (Alexandre Arruda <adaldeia@gmail.com>)
Responses Re: ERROR: found multixact from before relminmxid  (Andres Freund <andres@anarazel.de>)
Re: ERROR: found multixact from before relminmxid  (Alexandre Arruda <adaldeia@gmail.com>)
List pgsql-general
On Mon, Apr 9, 2018 at 6:56 PM, Alexandre Arruda <adaldeia@gmail.com> wrote:
> (... and all other indexes returns null too)
>
> I tried with bt_index_check too. Same results.

That's interesting, because it tells me that you have a table that
appears to not be corrupt, despite the CLUSTER error. Also, the error
itself comes from sanity checking added to MultiXact freezing fairly
recently, in commit 699bf7d0.

You didn't say anything about regular VACUUM being broken. Do you find
that it works without any apparent issue?

I have a suspicion that this could be a subtle bug in
CLUSTER/freezing. The only heap_freeze_tuple() caller is code used by
CLUSTER, so it's not that hard to imagine a MultiXact freezing bug
that is peculiar to CLUSTER. Though I haven't thought about it in much
detail.

-- 
Peter Geoghegan


pgsql-general by date:

Previous
From: Alexandre Arruda
Date:
Subject: Re: ERROR: found multixact from before relminmxid
Next
From: Andres Freund
Date:
Subject: Re: ERROR: found multixact from before relminmxid