Debian Codegraph @

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

raw
1 --echo #
2 --echo # BUG#19316315 CRASH RECOVERY FAILS AFTER ONLINE ADD INDEX
3 --echo #
4
5 --source include/have_debug_sync.inc
6
7 CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 INT) ENGINE=InnoDB;
8
9 INSERT INTO t1 VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
10
11 connect (con1,localhost,root,,);
12
13 SET DEBUG_SYNC = 'RESET';
14 SET DEBUG_SYNC = 'row_log_apply_after SIGNAL apply_after WAIT_FOR insert_after';
15 --send
16 ALTER TABLE t1 ADD UNIQUE INDEX(c2);
17
18 connection default;
19
20 SET DEBUG_SYNC = 'now WAIT_FOR apply_after';
21 INSERT INTO t1 VALUES(6, 6);
22
23 disconnect con1;
24
25 --source include/kill_and_restart_mysqld.inc
26
27 SELECT * FROM t1;
28
29 DROP TABLE t1;
30
31 # Clean up temporary tables left by crash.
32 # TODO: Revisit this after WL#9536
33 --disable_query_log
34 SET SESSION debug= "+d,skip_dd_table_access_check";
35 DELETE FROM mysql.index_column_usage WHERE column_id IN (
36 SELECT c.id FROM mysql.columns c, mysql.tables t WHERE
37 c.table_id = t.id AND t.name LIKE '#sql%');
38 DELETE FROM mysql.columns WHERE table_id IN (
39 SELECT id FROM mysql.tables WHERE name LIKE '#sql%');
40 DELETE FROM mysql.indexes WHERE table_id IN (
41 SELECT id FROM mysql.tables WHERE name LIKE '#sql%');
42 DELETE FROM mysql.tables WHERE name LIKE '#sql%';
43 SET SESSION debug= "-d,skip_dd_table_access_check";
44 --enable_query_log