WAIT FOR LSN bug fixes

Edit
ID 6678
Title WAIT FOR LSN bug fixes
CI (CFBot) Needs rebase! Needs rebase since yesterday. Failing since yesterday.
Additional links previous successfully applied patch (outdated):
Summary
Stats (from CFBot) Unknown
Tags Bugfix
Created 2026-04-15 01:47:49
Last modified 2026-04-15 01:48:22 (2 weeks ago)
Latest email 2026-05-01 02:44:00 (4 days ago)
Status
PG20-1 (2026-07-01 – 2026-07-31): Needs review
Target version 19
Authors Xuneng Zhou (dylanzhou)
Reviewers Become reviewer
Committer
Links
Emails
Implement waiting for wal lsn replay: reloaded
First at 2024-11-27 04:08:51 by Alexander Korotkov <aekorotkov at gmail.com>
Latest at 2026-05-01 02:44:00 by Xuneng Zhou <xunengzhou at gmail.com>
Latest attachment (v8-0004-Use-replay-position-as-floor-for-WAIT-FOR-LSN-sta.patch) at 2026-05-01 02:44:00 from Xuneng Zhou <xunengzhou at gmail.com>
    Attachment (v8-0004-Use-replay-position-as-floor-for-WAIT-FOR-LSN-sta.patch) at 2026-05-01 02:44:00 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v7-0002-Fix-memory-ordering-in-WAIT-FOR-LSN-wakeup-mechan.patch) at 2026-04-28 21:01:32 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v5-0003-Remove-redundant-WAIT-FOR-LSN-caller-side-pre-che.patch) at 2026-04-21 04:03:30 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Use-barrier-semantics-when-reading-writing-writte.patch) at 2026-04-20 18:45:51 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Use-barrier-semantics-when-reading-writing-writte.patch) at 2026-04-10 06:13:05 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Use-barrier-semantics-when-reading-writing-writte.patch) at 2026-04-10 03:59:22 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Fix-memory-ordering-in-WAIT-FOR-LSN-wakeup-mechan.patch) at 2026-04-09 15:21:24 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0003-Wake-standby_write-standby_flush-waiters-from-the.patch) at 2026-04-08 04:59:03 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Remove-redundant-WAIT-FOR-LSN-caller-side-pre-che.patch) at 2026-04-08 03:23:54 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-memory-ordering-in-WAIT-FOR-LSN-wakeup-mechan.patch) at 2026-04-07 15:55:43 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Minimal-fix-for-WAIT-FOR-.-MODE-standby_flush.patch) at 2026-04-07 13:18:37 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v1-0001-Remove-redundant-WAIT-FOR-LSN-caller-side-pre-che.patch) at 2026-04-07 12:59:58 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Avoid-syscache-lookup-while-building-a-WAIT-FOR-t.patch) at 2026-04-06 07:15:15 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Avoid-syscache-lookup-while-building-a-WAIT-FOR-t.patch) at 2026-04-05 12:31:46 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Wake-LSN-waiters-before-recovery-target-stop.patch) at 2026-01-27 01:14:43 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-WAIT-FOR-Remove-redundant-pg_unreachable-after-el.patch) at 2026-01-20 01:28:31 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Avoid-syscache-lookup-in-WAIT-FOR-LSN-tuple-descr.patch) at 2026-01-12 06:53:46 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Use-WAIT-FOR-LSN-in-PostgreSQL-Test-Cluster-wait_.patch) at 2026-01-10 04:47:13 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Use-WAIT-FOR-LSN-in-PostgreSQL-Test-Cluster-wait_.patch) at 2026-01-09 13:44:17 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-reproduce-the-failure-in-031_recovery_conflict.pl.patch) at 2026-01-07 04:08:18 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Move-snapshot-release-to-the-beginning-of-ExecWai.patch) at 2026-01-06 17:04:06 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-wait_for_catchup-failure-when-standby-session.patch) at 2026-01-06 15:53:11 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-wait_for_catchup-failure-when-standby-session.patch) at 2026-01-06 13:12:41 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Extend-xlogwait-infrastructure-with-write-and-fl.patch) at 2026-01-02 22:53:56 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v12-0003-Add-tab-completion-for-WAIT-FOR-LSN-MODE-option.patch) at 2026-01-02 09:17:34 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Add-MODE-option-to-WAIT-FOR-LSN-command.patch) at 2025-12-30 06:19:27 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v10-0004-Use-WAIT-FOR-LSN-in-PostgreSQL-Test-Cluster-wait.patch) at 2025-12-30 02:42:09 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Extend-xlogwait-infrastructure-with-write-and-flu.patch) at 2025-12-30 02:12:28 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Extend-xlogwait-infrastructure-with-write-and-flu.patch) at 2025-12-26 16:15:05 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (synchronous_commit.png) at 2025-12-22 07:56:59 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: No)
    Attachment (v7-0001-Extend-xlogwait-infrastructure-with-write-and-flu.patch) at 2025-12-19 02:49:46 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Extend-xlogwait-infrastructure-with-write-and-flu.patch) at 2025-12-16 04:46:27 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v5-0003-Add-tab-completion-for-WAIT-FOR-LSN-MODE-paramete.patch) at 2025-12-16 03:28:51 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v4-0004-Use-WAIT-FOR-LSN-in.patch) at 2025-12-02 10:10:02 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0005-Use-WAIT-FOR-LSN-in.patch) at 2025-12-02 03:08:01 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0005-Use-WAIT-FOR-LSN-in.patch) at 2025-12-01 04:33:27 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Add-pg_last_wal_write_lsn-SQL-function.patch) at 2025-11-25 11:51:19 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Optimize-shared-memory-usage-for-WaitLSNProcInfo.patch) at 2025-11-16 12:08:58 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-incorrect-function-name-in-comments.patch) at 2025-11-14 01:49:51 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Use-WAIT-FOR-LSN-in.patch) at 2025-11-12 07:19:53 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Optimize-shared-memory-usage-for-WaitLSNProcInfo.patch) at 2025-11-07 22:02:36 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Use-WAIT-FOR-LSN-in-PostgreSQL-Test-Cluster-wait_.patch) at 2025-11-05 09:51:18 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v20-0002-Add-infrastructure-for-efficient-LSN-waiting.patch) at 2025-11-03 11:46:40 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v19-0002-Add-infrastructure-for-efficient-LSN-waiting.patch) at 2025-11-03 02:20:28 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Add-pairingheap_initialize-for-shared-memory-usa.patch) at 2025-11-02 06:24:48 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Add-pairingheap_initialize-for-shared-memory-usa.patch) at 2025-10-23 10:46:27 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Add-pairingheap_initialize-for-shared-memory-usag.patch) at 2025-10-16 07:11:58 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Add-pairingheap_initialize-for-shared-memory-usag copy.patch) at 2025-10-15 12:48:29 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Add-pairingheap_initialize-for-shared-memory-usag copy.patch) at 2025-10-15 08:40:03 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v14-0003-Implement-WAIT-FOR-command.patch) at 2025-10-15 00:23:09 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v13-0003-Implement-WAIT-FOR-command.patch) at 2025-10-14 13:03:30 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Implement-WAIT-FOR-command.patch) at 2025-10-04 01:35:32 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Implement-WAIT-FOR-command.patch) at 2025-09-28 09:02:43 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Implement-WAIT-FOR-command.patch) at 2025-09-15 18:59:42 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Implement-WAIT-FOR-command.patch) at 2025-09-13 19:31:32 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Implement-WAIT-FOR-command.patch) at 2025-08-27 15:54:25 from Xuneng Zhou <xunengzhou at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Implement-WAIT-FOR-command.patch) at 2025-08-05 13:47:07 from Álvaro Herrera <alvherre at kurilemu.de> (Patch: Yes)
    Attachment (v6-0001-Implement-WAIT-FOR-command.patch) at 2025-04-29 11:27:25 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Implement-WAIT-FOR-command.patch) at 2025-03-12 14:44:28 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: Yes)
    Attachment (v5-0001-Implement-WAIT-FOR-command.patch) at 2025-03-10 11:30:31 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Implement-WAIT-FOR-command.patch) at 2025-02-28 13:55:21 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: Yes)
    Attachment (v3-0001-Implement-WAIT-FOR-command.patch) at 2025-02-28 13:03:33 from Yura Sokolov <y.sokolov at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-Implement-WAIT-FOR-command.patch) at 2025-02-16 21:27:43 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Implement-WAIT-FOR-command.patch) at 2025-02-06 07:42:12 from Andrei Lepikhov <lepihov at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Implement-WAIT-FOR-command.patch) at 2024-11-27 04:08:51 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
History
When Who What
2026-05-03 19:53:24 CFbot Patch needs rebase
2026-04-15 01:48:22 Xuneng Zhou (dylanzhou) Changed name to WAIT FOR LSN bug fixes
2026-04-15 01:47:49 Xuneng Zhou (dylanzhou) Attached mail thread CAPpHfdsjtZLVzxjGT8rJHCYbM0D5dwkO+BBjcirozJ6nYbOW8Q@mail.gmail.com
2026-04-15 01:47:49 Xuneng Zhou (dylanzhou) Created patch record
Edit