Postgres Pro
Downloads
Home   >   mailing lists

Re: postgresql 9.6 - cannot freeze committed xmax - Mailing list pgsql-admin

From Andres Freund
Subject Re: postgresql 9.6 - cannot freeze committed xmax
Date
Msg-id 20180228212401.6yoqyv2a45zv7ph6@alap3.anarazel.de
Whole thread Raw
In response to Re: postgresql 9.6 - cannot freeze committed xmax  (Alexandre Garcia <alexandre@vmfarms.com>)
Responses Re: postgresql 9.6 - cannot freeze committed xmax  (Alexandre Garcia <alexandre@vmfarms.com>)
Re: postgresql 9.6 - cannot freeze committed xmax  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-admin
Tree view 
Hi Alexandre, Alvaro,

Please not that we try not to top-post on this list.

Alvaro,

On 2018-02-28 21:17:08 +0000, Alexandre Garcia wrote:
> Oh yes sorry => `ERROR:  cannot freeze committed xmax 43076385` on that
> same table

In light of
Latest checkpoint's NextXID:          0/128653693
I find this confusing.

Alexandre, did you ever use pg_resetxlog on that cluster?

Greetings,

Andres Freund

pgsql-admin by date:

Previous
From: MichaelDBA
Date:
Subject: Re: Postgresql | Vacuum information
Next
From: Alexandre Garcia
Date:
Subject: Re: postgresql 9.6 - cannot freeze committed xmax