Debian Codegraph @

mysql-test/suite/innodb/t/ddl_kill.test

raw
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;