Re: Session in aborted transaction misses effective_wal_level change

From: Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
To: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
Cc: Sergei Patiakin <sergei(dot)patiakin(at)enterprisedb(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "msawada(at)postgresql(dot)org" <msawada(at)postgresql(dot)org>
Subject: Re: Session in aborted transaction misses effective_wal_level change
Date: 2026-10-02 20:54:04
Message-ID: CAD21AoBbSQE1=XhaEy70B-fH4-UPnAqXAkMj4qE+ftOic_dyYw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Wed, Sep 30, 2026 at 11:28 PM Hayato Kuroda (Fujitsu)
<kuroda(dot)hayato(at)fujitsu(dot)com> wrote:
>
> Dear Sawada-san, Serigei,
>
> Good catch, I have also been seeing and considering the test, but Sawada-san is faster.
>
> > The fix looks good to me. We need to check and update XLogLogicalInfo
> > in every place where we reset the top-level transaction id.
> >
> > I've updated the patch with the regression tests. Please review it.
>
> Confirmed the test fails on HEAD and pass after the patch.
> There might be idea to put the function after the "nParallelCurrentXids = 0;"
> even in the CommitTransaction() and PrepareTransaction(), which is same as
> CleanupTransaction(). But any places are OK for me.
>
> LGTM.

Thank you for reviewing the patch.

I'd rather move AtEOXact_LogicalCtl() to before resetting
CurrentResourceOwner. I think it should work fine too and caon deal
with your concern.

I've attached the updated patch. I'm going to push it on Monday,
barring objections.

Regards,

--
Masahiko Sawada
Amazon Web Services: https://aws.amazon.com

Attachment Content-Type Size
v2-0001-Fix-deferred-XLogLogicalInfo-update-after-a-faile.patch text/x-patch 5.5 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthias van de Meent 2026-10-02 21:10:10 Re: Costing for parallel scans with few/single row produced in the outer side
Previous Message Amit Kapila 2026-10-02 20:45:25 Re: Fix apply worker crash when subscriber table has only a deferrable primary key