| 1 |
--source include/have_debug.inc |
| 2 |
--source include/big_test.inc |
| 3 |
|
| 4 |
--echo # Check if a DDL operation can be interrupted. |
| 5 |
|
| 6 |
DELIMITER |; |
| 7 |
CREATE PROCEDURE insert_rows(IN BASE INT, IN SIZE INT) |
| 8 |
BEGIN |
| 9 |
DECLARE i INT DEFAULT BASE; |
| 10 |
WHILE (i <= SIZE) DO |
| 11 |
INSERT INTO t values (i); |
| 12 |
SET i = i + 1; |
| 13 |
END WHILE; |
| 14 |
END| |
| 15 |
DELIMITER ;| |
| 16 |
|
| 17 |
CREATE TABLE t(c int) ENGINE=INNODB; |
| 18 |
|
| 19 |
--echo # Insert rows |
| 20 |
CALL insert_rows(1, 1000); |
| 21 |
|
| 22 |
connect (con1,localhost,root,,); |
| 23 |
connection con1; |
| 24 |
--echo # con1: Start the DDL |
| 25 |
let $ID= `SELECT @id := CONNECTION_ID()`; |
| 26 |
SET SESSION DEBUG='+d,ddl_merge_sort_interrupt'; |
| 27 |
SET DEBUG_SYNC='ddl_merge_sort_interrupt SIGNAL ready WAIT_FOR interrupt'; |
| 28 |
--send ALTER TABLE t ADD PRIMARY KEY(c); |
| 29 |
|
| 30 |
connection default; |
| 31 |
--echo # default: Kill the DDL |
| 32 |
let $ignore= `SELECT @id := $ID`; |
| 33 |
SET DEBUG_SYNC='now WAIT_FOR ready'; |
| 34 |
KILL QUERY @id; |
| 35 |
SET DEBUG_SYNC='now SIGNAL interrupt'; |
| 36 |
|
| 37 |
connection con1; |
| 38 |
--echo # con1: reap |
| 39 |
--error ER_QUERY_INTERRUPTED |
| 40 |
--reap |
| 41 |
|
| 42 |
--echo # Cleanup. Since ALTER TABLE was killed while waiting on sync point |
| 43 |
--echo # 'interrupt' signal might have been not received and properly cleared. |
| 44 |
SET DEBUG_SYNC='RESET'; |
| 45 |
|
| 46 |
connect (con2,localhost,root,,); |
| 47 |
connection con2; |
| 48 |
--echo # con2: Start the DDL |
| 49 |
let $ID= `SELECT @id := CONNECTION_ID()`; |
| 50 |
SET SESSION DEBUG='+d,ddl_btree_build_interrupt'; |
| 51 |
SET DEBUG_SYNC='ddl_btree_build_interrupt SIGNAL ready WAIT_FOR interrupt'; |
| 52 |
--send ALTER TABLE t ADD index i(c); |
| 53 |
|
| 54 |
connection default; |
| 55 |
--echo # default: Kill the DDL |
| 56 |
let $ignore= `SELECT @id := $ID`; |
| 57 |
SET DEBUG_SYNC='now WAIT_FOR ready'; |
| 58 |
KILL QUERY @id; |
| 59 |
SET DEBUG_SYNC='now SIGNAL interrupt'; |
| 60 |
|
| 61 |
connection con2; |
| 62 |
--echo # con2: reap |
| 63 |
--error ER_QUERY_INTERRUPTED |
| 64 |
--reap |
| 65 |
|
| 66 |
connection default; |
| 67 |
--echo # Cleanup |
| 68 |
SET DEBUG_SYNC="RESET"; |
| 69 |
DROP PROCEDURE insert_rows; |
| 70 |
DROP TABLE t; |
| 71 |
disconnect con1; |