Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Daulat <daulat(dot)dba(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen
Date: 2024-03-22 10:09:29
Message-ID: 4fde193ef41d7e7e00d3cd2fa4ceb55ade77f433.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, 2024-03-22 at 13:41 +0530, Daulat wrote:
> We are unable to take the backup of our database. While taking backup we are getting the same error. 
>
> psql: error: connection to server at "localhost" (::1), port 5014 failed: FATAL:  pg_attribute catalog is missing 1 attribute(s) for relation OID 2662

Then you got severe data corruption. This is the index "pg_class_oid_index",
and corrupted metadata make recovery difficult.

If I were you, I would seek professional help.
But first, stop working with this database immediately.
Stop the server and take a backup of all the files in the data
directory.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2024-03-22 10:10:42 Re: pg_locks-exclusivelock for select queries
Previous Message Daulat 2024-03-22 08:11:31 Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen