Re: postgresql 9.6 - cannot freeze committed xmax

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Alexandre Garcia <alexandre@xxxxxxxxxxx>
Subject: Re: postgresql 9.6 - cannot freeze committed xmax
From: Andres Freund <andres@xxxxxxxxxxx>
Date: Wed, 28 Feb 2018 13:24:01 -0800
Cc: Alvaro Herrera <alvherre@xxxxxxxxxxxxxx>, "pgsql-admin@xxxxxxxxxxxxxx" <pgsql-admin@xxxxxxxxxxxxxx>
In-reply-to: <CAPYLKR6Tybsp=_26HZ6MN_J1S9MUr2bHvgeROR+Jpy0EBN6j_w@mail.gmail.com>
References: <CAPYLKR6yxV4=pfW0Gwij7aPNiiPx+3ib4USVYnbuQdUtmkMaEA@mail.gmail.com> <20180226230931.3m7js5dkzxnu7tbi@alvherre.pgsql> <20180226232113.a3aqlzpckcue4drt@alap3.anarazel.de> <CAPYLKR5h8_zm92wrCSqnszfiBauZ6MMVXQfq57cGDxZ579DfcA@mail.gmail.com> <20180228211621.vikbp5s3rwg47455@alap3.anarazel.de> <CAPYLKR6Tybsp=_26HZ6MN_J1S9MUr2bHvgeROR+Jpy0EBN6j_w@mail.gmail.com>

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

Follow-Ups:
- Re: postgresql 9.6 - cannot freeze committed xmax
  - From: Alvaro Herrera
- Re: postgresql 9.6 - cannot freeze committed xmax
  - From: Alexandre Garcia

References:
- postgresql 9.6 - cannot freeze committed xmax
  - From: Alexandre Garcia
- Re: postgresql 9.6 - cannot freeze committed xmax
  - From: Alvaro Herrera
- Re: postgresql 9.6 - cannot freeze committed xmax
  - From: Andres Freund
- Re: postgresql 9.6 - cannot freeze committed xmax
  - From: Alexandre Garcia
- Re: postgresql 9.6 - cannot freeze committed xmax
  - From: Andres Freund
- Re: postgresql 9.6 - cannot freeze committed xmax
  - From: Alexandre Garcia

Prev by Date: Re: Postgresql | Vacuum information
Next by Date: Re: postgresql 9.6 - cannot freeze committed xmax
Previous by thread: Re: postgresql 9.6 - cannot freeze committed xmax
Next by thread: Re: postgresql 9.6 - cannot freeze committed xmax
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]