DirtyScanshot index scan skips concurrently updated tuples

Edit
ID 5151
Title DirtyScanshot index scan skips concurrently updated tuples
Topic Bug Fixes
Created 2024-08-03 18:47:26
Last modified 2024-10-04 17:53:30 (2 months ago)
Latest email 2024-11-23 16:20:41 (2 weeks, 1 day ago)
Status
2024-11: Needs review
2024-09: Moved to next CF
Target version stable
Authors Michail Nikolaev (nkey)
Reviewers Become reviewer
Committer
Links CFbot results (CirrusCI) CFbot GitHub Git
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/5151
git checkout commitfest/cf/5151
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 2024-11-23 16:20:41 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest 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>
    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
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