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