Postgres Pro
Downloads
Home   >   mailing lists

Re: found xmin from before relfrozenxid on pg_catalog.pg_authid - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: found xmin from before relfrozenxid on pg_catalog.pg_authid
Date
Msg-id 20180319174616.emzynyhvm2j3sby3@alvherre.pgsql
Whole thread Raw
In response to found xmin from before relfrozenxid on pg_catalog.pg_authid  (Jeremy Finzel <finzelj@gmail.com>)
Responses Re: found xmin from before relfrozenxid on pg_catalog.pg_authid  (Jeremy Finzel <finzelj@gmail.com>)
Re: found xmin from before relfrozenxid on pg_catalog.pg_authid  (Jeremy Finzel <finzelj@gmail.com>)
List pgsql-general
Tree view 
Jeremy Finzel wrote:
> Getting some concerning errors in one of our databases that is on 9.5.11,
> on autovacuum from template0 database pg_authid and pg_auth_members.  I
> only saw some notes on the list about this error related to materialized
> views.  FWIW, we did use pg_upgrade to upgrade this database from 9.4 to
> 9.5.  Here is an example:
> 
> 2018-03-19 12:08:33.946 CDT,,,14892,,5aafee91.3a2c,1,,2018-03-19 12:08:33
> CDT,59/340951,0,ERROR,XX001,"found xmin 2906288382 from before relfrozenxid
> 740087784",,,,,"automatic vacuum of table
> ""template0.pg_catalog.pg_authid""",,,,""

Can you please supply output of pg_controldata?

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: PostgreSQL 9.6 Temporary files
Next
From: Jeremy Finzel
Date:
Subject: Re: found xmin from before relfrozenxid on pg_catalog.pg_authid