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

From Wong, Yi Wen
Subject Re: Error on vacuum: xmin before relfrozenxid
Date
Msg-id 1527193504642.36340@amazon.com
Whole thread Raw
In response to Re: Error on vacuum: xmin before relfrozenxid  (Andres Freund <andres@anarazel.de>)
List pgsql-general
Hello,

We have also seen this issue ourselves and are actively working on it. We do not have a definite proposed solution or
fullRCA yet, but we have managed to narrow down the cause to stale values of relfrozenxid in the relcache for shared
relations.

We are in the process of coming up with a repro as well.

A proposed workaround to this issue is to delete global/pg_internal.init. That will allow a vacuum of the shared
relationto proceed. 

Thanks,

Yi Wen Wong



pgsql-general by date:

Previous
From: Paolo Crosato
Date:
Subject: Re: Error on vacuum: xmin before relfrozenxid
Next
From: Andres Freund
Date:
Subject: Re: found xmin from before relfrozenxid on pg_catalog.pg_authid