DirtyScanshot index scan skips concurrently updated tuples

Title

CI (CFBot)

Needs rebase! Needs rebase since 6 hours. Failing since 6 days.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Topic

Bug Fixes

Created

2024-08-03 18:47:26

Last modified

2025-05-04 13:45:30 (1 month ago)

Latest email

2025-06-10 06:00:00 (4 days ago)

Status

2025-07: Needs review

2025-03: Moved to next CF

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), Mihail Nikalayeu (mihailnikalayeu)

Reviewers

Luan Silva (luansilva)Become reviewer

Committer

Links

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-10 06:00:00 by Mihail Nikalayeu <mihailnikalayeu at gmail.com>
Latest 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>
    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-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