Re: Disabled logical replication origin session causes primary key errors - Mailing list pgsql-bugs

From Amit Kapila
Subject Re: Disabled logical replication origin session causes primary key errors
Date
Msg-id CAA4eK1LVKD1W0xjBzPeh1Z-UC4toCL86bD6JfbqG5SH3XzAtZA@mail.gmail.com
Whole thread Raw
In response to RE: Disabled logical replication origin session causes primary key errors  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
Responses Re: Disabled logical replication origin session causes primary key errors
List pgsql-bugs
On Wed, Apr 23, 2025 at 7:11 AM Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:
>
> > +# The bug was that the replication origin wasn’t updated whe
> > +# apply_error_callback() was called with elevel >= ERROR, and the apply
> > worker
> > +# continued running afterward.
> >
> > I think it would be better to mention the fact that the problem
> > happened when an error was caught for instance by a plpgsql function.
> > How about rewriting it as follows?
> >
> > # The bug was that when an ERROR was caught, for instance by a
> > PL/pgSQL function,
> > # the apply worker reset the replication origin but continued processing
> > # subsequent changes. This behavior resulted in a failure to update
> > the replication
> > # origin during further apply operations.
>
> I tried to describe the internal reasons of bugs, but yours did reported facts.
> +1, replaced.
>

Pushed the patch after slightly changing the comments.

--
With Regards,
Amit Kapila.



pgsql-bugs by date:

Previous
From: Andrei Lepikhov
Date:
Subject: Re: BUG #18885: ERROR: corrupt MVNDistinct entry - 2
Next
From: Tender Wang
Date:
Subject: Re: BUG #18902: TRAP:: failed Assert("!is_sorted") in File: "createplan.c"