MIME-Version: 1.0
References: <CAB+Nuk-kVKvW6Whfq-fH44PATZWG8fUdnP7jC+Kthbq3Ly9CqQ@mail.gmail.com>
 <CANzqJaBfH97t21=+P1O3+QyAYoNurBgSrCP-fr=28NVNHanBGA@mail.gmail.com>
In-Reply-To: <CANzqJaBfH97t21=+P1O3+QyAYoNurBgSrCP-fr=28NVNHanBGA@mail.gmail.com>
From: bruno vieira da silva <brunogiovs@gmail.com>
Date: Fri, 24 May 2024 06:31:18 -0400
Message-ID: <CAB+Nuk_x7_8f_jKx7sHvxEYhvy6sQPFnNZ4p=BHB1_hcPsgaHw@mail.gmail.com>
Subject: Re: PG 12.2 ERROR: cannot freeze committed xmax
To: Ron Johnson <ronljohnsonjr@gmail.com>
Cc: pgsql-general@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000c194e6061930ab29"
Archived-At: <https://www.postgresql.org/message-id/CAB%2BNuk_x7_8f_jKx7sHvxEYhvy6sQPFnNZ4p%3DBHB1_hcPsgaHw%40mail.gmail.com>
Precedence: bulk

--000000000000c194e6061930ab29
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM Ron Johnson <ronljohnsonjr@gmail.co=
m> wrote:

> On Thu, May 23, 2024 at 9:41=E2=80=AFAM bruno da silva <brunogiovs@gmail.=
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.
>
>

--=20
Bruno Vieira da Silva

--000000000000c194e6061930ab29
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Thanks Ron.<div><br></div><div>I did find one bug fix comm=
it 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=C2=A0that as my deployment issue.</div><div><br></d=
iv><div>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.</div><div><br></div></div><br><div class=
=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Thu, May 23, 2024=
 at 7:17=E2=80=AFPM Ron Johnson &lt;<a href=3D"mailto:ronljohnsonjr@gmail.c=
om">ronljohnsonjr@gmail.com</a>&gt; wrote:<br></div><blockquote class=3D"gm=
ail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,=
204,204);padding-left:1ex"><div dir=3D"ltr"><div dir=3D"ltr">On Thu, May 23=
, 2024 at 9:41=E2=80=AFAM bruno da silva &lt;<a href=3D"mailto:brunogiovs@g=
mail.com" target=3D"_blank">brunogiovs@gmail.com</a>&gt; wrote:<br></div><d=
iv class=3D"gmail_quote"><blockquote class=3D"gmail_quote" style=3D"margin:=
0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">=
<div dir=3D"ltr">Hello,<div>I have a deployment with PG 12.2 reporting=C2=
=A0<span style=3D"color:rgb(29,28,29);font-family:Monaco,Menlo,Consolas,&qu=
ot;Courier New&quot;,monospace;font-size:12px;font-variant-ligatures:none;b=
ackground-color:rgba(29,28,29,0.04)">ERROR:  cannot freeze committed xmax</=
span></div><div><font color=3D"#1d1c1d" face=3D"Monaco, Menlo, Consolas, Co=
urier New, monospace"><span style=3D"font-size:12px;font-variant-ligatures:=
none">using </span></font>Red Hat Enterprise Linux 8.9.</div><div><br></div=
><div>What is the recommended=C2=A0to find any bug fixes that the version 1=
2.2 had that could have caused this error.=C2=A0</div></div></blockquote><d=
iv><br></div><div><a href=3D"https://www.postgresql.org/docs/release/" targ=
et=3D"_blank">https://www.postgresql.org/docs/release/</a><br></div><div><b=
r></div><div>You&#39;re missing <b>four years</b>=C2=A0of bug fixes.=C2=A0<=
/div><div><br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px 0=
px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div =
dir=3D"ltr"><div>Could this error be caused by OS/Hardware related issues?<=
/div></div></blockquote><div><br></div><div>=C2=A0Four years of bug fixes i=
s more likely the answer.<br></div><div><br></div></div></div>
</blockquote></div><br clear=3D"all"><div><br></div><span class=3D"gmail_si=
gnature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signature"><d=
iv dir=3D"ltr">Bruno Vieira da Silva<br></div></div>

--000000000000c194e6061930ab29--