On Fri, 2024-03-22 at 10:56 +0530, Daulat wrote: > We recently started seeing an error “ERROR: uncommitted xmin 3100586 > from before xid cutoff 10339367 needs to be frozen” on our user tables. > I’m unable to do ‘vacuum’, ‘vacuum freeze’ or ‘vacuum full’ on Postgres 14.4 running on a windows environment. > > Error: > > first come this---- ERROR: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen > CONTEXT: while scanning block 1403 offset 8 of relation "pg_catalog.pg_attribute" Update to 14.latest; perhaps that data corruption was caused by a bug that is already fixed. Upgrading won't get rid of the error though (I think). The seasy way is to dump the database and restore it to a new database. Yours, Laurenz Albe
