DirtyScanshot index scan skips concurrently updated tuples

Edit

5151

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v8, Patch count: 2, First patch: +77−1, All patches: +123−8

Topic

Bug Fixes

Tags

Bugfix Logical Replication

Created

2024-08-03 18:47:26

Last modified

2025-06-23 08:47:37 (3 days ago)

Latest email

2025-06-16 20:25:23 (1 week ago)

Status

PG19-1 (2025-07-01 - 2025-07-31): Needs review

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-06-16 20:25:23 by Mihail Nikalayeu <mihailnikalayeu at gmail.com>
Latest 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>
    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)

History

When	Who	What
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