public inbox for [email protected]  

help / color / mirror / Atom feed

From: Emanuele <[email protected]>
To: Michael Banck <[email protected]>
Cc: Heikki Linnakangas <[email protected]>
Cc: Andrey Borodin <[email protected]>
Cc: [email protected]
Cc: [email protected]
Cc: PostgreSQL mailing lists <[email protected]>
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: Thu, 25 Jun 2026 15:14:44 +0200
Message-ID: <CA+ugDNw3Osy+6tjjHBY_5APSvfc574ckDCqd9Am3kXRqvVf_tQ@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJTYsWU6tdEvVh4YKLxz7+amZ7+Wb7_s-FBjsMMeLNj1fKeSNg@mail.gmail.com>
	<[email protected]>
	<CAJTYsWWXvbBJe+WYJZcnoSTyVz9vk5ro3x2qAq_uvXvK2KwaMQ@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<CA+m5N8s5QGqqxu_re+YFv9PRNrisM7D-Cqbhfj=m8FNZLrovhg@mail.gmail.com>
	<[email protected]>
	<[email protected]>

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 <[email protected]> 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
>
>
>

view thread (27+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  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)
  In-Reply-To: <CA+ugDNw3Osy+6tjjHBY_5APSvfc574ckDCqd9Am3kXRqvVf_tQ@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox