1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
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
|
