Re: Bug in logical decoding with DDL and subtransactions

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alexander Lakhin <exclusion(at)gmail(dot)com>, Bingshuai Li <lucian1412(at)outlook(dot)com>, "alvherre(at)kurilemu(dot)de" <alvherre(at)kurilemu(dot)de>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>, "mark(dot)dilger(at)enterprisedb(dot)com" <mark(dot)dilger(at)enterprisedb(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Andrey Rachitskiy <pl0h0yp1(at)gmail(dot)com>, "a(dot)kozhemyakin(at)postgrespro(dot)ru" <a(dot)kozhemyakin(at)postgrespro(dot)ru>
Subject: Re: Bug in logical decoding with DDL and subtransactions
Date: 2026-09-30 03:05:09
Message-ID: arx8ZfY4GrgZKOnH@paquier.xyz
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 29, 2026 at 05:17:19PM -0400, Tom Lane wrote:
> Given that the problem is expensive to reproduce, I doubt that
> bisecting to identify this still-hypothetical commit is worth the
> trouble; I was just curious to know if anyone already understood the
> connection. Now, if it turns out that Bingshuai's patch doesn't make
> prion happy, then we'll need to dig deeper.

It's not that hard to reach. If I run three check-world builds in
parallel to load my laptop CPU (say HEAD, v19 and v18 with a
worktree), HEAD is able to fail rather reliably like 30%~40% of the
time, on this test. The problem is very easy to reach for the last
two weeks.
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message shveta malik 2026-09-30 03:38:41 Re: Persist slot invalidations before publishing them
Previous Message Michael Paquier 2026-09-30 02:56:23 Re: Direct TOAST v2, faster, smaller and no migration needed