ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound - Mailing list pgsql-general

From Alanoly Andrews
Subject ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound
Date
Msg-id YQBPR01MB10625A12760CAECAE647F415EABF32@YQBPR01MB10625.CANPRD01.PROD.OUTLOOK.COM
Whole thread Raw
Responses Re: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound
List pgsql-general
Hi,

We have a postgres 10.7 database which reports a number of issues on user-created tables as well as system tables. Most errors are one of the following:
-- ERROR:  found xmin 1888159934 from before relfrozenxid 1998177448
-- ERROR:  MultiXactId 613819197 does no longer exist -- apparent wraparound
-- ERROR:  could not access status of transaction 1927393975
   DETAIL:  Could not open file "pg_xact/072E": No such file or directory.

I have tried several of the workarounds suggested online and in the web discussion groups:
1. vacuumdb of the entire database fails with the "found xmin from before relfrozenxid" error
2. pg_dump fails with the same error
3. SELECT sql on the affected tables fails with the error. So I cannot save the table, drop it and re-create it.
4. Removed the "global/pg_internal.init" file and re-started the cluster. Still the same errors.

The database is up and running and most of the tables are accessible. But any kind of SQL on the 4 or 5 affected tables throws the error.

Is there a way to repairing the corruption in this database?
Postgres Version 10.7 on Linux(Ubuntu).

Thanks.

Alanoly Andrews
(alanolya@invera.com)

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courriel est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un autre moyen.'.

pgsql-general by date:

Previous
From: Francisco Olarte
Date:
Subject: Re: Memory issues with PostgreSQL 15
Next
From: José Mello Júnior
Date:
Subject: Re: Dll libpq.dll 32 bits