BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound
От | PG Bug reporting form |
---|---|
Тема | BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound |
Дата | |
Msg-id | 15570-d920421b445027cc@postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #15570: Vacuum analyze ERROR: MultiXactId XXXX has not beencreated yet -- apparent wraparound
|
Список | 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 по дате отправления: