SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row

Title

CI (CFBot)

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

Stats (from CFBot)

Unknown

Tags

Bugfix

Created

2026-08-28 21:02:42

Last modified

2026-09-17 05:22:40 (2 days ago)

Latest email

2026-09-15 10:55:47 (4 days ago)

Status

PG20-2 (2026-09-01 – 2026-09-30): Committed

Target version

Authors

Zsolt Parragi (zsolt.parragi)

Reviewers

Become reviewer

Committer

Dean Rasheed (deanr)

Links

Emails

SSI: ON CONFLICT DO SELECT takes no predicate lock on the returned row: First at 2026-08-19 11:33:01 by Zsolt Parragi <zsolt.parragi at percona.com>
Latest at 2026-09-15 10:55:47 by Dean Rasheed <dean.a.rasheed at gmail.com>
Latest attachment (v5-0001-Fix-missing-SIREAD-lock-on-the-row-found-by-ON-CO.patch) at 2026-09-12 10:34:21 from Dean Rasheed <dean.a.rasheed at gmail.com>
    Attachment (v5-0001-Fix-missing-SIREAD-lock-on-the-row-found-by-ON-CO.patch) at 2026-09-12 10:34:21 from Dean Rasheed <dean.a.rasheed at gmail.com> (Patch: No)
    Attachment (v4-0001-Fix-missing-SIREAD-lock-on-the-row-found-by-ON-CO.patch) at 2026-09-10 07:18:49 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
    Attachment (v3-0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-S.patch) at 2026-08-25 22:38:35 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
    Attachment (v2-0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-S.patch) at 2026-08-19 19:32:48 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)
    Attachment (0001-Take-SIREAD-lock-on-rows-read-by-ON-CONFLICT-DO-SELE.patch) at 2026-08-19 11:33:01 from Zsolt Parragi <zsolt.parragi at percona.com> (Patch: No)

History

When	Who	What
2026-09-17 05:22:40	Andrey Borodin (x4m)	Closed in commitfest PG20-2 with status: Committed
2026-09-17 05:22:40	Andrey Borodin (x4m)	Changed committer to deanr
2026-09-15 23:46:29	CFbot	Patch needs rebase
2026-08-31 11:36:25	Andrey Borodin (x4m)	New status: Ready for Committer
2026-08-28 21:02:42	Zsolt Parragi (zsolt.parragi)	Attached mail thread CAN4CZFM1GkHJkpMeo4G5rxtacVsfeKCJYiik9E9AKX1E9VYQ1w@mail.gmail.com
2026-08-28 21:02:42	Zsolt Parragi (zsolt.parragi)	Created patch record