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

From: Alanoly Andrews <alanolya(at)invera(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: ERROR: found xmin from before relfrozenxid; MultiXactid does no longer exist -- apparent wraparound
Date: 2024-05-30 14:58:41
Message-ID: YQBPR01MB10625A12760CAECAE647F415EABF32@YQBPR01MB10625.CANPRD01.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)invera(dot)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.'.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message José Mello Júnior 2024-05-30 17:27:56 Re: Dll libpq.dll 32 bits
Previous Message Francisco Olarte 2024-05-30 11:02:52 Re: Memory issues with PostgreSQL 15