Debian Codegraph @

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

raw
1 SET global innodb_print_ddl_logs = ON;
2
3 # In CONNECTION - DEFAULT
4 CREATE TABLE t (col1 INT PRIMARY KEY, col2 INT);
5 INSERT INTO t VALUES(1,1), (2,2), (3,3), (4,4);
6 SET DEBUG_SYNC= 'alter_table_inplace_after_lock_downgrade SIGNAL do_insert WAIT_FOR resume_ddl';
7 ALTER TABLE t DROP COLUMN col2;
8
9 # In CONNECTION - 1
10 SET DEBUG_SYNC= 'now WAIT_FOR do_insert';
11 START TRANSACTION;
12 INSERT INTO t VALUES(10,10);
13 set session debug = "+d, crash_after_flush_engine_log";
14 # Crash right after flushing InnoDB redo log
15 COMMIT;
16 ERROR HY000: Lost connection to MySQL server during query
17
18 # In CONNECTION - DEFAULT
19 ERROR HY000: Lost connection to MySQL server during query
20
21 # restart
22 SELECT * FROM t ORDER BY col1;
23 col1 col2
24 1 1
25 2 2
26 3 3
27 4 4
28 DROP TABLE t;