Re: ERROR: found xmin 2706850882 from before relfrozenxid 126900049

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Vivek Gadge <vvkgadge56(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: ERROR: found xmin 2706850882 from before relfrozenxid 126900049
Date: 2022-05-28 14:05:05
Message-ID: 20220528140505.GA29999@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, May 27, 2022 at 10:20:46PM +0530, Vivek Gadge wrote:
> We are getting below error message . Could you please help us regrading it.
> I am using pg v10.3.
> ERROR: found xmin 2706850882 from before relfrozenxid 126900049
> > > CONTEXT: automatic vacuum of table "db_1 pg. catalog.pg_tablespace".

Please upgrade to *at least* 10.5:

https://why-upgrade.depesz.com/show?from=10.3&to=10.21&keywords=relfrozenxid

But preferably - all the way to 10.21. Also, please note that Pg 10 will
stop being supported this year.

Best regards,

depesz

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message jian xu 2022-05-29 15:29:55 how to calibrate the cost model parameters
Previous Message Nikhil Shetty 2022-05-27 18:41:31 Adding more detail to pg_upgrade documentation