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
