Re: Out-of-Cycle release? (was Re: BUG #19490: Streaming standby on 16.14 stops applying WAL on MultiXactOffsetSLRU when primary is 16.8)

From: Emanuele <emamuse86(at)gmail(dot)com>
To: Michael Banck <mbanck(at)gmx(dot)net>
Cc: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>, Andrey Borodin <x4mmm(at)yandex-team(dot)ru>, j(dot)karremans(at)jk-consult(dot)nl, rmt(at)lists(dot)postgresql(dot)org, PostgreSQL mailing lists <pgsql-hackers(at)lists(dot)postgresql(dot)org>
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)
Date: 2026-06-25 13:14:44
Message-ID: CA+ugDNw3Osy+6tjjHBY_5APSvfc574ckDCqd9Am3kXRqvVf_tQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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(at)gmx(dot)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
>
>
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sebastiaan Mannem 2026-06-25 13:43:32 Re: Out-of-Cycle release? (was Re: BUG #19490: Streaming standby on 16.14 stops applying WAL on MultiXactOffsetSLRU when primary is 16.8)
Previous Message Amit Langote 2026-06-25 12:21:15 Re: BUG #19484: Segmentation fault triggered by FDW

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Langote 2026-06-25 13:17:13 Re: In core use of RegisterXactCallback() and RegisterSubXactCallback()
Previous Message Amit Kapila 2026-06-25 13:07:06 Re: Proposal: Conflict log history table for Logical Replication