| 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
>
| 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 |