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