BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound
Date
Msg-id 15570-d920421b445027cc@postgresql.org
Whole thread Raw
Responses Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      15570
Logged by:          Phil Hildebrand
Email address:      phil.hildebrand@moz.com
PostgreSQL version: 10.6
Operating system:   Ubuntu 16.04.5 LTS (linux)
Description:

While running vacuum analyze before a materialized view refresh we started
seeing the following error in the logs:

 ERROR:  MultiXactId 1483293027 has not been created yet -- apparent
wraparound in the error logs 

Both selects against and pg_dumps of the table fail with the same error.

We were able narrow down the selects to at least one row / page that seems
to have problems:

select ctid,id from reviews_2018 where ctid = '(382604,16)'::tid;
    ctid     |                id                
-------------+----------------------------------
 (382604,16) | 00ec91e42d21ce0b818fe8f63ab94c66

select ctid,id from reviews_2018 where id =
'00ec91e42d21ce0b818fe8f63ab94c66';
ERROR:  MultiXactId 1483293027 has not been created yet -- apparent
wraparound

We would not expect to see this without some kind of system issue, but there
is not indication there were any system or disk issues/errors at the time.

As a workaround, we restored the table from a previous backup.

Linux info:  4.4.0-140-generic #166-Ubuntu SMP Wed Nov 14 20:09:47 UTC 2018
x86_64 x86_64 x86_64 GNU/Linux
Postgres version: PostgreSQL 10.6 (Ubuntu 10.6-1.pgdg16.04+1) on
x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0
20160609, 64-bit


pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #15569: decode function is not correclty working in 10.6
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound