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

From: Daulat <daulat(dot)dba(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen
Date: 2024-03-22 05:26:31
Message-ID: CALfOM6+xd_HU-E7f7mACxf8ZdBV-asxdAsWVCO7rsb+Em4feXg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2024-03-22 07:05:53 Re: uncommitted xmin 3100586 from before xid cutoff 10339367 needs to be frozen
Previous Message veem v 2024-03-22 04:47:44 Re: Not able to purge partition