Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Fri, 2024-03-22 at 16:07 +0530, Vijaykumar Jain wrote:
> On Fri, 22 Mar 2024 at 15:39, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
> > 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.
> 
> Do we have an option that op has a replica running and the bug has not propagated to the replica

No.  Feel free to check on the standby, it should have the same problem.

Yours,
Laurenz Albe






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux