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
|
# Create new data directory (in order to corrupt its redo log files)...
############################################################################################
# Case 1. Attempt to start with redo files in old location, filled with 0x00.
############################################################################################
# Prepare...
# Start MySQL... (attempt 1)
# Verify...
Pattern "Unsupported redo log format \(v0\)" found
Pattern "innodb-unknown-compound-v" not found
# Start MySQL... (attempt 2)
# Verify...
Pattern "Unsupported redo log format \(v0\)" found
Pattern "innodb-unknown-compound-v" not found
############################################################################################
# Case 2. Attempt to start with redo files in new location, filled with 0x00.
############################################################################################
# Prepare...
# Start MySQL... (attempt 1)
# Verify...
Pattern "Found redo log file.*#ib_redo1 which has format \(v0\) and is stored inside #innodb_redo" found
Pattern "innodb-unknown-compound-v" not found
# Start MySQL... (attempt 2)
# Verify...
Pattern "Found redo log file.*#ib_redo1 which has format \(v0\) and is stored inside #innodb_redo" found
Pattern "innodb-unknown-compound-v" not found
############################################################################################
# Case 3. Attempt to start with redo files in old location, with future format (4294967295).
############################################################################################
# Prepare...
# Start MySQL... (attempt 1)
# Verify...
Pattern "Found redo log file .*ib_logfile0 which has format \(v4294967295\) and is stored outside #innodb_redo" found
Pattern "innodb-unknown-compound-v" not found
# Start MySQL... (attempt 2)
# Verify...
Pattern "Found redo log file .*ib_logfile0 which has format \(v4294967295\) and is stored outside #innodb_redo" found
Pattern "innodb-unknown-compound-v" not found
############################################################################################
# Case 4. Attempt to start with redo files in new location, with future format (4294967295).
############################################################################################
# Prepare...
# Start MySQL... (attempt 1)
# Verify...
Pattern "Unknown redo log format \(v4294967295\) in file.*#ib_redo1" found
Pattern "innodb-unknown-compound-v" not found
# Start MySQL... (attempt 2)
# Verify...
Pattern "Unknown redo log format \(v4294967295\) in file.*#ib_redo1" found
Pattern "innodb-unknown-compound-v" not found
############################################################################################
# Cleanup...
|
