tablecmds: fix Deadlock caused by Attach Partition

Title

CI (CFBot)

Summary

Stats (from CFBot)

Patch version: v5, Patch count: 3, First patch: +124−6, All patches: +315−6

Tags

Bugfix DDL

Created

2026-01-30 06:50:49

Last modified

2026-10-26 18:25:12 (3 days ago)

Latest email

2026-10-29 07:30:07 (21 hours ago)

Status

PG20-3 (2026-11-01 – 2026-11-30): Needs review

PG20-2 (2026-09-01 – 2026-09-30): Moved to different CF

PG20-1 (2026-07-01 – 2026-07-31): Moved to different CF

PG19-Final (2026-03-01 – 2026-04-09): Moved to different CF

Target version

Authors

Chao Li (chaol)

Reviewers

Aidar Imamov (gipergeek), Surya Poondla (spoondla) Become reviewer

Committer

Links

Emails

tablecmds: Deadlock caused by Attach Partition: First at 2026-01-30 03:15:51 by Chao Li <li.evan.chao at gmail.com>
Latest at 2026-10-29 07:30:07 by Chao Li <li.evan.chao at gmail.com>
Latest attachment (siblings.spec) at 2026-10-28 01:29:02 from shihao zhong <zhong950419 at gmail.com>
    Attachment (siblings.spec) at 2026-10-28 01:29:02 from shihao zhong <zhong950419 at gmail.com> (Patch: No)
    Attachment (v5-0001-Prevent-deadlock-between-ALTER-TABLE-recursion-an.patch) at 2026-10-26 07:22:20 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v4-0001-Prevent-deadlock-between-ALTER-TABLE-recursion-an.patch) at 2026-10-22 01:16:47 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v3-0001-Prevent-deadlock-between-ALTER-TABLE-recursion-an.patch) at 2026-10-21 01:50:23 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (v2-0001-Prevent-deadlock-between-ALTER-TABLE-recursion-an.patch) at 2026-10-20 07:01:29 from Chao Li <li.evan.chao at gmail.com> (Patch: No)
    Attachment (0002-Add-isolation-test-for-ATTACH-PARTITION-lock-orderin.patch) at 2026-10-19 19:06:13 from surya poondla <suryapoondla4 at gmail.com> (Patch: No)
    Attachment (v1-0001-Injection-point-based-test-for-lock-ordering-bug.patch) at 2026-09-03 11:44:06 from Kirill Reshke <reshkekirill at gmail.com> (Patch: No)
    Attachment (nocfbot_nested_partitions.sh) at 2026-01-30 03:15:51 from Chao Li <li.evan.chao at gmail.com> (Patch: No)

History

When	Who	What
2026-10-26 18:25:12	Aidar Imamov (gipergeek)	New status: Needs review
2026-10-22 18:05:30	Surya Poondla (spoondla)	New status: Ready for Committer
2026-10-05 03:46:35	Surya Poondla (spoondla)	Added spoondla as reviewer
2026-10-01 00:00:08	CFbot	Moved from CF PG20-2 to CF PG20-3
2026-09-21 18:33:37	Aidar Imamov (gipergeek)	Added gipergeek as reviewer
2026-08-01 00:00:08	CFbot	Moved from CF PG20-1 to CF PG20-2
2026-04-01 02:33:38	Chao Li (chaol)	Moved from CF PG19-Final to CF PG20-1
2026-01-30 06:50:49	Chao Li (chaol)	Attached mail thread CFACA0EB-7E6F-4FAA-9ACE-1FC2226D7482@gmail.com
2026-01-30 06:50:49	Chao Li (chaol)	Created patch record