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