Re: Standby server with cascade logical replication could not be properly stopped under load

From: "G(dot) Sl" <skokoveshat(at)gmail(dot)com>
To: Michael Paquier <michael(at)paquier(dot)xyz>
Cc: Ajin Cherian <itsajin(at)gmail(dot)com>, Alexey Makhmutov <a(dot)makhmutov(at)postgrespro(dot)ru>, Bertrand Drouvot <bertranddrouvot(dot)pg(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Standby server with cascade logical replication could not be properly stopped under load
Date: 2025-12-26 11:14:17
Message-ID: CABPnX-ZrhHwvPr2LgjWF0S1kjgSELXkdnfBK-su2ue562DjyHA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Michael !
I've found the same behaviour in the 15.12 version. Any chances for
backpatch for this version ?
--
Best regards
Gennadiy S.
On Fri, 26 Dec 2025 at 16:11, Michael Paquier <michael(at)paquier(dot)xyz> wrote:

> On Fri, May 30, 2025 at 08:32:05AM +0900, Michael Paquier wrote:
> > On Thu, May 29, 2025 at 08:28:01PM +1000, Ajin Cherian wrote:
> >> I think this new fix is much better and cleaner. A suggestion for the
> >> comment:
> >> "For cascading logical WAL senders, we use the replay LSN instead of the
> >> flush LSN, since logical decoding on a standby only processes WAL that
> has
> >> been replayed. This distinction becomes particularly important during
> >> shutdown, as new WAL is no longer replayed and the last replayed LSN
> marks
> >> the furthest point up to which decoding can proceed."
> >
> > Yes, that sounds better than my previous suggestion. Thanks.
>
> I have reused that wording, did more tests on v16 and v17, reproducing
> both the problems reported and that the change fixes the shutdown of
> the physical standby, then applied the change down to v16.
>
> Thanks all.
> --
> Michael
>

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2025-12-26 15:07:59 BUG #19363: PostgreSQL shared memory exhaustion during query execution involving views and parallel workers
Previous Message ZhangChi 2025-12-26 07:59:57 Re: BUG #19356: Unexpected result of prepared UPDATE with force_generic_plan