Debian Codegraph @

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

raw
1 # Create an empty data directory...
2 # Unzip 8_0_11_clean.zip to the created directory...
3 # Kill the server
4 ############################################################################################
5 # Case 1: Attempt to start after clean shutdown on mysql-8.0.11.
6 # Pre-conditions: logically empty redo files from mysql-8.0.11.
7 # 1A: InnoDB successfully upgrades and starts.
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 "Redo log format is v2\. The redo log was created before MySQL 8\.0\." not found
14 Pattern "Redo log is from an earlier version" found
15 Pattern "The latest found checkpoint is at lsn =" found
16 Pattern "Upgrading redo log: .*, LSN=" found
17 Pattern "innodb-unknown-compound-v" found
18 # Case 1A: Start MySQL... (attempt 2)
19 # Verify...
20 Pattern "Redo log format is v2\. The redo log was created before MySQL 8\.0\." not found
21 Pattern "Redo log is from an earlier version" not found
22 Pattern "The latest found checkpoint is at lsn =" found
23 Pattern "Upgrading redo log: .*, LSN=" not found
24 Pattern "innodb-unknown-compound-v" found
25 # Redo log has become upgraded - replacing with older (from before upgrade)...
26 # Cleanup...
27 # restart
28 # Create an empty data directory...
29 # Unzip 8_0_11_clean.zip to the created directory...
30 # Kill the server
31 ############################################################################################
32 # Case 1B-1: Start MySQL with --innodb-force-recovery=1...
33 # Verify...
34 Pattern "Database upgrade cannot be accomplished with innodb_force_recovery > 0" not found
35 Pattern "Cannot upgrade format .* of redo log files when innodb-force-recovery > 0" found
36 Pattern "The latest found checkpoint is at lsn =" not found
37 # Case 1B-2: Start MySQL with --innodb-force-recovery=6...
38 # Verify...
39 Pattern "Database upgrade cannot be accomplished with innodb_force_recovery > 0" not found
40 Pattern "Cannot upgrade format .* of redo log files when innodb-force-recovery > 0" not found
41 Pattern "The latest found checkpoint is at lsn =" not found
42 ############################################################################################
43 # Case 1C: Start MySQL with innodb-read-only=ON...
44 # Verify...
45 Pattern "Database upgrade cannot be accomplished in read-only mode" not found
46 Pattern "The latest found checkpoint is at lsn =" not found
47 ############################################################################################
48 # Cleanup...
49 # restart