DirtyScanshot index scan skips concurrently updated tuples

Title

Topic

Bug Fixes

Created

2024-08-03 18:47:26

Last modified

2024-12-10 07:09:12 (1 week, 4 days ago)

Latest email

2024-11-23 16:20:41 (4 weeks ago)

Status

2025-01: Needs review

2024-11: Moved to next CF

2024-09: Moved to next CF

Target version

stable

Authors

Michail Nikolaev (nkey)

Reviewers

Committer

Links

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-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