I have a table which has just started giving me the following error when trying to set a primary key, create an index or take a backup:
ERROR: MultiXactId 1092514672 has not been created yet -- apparent wraparound SQL state: XX000
After a bit of searching online, I've not found a clear solution to the issue. There is some indication it might be a bug in older versions of Postgres.
I tried taking a backup of the table using pg_dump, as one option might be to just restore a fresh version, but got the same error.
Another possible solution I came across was to run
select * from table for update;, but this also does not work with the same error given.
Running Postgres 9.4.3 on Debian 8.1. (Postgres has not been updated recently, thought I'd mention this as for some people this seems to cause the appearance of the error.)
Has anyone come across this before? Any ideas for a solution?
As suggested in the answer below from Erwin, I tried
VACUUM FREEZE tbl;, but this also returned the same error.
Update 2: I have updated to Postgres version 9.4.8. This has had no effect, the error remains.