DirtyScanshot index scan skips concurrently updated tuples leading to lost updates/deletes in logical replication

Edit
ID 5151
Title DirtyScanshot index scan skips concurrently updated tuples leading to lost updates/deletes in logical replication
CI (CFBot) Summary
Stats (from CFBot) Patch version: v12, Patch count: 2, First patch: +586βˆ’1, All patches: +604βˆ’46
Topic Bug Fixes
Tags Bugfix Logical Replication
Created 2024-08-03 18:47:26
Last modified 2025-09-11 13:15:06 (3 days ago)
Latest email 2025-09-13 12:07:33 (yesterday)
Status
PG19-3 (2025-11-01 – 2025-11-30): Needs review
PG19-1 (2025-07-01 – 2025-07-31): Moved to different CF
2025-03 (2025-03-01 – 2025-04-08): Moved to different CF
2025-01 (2025-01-01 – 2025-01-31): Moved to different CF
2024-11 (2024-11-01 – 2024-11-30): Moved to different CF
2024-09 (2024-09-01 – 2024-09-30): Moved to different CF
Target version stable
Authors Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
Reviewers Luan Silva (luansilva)Become reviewer
Committer
Links Git
Emails
[BUG?] check_exclusion_or_unique_constraint false negative
First at 2024-07-14 18:01:50 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest at 2025-09-13 12:07:33 by Mihail Nikalayeu <mihailnikalayeu at gmail.com>
Latest attachment (v12-0002-Fix-logical-replication-conflict-detection-durin.patch) at 2025-09-13 12:07:33 from Mihail Nikalayeu <mihailnikalayeu at gmail.com>
    Attachment (v12-0002-Fix-logical-replication-conflict-detection-durin.patch) at 2025-09-13 12:07:33 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v11-0002-Fix-logical-replication-conflict-detection-durin.patch) at 2025-09-03 18:20:21 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v10-0002-Fix-btree-index-scan-concurrency-issues-with-dir.patch) at 2025-08-21 08:43:08 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v9-0002-Fix-btree-index-scan-concurrency-issues-with-dirt.patch) at 2025-08-19 22:44:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Add-an-isolation-test-to-reproduce-a-dirty-snapsh.patch) at 2025-06-16 20:25:23 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Add-an-isolation-test-to-reproduce-a-dirty-snapsh.patch) at 2025-06-10 06:00:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Add-an-isolation-test-to-reproduce-a-dirty-snapsh.patch) at 2025-05-18 14:36:00 from Mihail Nikalayeu <mihailnikalayeu at gmail.com> (Patch: Yes)
    Attachment (v5-0002-Fix-btree-index-scan-concurrency-issues-with-dirt.patch) at 2025-03-12 01:05:50 from Mihail Nikalayeu <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Fix-possible-lost-tuples-in-non-MVCC-index-scans-.patch) at 2025-01-20 21:35:53 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Fix-possible-lost-tuples-in-non-MVCC-index-scans-.patch) at 2024-11-23 16:20:41 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v2-0002-additional-test-spec-to-reproduce-dirty-snapshot-.patch) at 2024-08-12 11:11:26 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (v1-0001-fix-for-lost-record-in-case-of-DirtySnapshot-inde.patch) at 2024-08-02 17:08:39 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)
    Attachment (test_+_assert_to_reproduce_possible_issue_with_check_exclusion_or_unique_constraint.patch) at 2024-07-14 18:01:50 from Michail Nikolaev <michail.nikolaev at gmail.com> (Patch: Yes)

Annotations

When Who Mail Annotation
2025-08-19 22:52:44 Mihail Nikalayeu (mihailnikalayeu) From Mihail Nikalayeu <mihailnikalayeu@gmail.com>
at 2025-08-19 22:44:00		 Lost updates/deletes in logical replication
Logical replication: lost updates/deletes and invalid log messages caused by SnapshotDirty + concurrent updates
First at 2025-09-10 23:56:00 by Mihail Nikalayeu <mihailnikalayeu at gmail.com>
Latest at 2025-09-10 23:56:00 by Mihail Nikalayeu <mihailnikalayeu at gmail.com>
History
When Who What
2025-09-13 12:31:28 CFbot Patch does not need rebase anymore
2025-09-12 09:29:20 CFbot Patch needs rebase
2025-09-11 13:15:06 Mihail Nikalayeu (mihailnikalayeu) Attached mail thread CADzfLwXZVmbo11tFS_G2i+6TfFVwHU4VUUSeoqb+8UQfuoJs8A@mail.gmail.com
2025-09-04 14:18:47 Mihail Nikalayeu (mihailnikalayeu) Moved from CF PG19-1 to CF PG19-3
2025-08-19 22:54:09 Mihail Nikalayeu (mihailnikalayeu) Changed name to DirtyScanshot index scan skips concurrently updated tuples leading to lost updates/deletes in logical replication
2025-08-19 22:52:44 Mihail Nikalayeu (mihailnikalayeu) Added annotation "Lost updates/deletes in logical replication" to CADzfLwWC49oanFSGPTf=6FJoTw-kAnpPZV8nVqAyR5KL68LrHQ@mail.gmail.com
2025-06-23 08:47:37 Mihail Nikalayeu (mihailnikalayeu) Changed tags to Bugfix, Logical Replication
2025-06-16 20:41:44 CFbot Patch does not need rebase anymore
2025-06-14 02:17:31 CFbot Patch needs rebase
2025-06-10 06:52:33 CFbot Patch does not need rebase anymore
2025-06-08 07:51:36 CFbot Patch needs rebase
2025-05-09 04:13:13 Luan Silva (luansilva) Added luansilva as reviewer
2025-05-04 13:45:30 Mihail Nikalayeu (mihailnikalayeu) Changed authors to Michail Nikolaev (nkey), Mihail Nikalayeu (mihailnikalayeu)
2025-04-20 19:44:35 Mihail Nikalayeu (mihailnikalayeu) Closed in commitfest 2025-03 with status: Moved to next CF
2025-03-12 01:31:42 CFbot Patch does not need rebase anymore
2025-03-12 01:08:26 Mihail Nikalayeu (mihailnikalayeu) New status: Needs review
2025-02-18 04:11:29 CFbot Patch needs rebase
2025-02-11 22:31:48 Michail Nikolaev (nkey) New status: Waiting on Author
2025-02-03 17:00:11 Michail Nikolaev (nkey) Closed in commitfest 2025-01 with status: Moved to next CF
2024-12-10 07:09:12 Michael Paquier (michael-kun) Closed in commitfest 2024-11 with status: Moved to next CF
2024-10-04 17:53:30 Andrey Borodin (x4m) Closed in commitfest 2024-09 with status: Moved to next CF
2024-08-03 18:48:00 Michail Nikolaev (nkey) Changed authors to Michail Nikolaev (nkey)
2024-08-03 18:48:00 Michail Nikolaev (nkey) Changed targetversion to stable
2024-08-03 18:48:00 Michail Nikolaev (nkey) Changed gitlink to https://github.com/postgres/postgres/compare/master...michail-nikolaev:postgres:concurrent_unique
2024-08-03 18:47:26 Michail Nikolaev (nkey) Attached mail thread CANtu0oiktqQ2pwExoXqDpByXNCJa-KE5vQRodTRnmFHN_+qwHg@mail.gmail.com
2024-08-03 18:47:26 Michail Nikolaev (nkey) Created patch record
Edit