Debian Codegraph @

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

raw
1 # Create an empty data directory...
2 # Unzip 5_7_8_clean.zip to the created directory...
3 # Kill the server
4 ############################################################################################
5 # Case 1: Attempt to start after clean shutdown on mysql-5.7.8.
6 # Pre-conditions: logically empty redo files from mysql-5.7.8.
7 # 1A: InnoDB refuses to start because of the too old redo log format.
8 # 1B: InnoDB refuses to start with innodb-force-recovery = 1 or 6.
9 # 1C: InnoDB refuses to start with innodb-read-only = ON.
10 ############################################################################################
11 # Case 1A: Start MySQL... (attempt 1)
12 # Verify...
13 Pattern "Unsupported redo log format \(v0\)\. The redo log was created before MySQL 5\.7\.9" found
14 Pattern "Redo log is from an earlier version" not found
15 Pattern "The latest found checkpoint is at lsn =" not found
16 Pattern "Upgrading redo log: .*, LSN=" not found
17 Pattern "innodb-unknown-compound-v" not found
18 # Case 1A: Start MySQL... (attempt 2)
19 # Verify...
20 Pattern "Unsupported redo log format \(v0\)\. The redo log was created before MySQL 5\.7\.9" found
21 Pattern "Redo log is from an earlier version" not found
22 Pattern "The latest found checkpoint is at lsn =" not found
23 Pattern "Upgrading redo log: .*, LSN=" not found
24 Pattern "innodb-unknown-compound-v" not found
25 ############################################################################################
26 # Case 1B-1: Start MySQL with --innodb-force-recovery=1...
27 # Verify...
28 Pattern "Database upgrade cannot be accomplished with innodb_force_recovery > 0" found
29 Pattern "Cannot upgrade format .* of redo log files when innodb-force-recovery > 0" not found
30 Pattern "The latest found checkpoint is at lsn =" not found
31 # Case 1B-2: Start MySQL with --innodb-force-recovery=6...
32 # Verify...
33 Pattern "Database upgrade cannot be accomplished with innodb_force_recovery > 0" found
34 Pattern "Cannot upgrade format .* of redo log files when innodb-force-recovery > 0" not found
35 Pattern "The latest found checkpoint is at lsn =" not found
36 ############################################################################################
37 # Case 1C: Start MySQL with innodb-read-only=ON...
38 # Verify...
39 Pattern "Database upgrade cannot be accomplished in read-only mode" found
40 Pattern "The latest found checkpoint is at lsn =" not found
41 ############################################################################################
42 # Cleanup...
43 # restart