Debian Codegraph @

mysql-test/suite/innodb/r/alter_crash_rebuild.result

raw
1 CREATE TABLE t1 (a INT NOT NULL) ENGINE=InnoDB STATS_PERSISTENT=0;
2 connect ddl,localhost,root;
3 SET DEBUG_SYNC='after_trx_committed_in_memory SIGNAL stuck WAIT_FOR ever';
4 ALTER TABLE t1 ADD PRIMARY KEY(a);
5 connection default;
6 SET DEBUG_SYNC='now WAIT_FOR stuck';
7 SET GLOBAL innodb_log_checkpoint_now=ON;
8 # restart
9 disconnect ddl;
10 SHOW CREATE TABLE t1;
11 Table Create Table
12 t1 CREATE TABLE `t1` (
13 `a` int(11) NOT NULL,
14 PRIMARY KEY (`a`)
15 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci STATS_PERSISTENT=0
16 SELECT * FROM t1;
17 a
18 DROP TABLE t1;
19 InnoDB 0 transactions not purged