CREATE TABLE t1(a INT PRIMARY KEY) ENGINE=InnoDB; BEGIN; INSERT INTO t1 VALUES (42); # Kill and restart: --innodb-redo-log-capacity=12M SELECT * FROM t1; a INSERT INTO t1 VALUES (42); BEGIN; DELETE FROM t1; # Kill and restart: --innodb-redo-log-capacity=15M SELECT * FROM t1; a 42 INSERT INTO t1 VALUES (123); SET GLOBAL innodb_log_checkpoint_now = 1; # Kill the server ib_logfile0 ib_logfile1 # # Crashing during recovery (common logic) # # Crash right before recovery starts: # Expect "found" Pattern "Completed space ID check" found # Crash after log records applied: # Expect "found" Pattern "Starting to parse redo log at lsn = [0-9]+, whereas checkpoint_lsn = [0-9]+" found # Crash right before recovery ends: # Expect "found" Pattern "Apply batch completed" found # Crash after dynamic metadata apply: # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err SHOW TABLES FROM test; Tables_in_test # Kill the server # # Crashing during upgrade itself # # Crash right after verifying clean shutdown: # Expect "not found" Pattern "Apply batch completed" not found # Expect "found" Pattern "Upgrading redo log: .* LSN=[0-9]+" found # Crash right after deleting first log file: # Expect "found" Pattern "innodb_force_recovery_crash=7" found ib_logfile1 # Expect "found" Pattern "Missing ib_logfile0 in the directory" found # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err SHOW TABLES FROM test; Tables_in_test # Kill the server # Crash right after deleting all log files: # Expect "found" Pattern "innodb_force_recovery_crash=8" found # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err SHOW TABLES FROM test; Tables_in_test # Kill the server # Crash after creating #ib_redo0_tmp: # Expect "found" Pattern "innodb_force_recovery_crash=9" found # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err SHOW TABLES FROM test; Tables_in_test # Kill the server # Crash after renaming #ib_redo0_tmp to #ib_redo0: # Expect "found" Pattern "innodb_force_recovery_crash=10" found # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err SHOW TABLES FROM test; Tables_in_test # Kill the server # Crash after creating all log files: # Expect "found" Pattern "innodb_force_recovery_crash=11" found # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err SHOW TABLES FROM test; Tables_in_test # Kill the server # Crash after writing first checkpoint: # Expect "found" Pattern "innodb_force_recovery_crash=12" found # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err SHOW TABLES FROM test; Tables_in_test # Kill the server # Crash after marking redo files as initialized: # Expect "found" Pattern "innodb_force_recovery_crash=13" found # restart: --datadir=MYSQLD_DATADIR1 --log-error=MYSQLD_DATADIR1/mysqld.err SHOW TABLES FROM test; Tables_in_test # Kill the server # # Start MySQL after upgrade. # # restart: --innodb-redo-log-capacity=15M