Debian Codegraph @

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

raw
1 # redo log from before MariaDB 10.2.2/MySQL 5.7.9
2 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
3 SELECT * FROM INFORMATION_SCHEMA.ENGINES
4 WHERE engine = 'innodb'
5 AND support IN ('YES', 'DEFAULT', 'ENABLED');
6 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
7 FOUND 1 /InnoDB: Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2\./ in mysqld.1.err
8 # redo log from before MariaDB 10.2.2, with corrupted log checkpoint
9 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
10 SELECT * FROM INFORMATION_SCHEMA.ENGINES
11 WHERE engine = 'innodb'
12 AND support IN ('YES', 'DEFAULT', 'ENABLED');
13 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
14 FOUND 1 /InnoDB: Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2, and we did not find a valid checkpoint/ in mysqld.1.err
15 # redo log from before MariaDB 10.2.2, with corrupted log block
16 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
17 SELECT * FROM INFORMATION_SCHEMA.ENGINES
18 WHERE engine = 'innodb'
19 AND support IN ('YES', 'DEFAULT', 'ENABLED');
20 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
21 FOUND 1 /InnoDB: Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2, and we did not find a valid checkpoint/ in mysqld.1.err
22 # empty redo log from before MariaDB 10.2.2
23 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
24 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
25 WHERE engine = 'innodb'
26 AND support IN ('YES', 'DEFAULT', 'ENABLED');
27 COUNT(*)
28 1
29 FOUND 1 /InnoDB: Upgrading redo log:/ in mysqld.1.err
30 # Corrupted multi-file redo log from before MariaDB 10.2.2
31 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
32 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
33 WHERE engine = 'innodb'
34 AND support IN ('YES', 'DEFAULT', 'ENABLED');
35 COUNT(*)
36 0
37 FOUND 1 /InnoDB: Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2, and it appears corrupted/ in mysqld.1.err
38 # Empty multi-file redo log (wrong offset) from before MariaDB 10.2.2
39 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
40 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
41 WHERE engine = 'innodb'
42 AND support IN ('YES', 'DEFAULT', 'ENABLED');
43 COUNT(*)
44 0
45 FOUND 3 /Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2, and we did not find a valid checkpoint\./ in mysqld.1.err
46 # Multi-file redo log with size mismatch from after MariaDB 10.2.2
47 # Corrupted multi-file redo log from after MariaDB 10.2.2
48 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
49 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
50 WHERE engine = 'innodb'
51 AND support IN ('YES', 'DEFAULT', 'ENABLED');
52 COUNT(*)
53 0
54 FOUND 3 /Upgrade after a crash is not supported. This redo log was created before MariaDB 10\.2\.2, and we did not find a valid checkpoint\./ in mysqld.1.err
55 FOUND 1 /InnoDB: No valid checkpoint was found; the log was created with BogoDB 1\.2\.3\.4\./ in mysqld.1.err
56 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
57 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
58 WHERE engine = 'innodb'
59 AND support IN ('YES', 'DEFAULT', 'ENABLED');
60 COUNT(*)
61 0
62 FOUND 1 /InnoDB: Log file .*ib_logfile1 is of different size 2097152 bytes than other log files 1048576 bytes!/ in mysqld.1.err
63 FOUND 2 /InnoDB: No valid checkpoint was found; the log was created with BogoDB 1\.2\.3\.4\./ in mysqld.1.err
64 # Empty multi-file redo log from after MariaDB 10.2.2
65 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
66 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
67 WHERE engine = 'innodb'
68 AND support IN ('YES', 'DEFAULT', 'ENABLED');
69 COUNT(*)
70 0
71 FOUND 3 /InnoDB: No valid checkpoint was found; the log was created with BogoDB 1\.2\.3\.4\./ in mysqld.1.err
72 # redo log from "after" MariaDB 10.2.2, but with invalid header checksum
73 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
74 SELECT * FROM INFORMATION_SCHEMA.ENGINES
75 WHERE engine = 'innodb'
76 AND support IN ('YES', 'DEFAULT', 'ENABLED');
77 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
78 FOUND 1 /InnoDB: Log file .*ib_logfile1 is of different size 2097152 bytes than other log files 4194304 bytes!/ in mysqld.1.err
79 FOUND 1 /InnoDB: Invalid log header checksum/ in mysqld.1.err
80 # distant future redo log format, with valid header checksum
81 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
82 SELECT * FROM INFORMATION_SCHEMA.ENGINES
83 WHERE engine = 'innodb'
84 AND support IN ('YES', 'DEFAULT', 'ENABLED');
85 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
86 FOUND 1 /InnoDB: Unsupported redo log format. The redo log was created with malicious intentions, or perhaps\./ in mysqld.1.err
87 # valid header, but old-format checkpoint blocks
88 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
89 SELECT * FROM INFORMATION_SCHEMA.ENGINES
90 WHERE engine = 'innodb'
91 AND support IN ('YES', 'DEFAULT', 'ENABLED');
92 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
93 FOUND 1 /InnoDB: No valid checkpoint was found; the log was created with malicious intentions, or perhaps\./ in mysqld.1.err
94 # valid header, valid checkpoint 1, all-zero (invalid) checkpoint 2, invalid block checksum
95 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5
96 SELECT * FROM INFORMATION_SCHEMA.ENGINES
97 WHERE engine = 'innodb'
98 AND support IN ('YES', 'DEFAULT', 'ENABLED');
99 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
100 FOUND 2 /InnoDB: Invalid log header checksum/ in mysqld.1.err
101 FOUND 1 /InnoDB: Upgrade after a crash is not supported\. The redo log was created with malicious intentions, or perhaps, and it appears corrupted\./ in mysqld.1.err
102 # same, but with current-version header
103 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5
104 SELECT * FROM INFORMATION_SCHEMA.ENGINES
105 WHERE engine = 'innodb'
106 AND support IN ('YES', 'DEFAULT', 'ENABLED');
107 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
108 FOUND 3 /InnoDB: Invalid log header checksum/ in mysqld.1.err
109 # --innodb-force-recovery=6 (skip the entire redo log)
110 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=6
111 SELECT * FROM INFORMATION_SCHEMA.ENGINES
112 WHERE engine = 'innodb'
113 AND support IN ('YES', 'DEFAULT', 'ENABLED');
114 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
115 InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES
116 FOUND 1 /\[Note\] InnoDB: log sequence number 0.*; transaction id 0/ in mysqld.1.err
117 # valid header, valid checkpoint 1, all-zero (invalid) checkpoint 2, invalid block number
118 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5
119 SELECT * FROM INFORMATION_SCHEMA.ENGINES
120 WHERE engine = 'innodb'
121 AND support IN ('YES', 'DEFAULT', 'ENABLED');
122 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
123 # --innodb-force-recovery=6 (skip the entire redo log)
124 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=6
125 SELECT * FROM INFORMATION_SCHEMA.ENGINES
126 WHERE engine = 'innodb'
127 AND support IN ('YES', 'DEFAULT', 'ENABLED');
128 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
129 InnoDB YES Supports transactions, row-level locking, foreign keys and encryption for tables YES YES YES
130 # Test a corrupted MLOG_FILE_NAME record.
131 # valid header, valid checkpoint 1, all-zero (invalid) checkpoint 2
132 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
133 SELECT * FROM INFORMATION_SCHEMA.ENGINES
134 WHERE engine = 'innodb'
135 AND support IN ('YES', 'DEFAULT', 'ENABLED');
136 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
137 FOUND 1 /\[ERROR\] InnoDB: Upgrade after a crash is not supported\. The redo log was created with MariaDB 10\.3\.1\./ in mysqld.1.err
138 # Test a corrupted MLOG_FILE_NAME record.
139 # valid header, invalid checkpoint 1, valid checkpoint 2, invalid block
140 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
141 SELECT * FROM INFORMATION_SCHEMA.ENGINES
142 WHERE engine = 'innodb'
143 AND support IN ('YES', 'DEFAULT', 'ENABLED');
144 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
145 NOT FOUND /InnoDB: Invalid log header checksum
146 --source include/search_pattern_in_file.inc
147 let SEARCH_PATTERN=\[ERROR\] InnoDB: Upgrade after a crash is not supported\. The redo log was created with MariaDB 10\.3\.1, and it appears corrupted\./ in mysqld.1.err
148 # valid header, invalid checkpoint 1, valid checkpoint 2, invalid log record
149 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
150 SELECT * FROM INFORMATION_SCHEMA.ENGINES
151 WHERE engine = 'innodb'
152 AND support IN ('YES', 'DEFAULT', 'ENABLED');
153 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
154 FOUND 2 /\[ERROR\] InnoDB: Upgrade after a crash is not supported\. The redo log was created with MariaDB 10\.3\.1\./ in mysqld.1.err
155 # 10.2 missing MLOG_FILE_NAME or MLOG_FILE_DELETE before MLOG_CHECKPOINT
156 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
157 SELECT * FROM INFORMATION_SCHEMA.ENGINES
158 WHERE engine = 'innodb'
159 AND support IN ('YES', 'DEFAULT', 'ENABLED');
160 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
161 FOUND 1 /\[ERROR\] InnoDB: Upgrade after a crash is not supported\. The redo log was created with ibbackup was here!!!1!\./ in mysqld.1.err
162 # 10.3 missing MLOG_FILE_NAME or MLOG_FILE_DELETE before MLOG_CHECKPOINT
163 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption
164 SELECT * FROM INFORMATION_SCHEMA.ENGINES
165 WHERE engine = 'innodb'
166 AND support IN ('YES', 'DEFAULT', 'ENABLED');
167 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
168 FOUND 3 /\[ERROR\] InnoDB: Upgrade after a crash is not supported\. The redo log was created with MariaDB 10\.3\.1\./ in mysqld.1.err
169 # Empty 10.3 redo log
170 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
171 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
172 WHERE engine = 'innodb'
173 AND support IN ('YES', 'DEFAULT', 'ENABLED');
174 COUNT(*)
175 1
176 FOUND 1 /InnoDB: log sequence number 1213964\b.*; transaction id 0/ in mysqld.1.err
177 # Empty 10.2 redo log
178 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
179 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
180 WHERE engine = 'innodb'
181 AND support IN ('YES', 'DEFAULT', 'ENABLED');
182 COUNT(*)
183 1
184 FOUND 3 /InnoDB: Upgrading redo log:/ in mysqld.1.err
185 # Empty 10.5 redo log
186 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5 --innodb-log-file-size=4m
187 SELECT COUNT(*) FROM INFORMATION_SCHEMA.ENGINES
188 WHERE engine = 'innodb'
189 AND support IN ('YES', 'DEFAULT', 'ENABLED');
190 COUNT(*)
191 1
192 FOUND 4 /InnoDB: Upgrading redo log:/ in mysqld.1.err
193 # Minimal MariaDB 10.1.21 encrypted redo log
194 # restart: --innodb-data-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-log-group-home-dir=MYSQLTEST_VARDIR/tmp/log_corruption --innodb-force-recovery=5
195 SELECT * FROM INFORMATION_SCHEMA.ENGINES
196 WHERE engine = 'innodb'
197 AND support IN ('YES', 'DEFAULT', 'ENABLED');
198 ENGINE SUPPORT COMMENT TRANSACTIONS XA SAVEPOINTS
199 FOUND 1 /InnoDB: Obtaining redo log encryption key version 1 failed/ in mysqld.1.err
200 FOUND 1 /InnoDB: Decrypting checkpoint failed/ in mysqld.1.err
201 ib_buffer_pool
202 ib_logfile0
203 ibdata1
204 # restart