Re: PG 12.2 ERROR: cannot freeze committed xmax

From: bruno vieira da silva <brunogiovs(at)gmail(dot)com>
To: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: PG 12.2 ERROR: cannot freeze committed xmax
Date: 2024-05-24 10:31:18
Message-ID: CAB+Nuk_x7_8f_jKx7sHvxEYhvy6sQPFnNZ4p=BHB1_hcPsgaHw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thanks Ron.

I did find one bug fix commit mentioning this error but it was saying that
was due to the interaction of two other commits that at least the first one
was after the cut of pg 12.2. so I have dismissed that as my deployment
issue.

I was looking for more evidence to push for a pg minor upgrade, the issue
is for my context any upgrades requires a big test effort. so I was looking
for more solid evidence.

On Thu, May 23, 2024 at 7:17 PM Ron Johnson <ronljohnsonjr(at)gmail(dot)com> wrote:

> On Thu, May 23, 2024 at 9:41 AM bruno da silva <brunogiovs(at)gmail(dot)com>
> wrote:
>
>> Hello,
>> I have a deployment with PG 12.2 reporting ERROR: cannot freeze
>> committed xmax
>> using Red Hat Enterprise Linux 8.9.
>>
>> What is the recommended to find any bug fixes that the version 12.2 had
>> that could have caused this error.
>>
>
> https://www.postgresql.org/docs/release/
>
> You're missing *four years* of bug fixes.
>
> Could this error be caused by OS/Hardware related issues?
>>
>
> Four years of bug fixes is more likely the answer.
>
>

--
Bruno Vieira da Silva

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Joseph Krogh 2024-05-24 15:51:59 prevent users from SELECT-ing from pg_roles/pg_database
Previous Message Laurenz Albe 2024-05-24 09:37:13 Re: Json table/column design question