Re: Error on vacuum: xmin before relfrozenxid - Mailing list pgsql-general

From Andres Freund
Subject Re: Error on vacuum: xmin before relfrozenxid
Date
Msg-id 20180522233957.zbflihb5qrsh3vqp@alap3.anarazel.de
Whole thread Raw
In response to Re: Error on vacuum: xmin before relfrozenxid  (Paolo Crosato <paolo.crosato@gmail.com>)
Responses Re: Error on vacuum: xmin before relfrozenxid  (Paolo Crosato <paolo.crosato@gmail.com>)
Re: Error on vacuum: xmin before relfrozenxid  (Paolo Crosato <paolo.crosato@gmail.com>)
Re: Error on vacuum: xmin before relfrozenxid  (Andres Freund <andres@anarazel.de>)
Re: Error on vacuum: xmin before relfrozenxid  (Andres Freund <andres@anarazel.de>)
Re: Error on vacuum: xmin before relfrozenxid  ("Wong, Yi Wen" <yiwong@amazon.com>)
Re: Error on vacuum: xmin before relfrozenxid  ("Wong, Yi Wen" <yiwong@amazon.com>)
List pgsql-general
Hi,

On 2018-05-23 00:04:26 +0200, Paolo Crosato wrote:
> I managed to recover the log of the first time we run into the issue, the
> error was the same but on template1:
> 
> May  8 11:26:46 xxx postgres[32543]: [1154-1] user=,db=,client= ERROR:
> found xmin 2600758304 from before relfrozenxid 400011439
> May  8 11:26:46 xxx postgres[32543]: [1154-2] user=,db=,client= CONTEXT:
> automatic vacuum of table "template1.pg_catalog.pg_authid"

pg_authid (along with a few other tables) is shared between
databases. So that's just hte same error.  At which rate are you
creating / updating database users / roles?

Greetings,

Andres Freund


pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: pg_multixact/members growing
Next
From: Kyotaro HORIGUCHI
Date:
Subject: Re: Errors with physical replication