DirtyScanshot index scan skips concurrently updated tuples

ID 5151

Title DirtyScanshot index scan skips concurrently updated tuples

Topic Bug Fixes

Created 2024-08-03 18:47:26

Last modified 2025-02-03 17:00:11 (1 day, 16 hours ago)

Latest email 2025-01-20 21:35:53 (2 weeks, 1 day ago)

Status

2025-03: Needs review

2025-01: Moved to next CF

2024-11: Moved to next CF

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 2025-01-20 21:35:53 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest 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>
    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-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