DirtyScanshot index scan skips concurrently updated tuples

Title

Topic

Bug Fixes

Created

2024-08-03 18:47:26

Last modified

2024-10-04 17:53:30 (1 month, 2 weeks ago)

Latest email

2024-10-21 17:06:59 (4 weeks, 1 day ago)

Status

2024-11: Needs review

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-10-21 17:06:59 by Michail Nikolaev <michail.nikolaev at gmail.com>
Latest 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>
    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