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

From: Michael Banck <mbanck(at)gmx(dot)net>
To: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
Cc: 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: 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 09:30:32
Message-ID: 20260625093032.GA8295@p46.dedyn.io;lightning.p46.dedyn.io
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrey Borodin 2026-06-25 10:14:46 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 Hüseyin Demir 2026-06-25 07:55:59 Re: BUG #19483: pg_upgrade fails with orphan records in pg_init_priv catalog table

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2026-06-25 09:43:50 Re: RFC: Logging plan of the running query
Previous Message Ayush Tiwari 2026-06-25 09:25:52 Re: psql internals queries breaks in presence of user-defined operators