Debian Codegraph @

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

raw
1 SET GLOBAL innodb_file_per_table=on;
2 SHOW variables like '%innodb_checksum_algorithm%';
3 Variable_name Value
4 innodb_checksum_algorithm crc32
5 CREATE TABLE t1(c1 INT PRIMARY KEY,c2 VARCHAR(20)) COMPRESSION="none", ENGINE=InnoDB;
6 INSERT INTO t1 VALUES(1, 'Innochecksum InnoDB');
7 INSERT INTO t1 VALUES(2, 'Innochecksum CRC32');
8 # Shutdown the Server
9 # Test[1(a)]: for read from standard input for innochecksum tool without rewrite of checksum with log option.
10 InnoDB File Checksum Utility.
11 Filename = -
12 Innochecksum: checking pages in range # to #
13 page::#; log sequence number:first = #; second = #
14 page::#; old style: calculated = #; recorded = #
15 page::#; new style: calculated = #; crc32 = #; recorded = #
16 page::#; log sequence number:first = #; second = #
17 page::#; old style: calculated = #; recorded = #
18 page::#; new style: calculated = #; crc32 = #; recorded = #
19 page::#; log sequence number:first = #; second = #
20 page::#; old style: calculated = #; recorded = #
21 page::#; new style: calculated = #; crc32 = #; recorded = #
22 page::#; log sequence number:first = #; second = #
23 page::#; old style: calculated = #; recorded = #
24 page::#; new style: calculated = #; crc32 = #; recorded = #
25 page::#; log sequence number:first = #; second = #
26 page::#; old style: calculated = #; recorded = #
27 page::#; new style: calculated = #; crc32 = #; recorded = #
28 page::#; log sequence number:first = #; second = #
29 Page::# is empty and uncorrupted
30 page::#; log sequence number:first = #; second = #
31 Page::# is empty and uncorrupted
32 # Test[1(b)]: for read from standard input for innochecksum tool Test checking for page: 3 to page:5
33 InnoDB File Checksum Utility.
34 Filename = -
35 Innochecksum: checking pages in range # to #
36 page::#; log sequence number:first = #; second = #
37 page::#; old style: calculated = #; recorded = #
38 page::#; new style: calculated = #; crc32 = #; recorded = #
39 page::#; log sequence number:first = #; second = #
40 page::#; old style: calculated = #; recorded = #
41 page::#; new style: calculated = #; crc32 = #; recorded = #
42 page::#; log sequence number:first = #; second = #
43 Page::# is empty and uncorrupted
44 # Test[1] End
45 # Test [2] for read from standard input for innochecksum tool with rewrite of crc32 checksum.
46 # Backup the t1.ibd before any rewrite of checksum, so used for further testing.
47 # Print the information for log option.
48 InnoDB File Checksum Utility.
49 Filename = -
50 Innochecksum: checking pages in range # to #
51 page::#; log sequence number:first = #; second = #
52 page::#; old style: calculated = #; recorded = #
53 page::#; new style: calculated = #; crc32 = #; recorded = #
54 page::#; Updated checksum field# = #
55 page::#; Updated checksum field# = #
56 page::#; log sequence number:first = #; second = #
57 page::#; old style: calculated = #; recorded = #
58 page::#; new style: calculated = #; crc32 = #; recorded = #
59 page::#; Updated checksum field# = #
60 page::#; Updated checksum field# = #
61 page::#; log sequence number:first = #; second = #
62 page::#; old style: calculated = #; recorded = #
63 page::#; new style: calculated = #; crc32 = #; recorded = #
64 page::#; Updated checksum field# = #
65 page::#; Updated checksum field# = #
66 page::#; log sequence number:first = #; second = #
67 page::#; old style: calculated = #; recorded = #
68 page::#; new style: calculated = #; crc32 = #; recorded = #
69 page::#; Updated checksum field# = #
70 page::#; Updated checksum field# = #
71 page::#; log sequence number:first = #; second = #
72 page::#; old style: calculated = #; recorded = #
73 page::#; new style: calculated = #; crc32 = #; recorded = #
74 page::#; Updated checksum field# = #
75 page::#; Updated checksum field# = #
76 page::#; log sequence number:first = #; second = #
77 Page::# is empty and uncorrupted
78 page::#; log sequence number:first = #; second = #
79 Page::# is empty and uncorrupted
80 # Recheck the a.ibd created file having crc32 checksum with the --strict-check=crc32 for innochecksum tool.
81 InnoDB File Checksum Utility.
82 Filename = a.ibd
83 Innochecksum: checking pages in range # to #
84 page::#; log sequence number:first = #; second = #
85 page::#; crc32 calculated = #; recorded checksum field# = # recorded checksum field# = #
86 page::#; log sequence number:first = #; second = #
87 page::#; crc32 calculated = #; recorded checksum field# = # recorded checksum field# = #
88 page::#; log sequence number:first = #; second = #
89 page::#; crc32 calculated = #; recorded checksum field# = # recorded checksum field# = #
90 page::#; log sequence number:first = #; second = #
91 page::#; crc32 calculated = #; recorded checksum field# = # recorded checksum field# = #
92 page::#; log sequence number:first = #; second = #
93 page::#; crc32 calculated = #; recorded checksum field# = # recorded checksum field# = #
94 page::#; log sequence number:first = #; second = #
95 Page::# is empty and uncorrupted
96 page::#; log sequence number:first = #; second = #
97 Page::# is empty and uncorrupted
98 #Replace the t.ibd with the newly created a.ibd having crc32 checksum.
99 # Start the server to validate the t1.ibd having crc32 checksum.
100 # restart
101 select * from t1;
102 c1 c2
103 1 Innochecksum InnoDB
104 2 Innochecksum CRC32
105 # Shutdown the server
106 # Test[2] End
107 # Test[3] for read from standard input for innochecksum tool with rewrite of "none" checksum.
108 # Retrieve the original t1.ibd before any rewrite of checksum, so used for further testing.
109 # Check for innochecksum tool to read from stdin and rewrite the checksum to "none"
110 # along with check for --verbose & --page-type-summary
111 # Print the content for --verbose and --page-type-summary
112
113 Variables (--variable-name=value)
114 and boolean options {FALSE|TRUE} Value (after reading options)
115 --------------------------------- ----------------------------------------
116 verbose TRUE
117 count FALSE
118 start-page #
119 end-page #
120 page #
121 strict-check crc#
122 no-check FALSE
123 allow-mismatches #
124 write none
125 page-type-summary TRUE
126 page-type-dump (No default value)
127 log mtrchecksum.log
128
129 ================PAGE TYPE SUMMARY==============
130 #PAGE_COUNT PAGE_TYPE
131 ===============================================
132 # Index page
133 # SDI Index page
134 # Undo log page
135 # Inode page
136 # Insert buffer free list page
137 # Freshly allocated page
138 # Insert buffer bitmap
139 # System page
140 # Transaction system page
141 # File Space Header
142 # Extent descriptor page
143 # BLOB page
144 # Compressed BLOB page
145 # Subsequent Compressed BLOB page
146 # SDI BLOB page
147 # Compressed SDI BLOB page
148 # Other type of page
149 ===============================================
150 Additional information:
151 Undo page type: # insert, # update, # other
152 Undo page state: # active, # cached, # to_free, # to_purge, # prepared, # other
153 # Print the information for log option.
154 InnoDB File Checksum Utility.
155 Filename = -
156 Innochecksum: checking pages in range # to #
157 page::#; log sequence number:first = #; second = #
158 page::#; old style: calculated = #; recorded = #
159 page::#; new style: calculated = #; crc32 = #; recorded = #
160 page::#; Updated checksum field# = #
161 page::#; Updated checksum field# = #
162 page::#; log sequence number:first = #; second = #
163 page::#; old style: calculated = #; recorded = #
164 page::#; new style: calculated = #; crc32 = #; recorded = #
165 page::#; Updated checksum field# = #
166 page::#; Updated checksum field# = #
167 page::#; log sequence number:first = #; second = #
168 page::#; old style: calculated = #; recorded = #
169 page::#; new style: calculated = #; crc32 = #; recorded = #
170 page::#; Updated checksum field# = #
171 page::#; Updated checksum field# = #
172 page::#; log sequence number:first = #; second = #
173 page::#; old style: calculated = #; recorded = #
174 page::#; new style: calculated = #; crc32 = #; recorded = #
175 page::#; Updated checksum field# = #
176 page::#; Updated checksum field# = #
177 page::#; log sequence number:first = #; second = #
178 page::#; old style: calculated = #; recorded = #
179 page::#; new style: calculated = #; crc32 = #; recorded = #
180 page::#; Updated checksum field# = #
181 page::#; Updated checksum field# = #
182 page::#; log sequence number:first = #; second = #
183 Page::# is empty and uncorrupted
184 page::#; log sequence number:first = #; second = #
185 Page::# is empty and uncorrupted
186 # Recheck the a.ibd created file having crc32 checksum with the --strict-check=none for innochecksum tool.
187 InnoDB File Checksum Utility.
188 Filename = a.ibd
189 Innochecksum: checking pages in range # to #
190 page::#; log sequence number:first = #; second = #
191 page::#; none checksum: calculated = #; recorded checksum_field# = # recorded checksum_field# = #
192 page::#; log sequence number:first = #; second = #
193 page::#; none checksum: calculated = #; recorded checksum_field# = # recorded checksum_field# = #
194 page::#; log sequence number:first = #; second = #
195 page::#; none checksum: calculated = #; recorded checksum_field# = # recorded checksum_field# = #
196 page::#; log sequence number:first = #; second = #
197 page::#; none checksum: calculated = #; recorded checksum_field# = # recorded checksum_field# = #
198 page::#; log sequence number:first = #; second = #
199 page::#; none checksum: calculated = #; recorded checksum_field# = # recorded checksum_field# = #
200 page::#; log sequence number:first = #; second = #
201 Page::# is empty and uncorrupted
202 page::#; log sequence number:first = #; second = #
203 Page::# is empty and uncorrupted
204 # Start the server to validate the t1.ibd having "none" checksum.
205 # restart
206 select * from t1;
207 c1 c2
208 1 Innochecksum InnoDB
209 2 Innochecksum CRC32
210 # Shutdown the server
211 # Test[3] End
212 # Test[4] for read from standard input for innochecksum tool with rewrite of "innodb" checksum.
213 # Command for innochecksum tool to read from stdin and rewrite the checksum to "innodb"
214 # Print the information for log option.
215 InnoDB File Checksum Utility.
216 Filename = -
217 Innochecksum: checking pages in range # to #
218 page::#; log sequence number:first = #; second = #
219 page::#; old style: calculated = #; recorded = #
220 page::#; new style: calculated = #; crc32 = #; recorded = #
221 page::#; Updated checksum field# = #
222 page::#; Updated checksum field# = #
223 page::#; log sequence number:first = #; second = #
224 page::#; old style: calculated = #; recorded = #
225 page::#; new style: calculated = #; crc32 = #; recorded = #
226 page::#; Updated checksum field# = #
227 page::#; Updated checksum field# = #
228 page::#; log sequence number:first = #; second = #
229 page::#; old style: calculated = #; recorded = #
230 page::#; new style: calculated = #; crc32 = #; recorded = #
231 page::#; Updated checksum field# = #
232 page::#; Updated checksum field# = #
233 page::#; log sequence number:first = #; second = #
234 page::#; old style: calculated = #; recorded = #
235 page::#; new style: calculated = #; crc32 = #; recorded = #
236 page::#; Updated checksum field# = #
237 page::#; Updated checksum field# = #
238 page::#; log sequence number:first = #; second = #
239 page::#; old style: calculated = #; recorded = #
240 page::#; new style: calculated = #; crc32 = #; recorded = #
241 page::#; Updated checksum field# = #
242 page::#; Updated checksum field# = #
243 page::#; log sequence number:first = #; second = #
244 Page::# is empty and uncorrupted
245 page::#; log sequence number:first = #; second = #
246 Page::# is empty and uncorrupted
247 # Recheck the a.ibd created file having crc32 checksum with the --strict-check=innodb for innochecksum tool.
248 InnoDB File Checksum Utility.
249 Filename = a.ibd
250 Innochecksum: checking pages in range # to #
251 page::#; log sequence number:first = #; second = #
252 page::#; old style: calculated = #; recorded checksum = #
253 page::#; new style: calculated = #; recorded checksum = #
254 page::#; log sequence number:first = #; second = #
255 page::#; old style: calculated = #; recorded checksum = #
256 page::#; new style: calculated = #; recorded checksum = #
257 page::#; log sequence number:first = #; second = #
258 page::#; old style: calculated = #; recorded checksum = #
259 page::#; new style: calculated = #; recorded checksum = #
260 page::#; log sequence number:first = #; second = #
261 page::#; old style: calculated = #; recorded checksum = #
262 page::#; new style: calculated = #; recorded checksum = #
263 page::#; log sequence number:first = #; second = #
264 page::#; old style: calculated = #; recorded checksum = #
265 page::#; new style: calculated = #; recorded checksum = #
266 page::#; log sequence number:first = #; second = #
267 Page::# is empty and uncorrupted
268 page::#; log sequence number:first = #; second = #
269 Page::# is empty and uncorrupted
270 # Replace the t.ibd with the newly created a.ibd having "innodb" checksum.
271 # Start the server to validate the t1.ibd having "innodb" checksum.
272 # restart
273 select * from t1;
274 c1 c2
275 1 Innochecksum InnoDB
276 2 Innochecksum CRC32
277 # Test[4] End
278 # Test[5] for lock.
279 # Test Scenario: As mysqld is running, & then start the innochecksum which must fail.
280 Pattern "Error: Unable to lock file:: MYSQLD_DATADIR/test/t1.ibd" found
281 Pattern "fcntl: Resource temporarily unavailable" found
282 # Test[5] end
283 DROP TABLE t1;