Postgres Pro
Downloads
Home   >   mailing lists

uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen - Mailing list pgsql-general

From Daulat
Subject uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen
Date
Msg-id CALfOM6+xd_HU-E7f7mACxf8ZdBV-asxdAsWVCO7rsb+Em4feXg@mail.gmail.com
Whole thread Raw
Responses Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
Hi All,

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"

Thanks,
Daulat

pgsql-general by date:

Previous
From: veem v
Date:
Subject: Re: Not able to purge partition
Next
From: Laurenz Albe
Date:
Subject: Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen