--source include/have_debug.inc --source include/have_debug_sync.inc --source include/not_valgrind.inc --source include/have_log_bin.inc SET global innodb_print_ddl_logs = ON; connect(con1,localhost,root,,); connection default; --echo --echo # In CONNECTION - DEFAULT CREATE TABLE t (col1 INT PRIMARY KEY, col2 INT); INSERT INTO t VALUES(1,1), (2,2), (3,3), (4,4); SET DEBUG_SYNC= 'alter_table_inplace_after_lock_downgrade SIGNAL do_insert WAIT_FOR resume_ddl'; --send ALTER TABLE t DROP COLUMN col2 connection con1; --echo --echo # In CONNECTION - 1 SET DEBUG_SYNC= 'now WAIT_FOR do_insert'; START TRANSACTION; INSERT INTO t VALUES(10,10); set session debug = "+d, crash_after_flush_engine_log"; --echo # Crash right after flushing InnoDB redo log --source include/expect_crash.inc --error CR_SERVER_LOST COMMIT; connection default; --echo --echo # In CONNECTION - DEFAULT --error CR_SERVER_LOST --reap --echo --source include/start_mysqld.inc SELECT * FROM t ORDER BY col1; # Cleanup DROP TABLE t;