found xmin * from before relfrozenxid *

From: Evaldas Užpalis <evaldas(dot)u(at)bce(dot)lt>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: found xmin * from before relfrozenxid *
Date: 2019-06-10 14:48:27
Message-ID: 338c3563-bec0-ce65-9051-967dc7b8fdbe@bce.lt
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello PostgresSQL users and admins,

I need some help with my problem.

I looked at postgresql logs and it is littered with error messages like:

ERROR:  found xmin 3875696185 from before relfrozenxid 1599104090
CONTEXT:  automatic vacuum of table "FMS.pg_catalog.pg_database"
ERROR:  found xmin 3875696185 from before relfrozenxid 1599104090
CONTEXT:  automatic vacuum of table "FMS.pg_catalog.pg_authid"

ERROR:  found xmin 158590964 from before relfrozenxid 1599104090
CONTEXT:  automatic vacuum of table "FMS.pg_catalog.pg_auth_members"

First error occured 2 months ago. Database has never been crashed. Year
ago it was upgraded with pg_upgrade from version 9.2.

DB version:PostgreSQL 10.4 (Debian 10.4-2.pgdg90+1) on
x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18+deb9u1) 6.3.0
20170516, 64-bit

How can I solve theese errors?

Evaldas

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Korot 2019-06-10 16:16:36 Re: Inserting into the blob
Previous Message Adrian Klaver 2019-06-10 13:38:39 Re: Inserting into the blob