Hello All,
I am running postgres 9.4.8 on centos 7 and few days ago I started to get this error MultiXactId 32766 has not been created yet -- apparent wraparound in 2 instances.
1. On one database server during the nightly task that does the "vacuum analyze". I upgraded to postgres 9.4.9 as there is a reference to a bug fixed with a reference to this error but I am still getting the same error when I vacuum analyze. This database was created using pg_dump and pg_restore (not pg_upgrade) from the previous installation which was still postgres 9.4.6 but on SLES instead of CentOS. I only have one postgres version installed on the server.
Autovacuum is turned on and I also have a task that runs vacuum analyze every night.
postgresql94-9.4.9-1PGDG.rhel7.x86_64
postgresql94-plperl-9.4.9-1PGDG.rhel7.x86_64
postgresql94-libs-9.4.9-1PGDG.rhel7.x86_64
postgresql94-server-9.4.9-1PGDG.rhel7.x86_64
postgresql94-contrib-9.4.9-1PGDG.rhel7.x86_64
psql (9.4.9)
=# vacuum analyze;
ERROR: MultiXactId 32766 has not been created yet -- apparent wraparound
This server only runs since June 2016.
2. The second instance of this error is on a new database server during pg_restore on few CREATE INDEX, PRIMARY KEYS and FOREIGN KEYS statements (postgres 9.4.8 on centos 7). In this case I dropped and recreated the database and the second try succeeded without errors.
postgresql-14.csv:2016-08-14 05:33:59.753 CST,"postgres","test",19555,"[local]",57b055d4.4c63,11,"CREATE INDEX",2016-08-14 05:28:20 CST,1/27230,5381,ERROR,XX000,"MultiXactId 1667854355 has not been created yet -- apparent wraparound",,,,,,"CREATE INDEX...;
Please let me know if I should provide more info.
Thank you in advance,
Ioana
