CREATE TABLESPACE ts1 ADD DATAFILE 'data1.ibd'; CREATE TABLESPACE ts2 ADD DATAFILE 'data2.ibd'; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_8'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_9'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_9'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_10'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_10'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_11'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_11'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_12'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_12'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_13'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_13'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_14'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_14'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_8'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_9'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_9'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_10'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_10'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_11'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_11'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_12'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_12'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_13'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_13'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_14'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_14'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_5'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_6'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_7'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_8'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_9'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_9'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_10'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_10'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_before_post_ddl'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_before_post_ddl'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_11'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_11'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_12'; ALTER TABLE t1 ADD INDEX(b), TABLESPACE=innodb_system; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_12'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_8'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_8'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_before_post_ddl'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_before_post_ddl'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_11'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_11'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_12'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_12'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_7'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_8'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_7'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_8'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_before_post_ddl'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_before_post_ddl'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_11'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_11'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB TABLESPACE ts2 PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_12'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=innodb_file_per_table; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_12'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_free_tree_log_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_before_free_tree_log_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_log_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_log_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_free_tree_delete_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_free_tree_delete_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_before_delete_space_log_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_before_delete_space_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_log_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_log_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_delete_space_delete_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_delete_space_delete_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_before_post_ddl'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_before_post_ddl'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_1'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_1'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_2'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_2'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_3'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_3'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_4'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_4'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_5'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_5'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_6'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_6'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_7'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_7'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_8'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_8'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_9'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_9'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_10'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_10'; DROP TABLE t1; CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY, b VARCHAR(100), c INT NOT NULL, KEY(c)) ENGINE=InnoDB PARTITION BY RANGE(a) PARTITIONS 3 ( PARTITION p1 VALUES LESS THAN (2) TABLESPACE ts1, PARTITION p2 VALUES LESS THAN (5), PARTITION p3 VALUES LESS THAN MAXVALUE TABLESPACE innodb_file_per_table); SET GLOBAL innodb_ddl_log_crash_reset_debug = 1; SET SESSION DEBUG = '+d,ddl_log_crash_after_replay_11'; ALTER TABLE t1 DROP INDEX c, TABLESPACE=ts1; # No such crash injection, statement did not crash, cleaning up SET SESSION DEBUG = '-d,ddl_log_crash_after_replay_11'; DROP TABLE t1; DROP TABLESPACE ts1; DROP TABLESPACE ts2; SET GLOBAL innodb_ddl_log_crash_reset_debug = 0;