Re: Bug in logical decoding with DDL and subtransactions

From: Alexander Lakhin <exclusion(at)gmail(dot)com>
To: Bingshuai Li <lucian1412(at)outlook(dot)com>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Cc: "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>, "alvherre(at)kurilemu(dot)de" <alvherre(at)kurilemu(dot)de>, Andrey Rachitskiy <pl0h0yp1(at)gmail(dot)com>, a(dot)kozhemyakin(at)postgrespro(dot)ru
Subject: Re: Bug in logical decoding with DDL and subtransactions
Date: 2026-09-17 06:00:00
Message-ID: 511b76ca-8aff-4f6a-b1e5-18d1467affb0@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello hackers,

27.08.2026 10:38, Bingshuai Li wrote:
> A brief ping on v4 before PG20-2 starts. The latest CFBot run is
> green on all enabled jobs:
>
> https://github.com/postgres/postgres-cfbot/actions/runs/32910623105/attempts/1
....
> PostgreSQL 19 is currently at Beta 3. Should BUG #19555 also be
> tracked as a PostgreSQL 19 open item?
>
> CF entry:
> https://commitfest.postgresql.org/patch/7137/

FWIW, buildfarm animal prion produced a couple of failures recently due to
that assertion triggered, [1], [2]:
TRAP: failed Assert("ent->cmin == change->data.tuplecid.cmin"), File:
"/home/ec2-user/bf/root/HEAD/pgsql.build/../pgsql/src/backend/replication/logical/reorderbuffer.c", Line: 1890, PID: 1211632
...
2026-09-15 21:58:17.665 UTC [1211335:63] LOG:  00000: client backend (PID 1211632) was terminated by signal 6: Aborted
2026-09-15 21:58:17.665 UTC [1211335:64] DETAIL:  Failed process was running: SELECT data FROM
pg_logical_slot_get_changes('regression_slot', NULL, NULL, 'include-xids', '0', 'skip-empty-xacts', '1');

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prion&dt=2026-09-15%2021%3A39%3A57
[2] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=prion&dt=2026-09-15%2022%3A13%3A04

Best regards,
Alexander

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2026-09-17 06:10:59 Re: Distinguish publication exclusions in object addresses
Previous Message Fujii Masao 2026-09-17 05:32:49 Re: Fix failing assert in deferred constraint trigger