MIME-Version: 1.0
References: 
 <CAJTYsWU6tdEvVh4YKLxz7+amZ7+Wb7_s-FBjsMMeLNj1fKeSNg@mail.gmail.com>
 <ahVTk8HKRPcz4iZ-@paquier.xyz>
 <CAJTYsWWXvbBJe+WYJZcnoSTyVz9vk5ro3x2qAq_uvXvK2KwaMQ@mail.gmail.com>
 <AC1516B2-2E78-4C70-8A6E-2966F01A1058@yandex-team.ru>
 <ahVnc8-EjV6WlM5-@paquier.xyz>
 <9DF05C0C-D165-4821-80C2-FFAF47C07FF4@yandex-team.ru>
 <d52502b3-48cf-4eb4-a966-a0a46a4637de@iki.fi>
 <90F2A05B-FEEB-4695-87ED-32F53C6AC097@yandex-team.ru>
 <CA+m5N8s5QGqqxu_re+YFv9PRNrisM7D-Cqbhfj=m8FNZLrovhg@mail.gmail.com>
 <4016ab8b-84c0-4606-8a77-67ad5b157bfc@iki.fi>
 <6a3cf541.b75eb85f.2bf77.6850SMTPIN_ADDED_BROKEN@mx.google.com>
In-Reply-To: <6a3cf541.b75eb85f.2bf77.6850SMTPIN_ADDED_BROKEN@mx.google.com>
From: Emanuele <emamuse86@gmail.com>
Date: Thu, 25 Jun 2026 15:14:44 +0200
Message-ID: 
 <CA+ugDNw3Osy+6tjjHBY_5APSvfc574ckDCqd9Am3kXRqvVf_tQ@mail.gmail.com>
Subject: Re: Out-of-Cycle release? (was Re: BUG #19490: Streaming standby on
 16.14 stops applying WAL on MultiXactOffsetSLRU when primary is 16.8)
To: Michael Banck <mbanck@gmx.net>
Cc: Heikki Linnakangas <hlinnaka@iki.fi>,
 Andrey Borodin <x4mmm@yandex-team.ru>, j.karremans@jk-consult.nl,
	rmt@lists.postgresql.org,
	PostgreSQL mailing lists <pgsql-hackers@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000044053c065513c7ca"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BugDNw3Osy%2B6tjjHBY_5APSvfc574ckDCqd9Am3kXRqvVf_tQ%40mail.gmail.com>
Precedence: bulk

--00000000000044053c065513c7ca
Content-Type: text/plain; charset="UTF-8"

I had the same problem on 3 different installations Master-Replica with
version 16.11(master) and 16.14(Replica), 14.19(Master) and 14.23(Replica)
and 15.11(Master) and 15.13(Replica).

The issue is happened after patching replica at Operating System with
postgresql package too.


Il giorno gio 25 giu 2026 alle ore 11:30 Michael Banck <mbanck@gmx.net> ha
scritto:

> Hi,
>
> moving this to -hackers.
>
> On Wed, May 27, 2026 at 12:06:45PM +0300, Heikki Linnakangas wrote:
> > On 27/05/2026 05:55, Nazneen Jafri wrote:
> > > Tested Andrey's demo.diff on a fresh environment:
> > >
> > >    - Primary: REL_16_8, Standby: REL_16_14 (--enable-cassert)
> > >
> > >    - ~2300 MultiXacts crossing the offsets page boundary
> > >
> > >    - Without patch: startup deadlocks at RecordNewMultiXact(multi=2047)
> > >
> > >    - With patch: standby replays all WAL and catches up
> >
> > Thanks all. I have applied this to v14 - v16.
>
> I would like to suggest that this bug-fix might warrant an out-of-cylce
> release (even though it is has been a month since the fix got
> committed).  There has been at least one more report on pgsql-bugs[1],
> we (at credativ) have had a customer issue about it and Jan Karremans
> (in CC) mentioned this on Telegram today as well.
>
> To reiterate, this bug is a regression in the latest back-branch
> releases for versions 14-16. If either the standby gets updated to the
> latest minor release first, or if somebody does PITR from a primary on an
> earlier release to an instance with the latest minor release, the
> standby/PITR deadlocks and just sits there.
>
> I think those are pretty important/usual use-cases, so even if versions
> 17/18 are not affected (to-the-best-of-my-knowledge), maybe 14-16 should
> get a re-release for this? Or has this already been discussed among the
> release team?
>
>
> Regards,
>
> Michael
>
>
>

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

<div dir=3D"ltr">I had the same problem on 3 different installations Master=
-Replica with version 16.11(master) and 16.14(Replica), 14.19(Master) and 1=
4.23(Replica) and 15.11(Master) and 15.13(Replica).<div><br></div><div>The =
issue is happened after patching replica at Operating System with postgresq=
l package too.</div><div><br></div><div><br></div></div><br><div class=3D"g=
mail_quote gmail_quote_container"><div dir=3D"ltr" class=3D"gmail_attr">Il =
giorno gio 25 giu 2026 alle ore 11:30 Michael Banck &lt;<a href=3D"mailto:m=
banck@gmx.net">mbanck@gmx.net</a>&gt; ha scritto:<br></div><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid r=
gb(204,204,204);padding-left:1ex">Hi,<br>
<br>
moving this to -hackers.<br>
<br>
On Wed, May 27, 2026 at 12:06:45PM +0300, Heikki Linnakangas wrote:<br>
&gt; On 27/05/2026 05:55, Nazneen Jafri wrote:<br>
&gt; &gt; Tested Andrey&#39;s demo.diff on a fresh environment:<br>
&gt; &gt; <br>
&gt; &gt;=C2=A0 =C2=A0 - Primary: REL_16_8, Standby: REL_16_14 (--enable-ca=
ssert)<br>
&gt; &gt; <br>
&gt; &gt;=C2=A0 =C2=A0 - ~2300 MultiXacts crossing the offsets page boundar=
y<br>
&gt; &gt; <br>
&gt; &gt;=C2=A0 =C2=A0 - Without patch: startup deadlocks at RecordNewMulti=
Xact(multi=3D2047)<br>
&gt; &gt; <br>
&gt; &gt;=C2=A0 =C2=A0 - With patch: standby replays all WAL and catches up=
<br>
&gt; <br>
&gt; Thanks all. I have applied this to v14 - v16.<br>
<br>
I would like to suggest that this bug-fix might warrant an out-of-cylce<br>
release (even though it is has been a month since the fix got<br>
committed).=C2=A0 There has been at least one more report on pgsql-bugs[1],=
<br>
we (at credativ) have had a customer issue about it and Jan Karremans<br>
(in CC) mentioned this on Telegram today as well.<br>
<br>
To reiterate, this bug is a regression in the latest back-branch<br>
releases for versions 14-16. If either the standby gets updated to the<br>
latest minor release first, or if somebody does PITR from a primary on an<b=
r>
earlier release to an instance with the latest minor release, the<br>
standby/PITR deadlocks and just sits there.<br>
<br>
I think those are pretty important/usual use-cases, so even if versions<br>
17/18 are not affected (to-the-best-of-my-knowledge), maybe 14-16 should<br=
>
get a re-release for this? Or has this already been discussed among the<br>
release team?<br>
<br>
<br>
Regards,<br>
<br>
Michael<br>
<br>
<br>
</blockquote></div>

--00000000000044053c065513c7ca--