RE: t/035_standby_logical_decoding.pl might fail on attempt to read wrong timeline

Hayato Kuroda (Fujitsu) <kuroda.hayato@fujitsu.com>

From: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>

To: 'Bertrand Drouvot' <bertranddrouvot.pg@gmail.com>

Cc: Alexander Lakhin <exclusion@gmail.com>, "xunengzhou@gmail.com" <xunengzhou@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2026-06-09T04:04:20Z

Lists: pgsql-hackers

Attachments

0001-Reproducer-for-the-streaming-replication.patch (application/octet-stream) patch 0001
0002-Fix-race-condition-in-streaming-replication-timeline.patch (application/octet-stream) patch 0002

Dear Bertrand, Xuneng,

Thanks for sharing the reproducer and opinion. I could now understand.

While seeing, I felt the same issue can happen even for the streaming case.
Please see attached reproducer and possible fix.

Can you also include that point? Or this thread discusses only for the logical case?
If separated, I can take initiative for the streaming part, after the logical decoding
case.

Best regards,
Hayato Kuroda
FUJITSU LIMITED

Commits

Fix second race with timeline selection during promotion
- d9b49e5b4fc2 16 (unreleased) landed
- ab5334d8bfa2 17 (unreleased) landed
- 4bff3aa51c19 18 (unreleased) landed
- a8ee70bd5e00 19 (unreleased) landed
Remove TAP test for timeline lookup race with logical decoding on standbys
- c011d5b65457 17 (unreleased) landed
Fix race with timeline selection in logical decoding during promotion
- 8cd687c44b62 16 (unreleased) landed
- 16b89ff04839 17 (unreleased) landed
- b4bd1385043c 18 (unreleased) landed
- eb4e7224a1c6 19 (unreleased) landed
Backport GetWALInsertionTimeLineIfSet()
- 2a04624daa32 16 (unreleased) landed
TAP test for logical decoding on standby
- fcd77d53217b 16.0 cited