XX001ERROR: found xmin from before relfrozenxid for pg_authid and pg_database

From: Brajendra Pratap Singh <singh(dot)bpratap766(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: XX001ERROR: found xmin from before relfrozenxid for pg_authid and pg_database
Date: 2021-06-21 12:38:41
Message-ID: CAFD-joO6K0+cEody+L8WWr1zVLHZbeOjR5iNfS-yOTuvHTeVrA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Good Morning...

We are getting below issue on postgresql 9.6.8 version

XX001ERROR: found xmin 3355284520 from before relfrozenxid 1097492040
XX001CONTEXT: automatic vacuum of table "xyz.pg_catalog.pg_authid"

XX001ERROR: found xmin 3355284522 from before relfrozenxid 1097492055
XX001CONTEXT: automatic vacuum of table "xyz.pg_catalog.pg_database"

# Replacing the actual DB name with xyz.

Please provide the reason and solution of this issue.

Thanks and regards,
Singh

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Kohll 2021-06-21 13:27:22 replace inside regexp_replace
Previous Message Charles Clavadetscher 2021-06-21 12:30:55 Re: user privileges