I face an annoying problem on a Postgres 11.13 database when trying to get data from a big table. The first 6 millions rows can be fetched, then I get a "MultiXactId **** has not been created yet -- apparent wraparound" message.
I've already tested, on this table :
- various "select ..." queries (even in functions with exception management to ignore possible errors)
- pg_dump
- REINDEX TABLE
- VACUUM FULL, with and without the zero_damaged_pages enabled
- VACUUM FREEZE, with and without the zero_damaged_pages enabled
Nothing to do: I get every time that "MultiXactId **** has not been created yet -- apparent wraparound" error.
Is there a solution to fix that kind of problem, or is that "broken/corrupted" table definitively lost ?
Thanks in advance for any advice