Details
-
Bug
-
Status: Open (View Workflow)
-
Critical
-
Resolution: Unresolved
-
10.11, 11.4, 11.8, 12.3, 13.0, 13.1
-
None
Description
Split from MDEV-36653.
Reproducible with:
--source include/have_debug_sync.inc
|
--source include/have_metadata_lock_info.inc
|
|
CREATE TABLE t1(a INT) ENGINE=Aria;
|
|
connect con1, localhost, root;
|
SET debug_sync='thr_multi_lock_before_thr_lock SIGNAL ready WAIT_FOR go';
|
send INSERT INTO t1 VALUES(1);
|
|
connection default;
|
SET debug_sync='now WAIT_FOR ready';
|
SET debug_sync='alter_table_inplace_before_lock_upgrade SIGNAL go';
|
ALTER TABLE t1 MODIFY a INT DEFAULT NULL;
|
|
connection con1;
|
reap;
|
disconnect con1;
|
|
DROP TABLE t1;
|
SET debug_sync='RESET';
|
INSERT is waiting for thr lock on t1 held by ALTER.
ALTER is waiting for MDL lock on t1 held by INSERT.
Attachments
Issue Links
- split from
-
MDEV-36653 main.mysql_upgrade-28915 test case timeout
-
- Closed
-