SET @save_dbug = @@SESSION.debug_dbug; call mtr.add_suppression("InnoDB: Flagged corruption of .* in table `test`\\.`t` in TRUNCATE TABLE"); # 1. Error in assigning undo logs for truncate action CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100), INDEX ck(c)) ENGINE = InnoDB; insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c'); check table t; Table Op Msg_type Msg_text test.t check status OK SET @@SESSION.debug_dbug = '+d,ib_err_trunc_assigning_undo_log'; truncate table t; ERROR HY000: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB SET @@SESSION.debug_dbug = @save_dbug; check table t; Table Op Msg_type Msg_text test.t check status OK select * from t; i f c 1 1.1 a 2 2.2 b 3 3.3 c # 2. Error while preparing for truncate SET @@SESSION.debug_dbug = '+d,ib_err_trunc_preparing_for_truncate'; truncate table t; ERROR HY000: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB SET @@SESSION.debug_dbug = @save_dbug; check table t; Table Op Msg_type Msg_text test.t check status OK select * from t; i f c 1 1.1 a 2 2.2 b 3 3.3 c # 3. Error while dropping/creating indexes SET @@SESSION.debug_dbug = '+d,ib_err_trunc_drop_index'; truncate table t; ERROR HY000: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB SET @@SESSION.debug_dbug = @save_dbug; check table t; Table Op Msg_type Msg_text test.t check Warning InnoDB: Index PRIMARY is marked as corrupted test.t check error Corrupt select * from t; Got one of the listed errors drop table t; CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100), INDEX ck(c)) ENGINE = InnoDB; insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c'); check table t; Table Op Msg_type Msg_text test.t check status OK SET @@SESSION.debug_dbug = '+d,ib_err_trunc_create_index'; truncate table t; ERROR HY000: Got error 168 "Unknown (generic) error from engine" from storage engine InnoDB SET @@SESSION.debug_dbug = @save_dbug; check table t; Table Op Msg_type Msg_text test.t check Warning InnoDB: Index PRIMARY is marked as corrupted test.t check error Corrupt select * from t; Got one of the listed errors drop table t; CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100), INDEX ck(c)) ENGINE = InnoDB; insert into t values (1, 1.1, 'a'), (2, 2.2, 'b'), (3, 3.3, 'c'); check table t; Table Op Msg_type Msg_text test.t check status OK SET @@SESSION.debug_dbug = '+d,ib_err_trunc_temp_recreate_index'; truncate table t; SET @@SESSION.debug_dbug = @save_dbug; check table t; Table Op Msg_type Msg_text test.t check status OK select * from t; i f c drop table t; # 4. Error while completing truncate of table involving FTS CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100), FULLTEXT INDEX(c)) ENGINE = InnoDB; insert into t values (1, 1.1, 'mysql is now oracle company'), (2, 2.2, 'innodb is part of mysql'), (3, 3.3, 'innodb is default storage engine of mysql'); check table t; Table Op Msg_type Msg_text test.t check status OK SET @@SESSION.debug_dbug = '+d,ib_err_trunc_temp_recreate_index'; truncate table t; SET @@SESSION.debug_dbug = @save_dbug; check table t; Table Op Msg_type Msg_text test.t check status OK select * from t; i f c drop table t; # 5. Error while updating sys-tables CREATE TABLE t (i int PRIMARY KEY, f float UNIQUE, c char(100), FULLTEXT INDEX(c)) ENGINE = InnoDB; insert into t values (1, 1.1, 'mysql is now oracle company'), (2, 2.2, 'innodb is part of mysql'), (3, 3.3, 'innodb is default storage engine of mysql'); check table t; Table Op Msg_type Msg_text test.t check status OK SET @@SESSION.debug_dbug = '+d,ib_err_trunc_temp_recreate_index'; truncate table t; SET @@SESSION.debug_dbug = @save_dbug; check table t; Table Op Msg_type Msg_text test.t check status OK select * from t order by i; i f c drop table t;