RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)

From: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
To: 'Jiří Kavalík' <jiri(dot)kavalik(at)comgate(dot)cz>
Cc: Zhijie Hou <houzhijie22(at)gmail(dot)com>, pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>, "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>
Subject: RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641)
Date: 2026-10-26 13:25:22
Message-ID: OS7PR01MB18317A51082A83624D6F092CAF5612@OS7PR01MB18317.jpnprd01.prod.outlook.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi members,

I made a patch set for supported branches. I confirmed the error can happen
and the patch can address the issue on PG14-PG18.

I refactored the test code for the readability. Wondering PG19/HEAD should contain
the test, because the reported ERROR could not happen in the first place.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Attachment Content-Type Size
nocfbot-v4-PG14-PG15-0001-Track-the-depth-of-scans-of-system-tabl.patch application/octet-stream 8.0 KB
v4-HEAD-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 11.4 KB
nocfbot-v4-PG19-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 10.9 KB
nocfbot-v4-PG16-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 7.9 KB
nocfbot-v4-PG17-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 7.8 KB
nocfbot-v4-PG18-0001-Track-the-depth-of-scans-of-system-tables.patch application/octet-stream 8.3 KB

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andres Freund 2026-10-26 13:27:28 Re: BUG #19796: io_uring crashes with specific kernel/liburing versions + io_max_concurrency due to rings overlap
Previous Message Greg Burd 2026-10-26 13:18:07 Re: BUG #17545: Incorrect selectivity for IS NOT DISTINCT FROM and NULLs