Debian Codegraph @

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

raw
1 # Set the environmental variables
2 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Unable to read page \\[page id: space=.*, page number=.*\\] into the buffer pool after 100 attempts");
3 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Database page corruption on disk or a failed");
4 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* Assertion failure: buf0buf\.cc:[0-9]+:ib::fatal triggered");
5 SET GLOBAL innodb_file_per_table=on;
6 [1]: Test is to corrupt the ibd file, & do repair for (innodb|crc32|none) checksum through innochecksum tool
7 # Create and populate the table to be corrupted
8 CREATE TABLE t1 (a INT AUTO_INCREMENT PRIMARY KEY, b TEXT) COMPRESSION="none",
9 ROW_FORMAT=COMPACT ENGINE=InnoDB;
10 INSERT INTO t1 (b) VALUES ('corrupt me');
11 INSERT INTO t1 (b) VALUES ('corrupt me');
12 # Shutdown the server
13 # Corrupt the t1 table
14 Munged a string.
15 Munged a string.
16 # Backup the corrupted t1.ibd for reuse for further testing.
17 # Write file to make mysql-test-run.pl start up the server again
18 # restart
19 # Write file to make mysql-test-run.pl expect the "crash", but don't
20 # start it until it's told to
21 # The below SELECT query will crash the server because some pages
22 # on the disk are corrupted
23 SELECT * FROM t1;
24 ERROR HY000: Lost connection to MySQL server during query
25 [1(a)]: Repair the ibd file with innochecksum with --write=innodb
26 # Start the server
27 # restart
28 select count(*) from t1;
29 # Shutdown the server
30 # Move the corrupted ibd file to t1.ibd
31 [1(b)]: Repair the ibd file with innochecksum with --write=crc32
32 # Start the server
33 # restart
34 select count(*) from t1;
35 # Shutdown the server
36 # Move the corrupted ib file to t1.ibd
37 [1(c)]: Repair the ibd file with innochecksum with --write=none
38 # Start the server
39 # restart
40 select * from t1;
41 DROP TABLE t1;
42 [19]: Test Completed
43 CREATE TABLE tab1(c1 INT PRIMARY KEY,c2 VARCHAR(20)) COMPRESSION="none", ENGINE=InnoDB;
44 CREATE INDEX idx1 ON tab1(c2(10));
45 INSERT INTO tab1 VALUES(1, 'Innochecksum InnoDB1');
46 # shutdown the server
47 [2]: Test for verbose short option, output from innochecksum
48 # Print the verbose output
49
50 Variables (--variable-name=value)
51 and boolean options {FALSE|TRUE} Value (after reading options)
52 --------------------------------- ----------------------------------------
53 verbose TRUE
54 count FALSE
55 start-page 0
56 end-page 0
57 page 0
58 strict-check crc32
59 no-check FALSE
60 allow-mismatches 0
61 write crc32
62 page-type-summary FALSE
63 page-type-dump (No default value)
64 log (No default value)
65 [3]: test for --verbose option with --strict-check=innodb for innochecksum
66 : With verbose long option.
67 # Print the verbose output
68
69 Variables (--variable-name=value)
70 and boolean options {FALSE|TRUE} Value (after reading options)
71 --------------------------------- ----------------------------------------
72 verbose TRUE
73 count FALSE
74 start-page 0
75 end-page 0
76 page 0
77 strict-check crc32
78 no-check FALSE
79 allow-mismatches 0
80 write crc32
81 page-type-summary FALSE
82 page-type-dump (No default value)
83 log (No default value)
84 [4]: Test for --allow-mismatches =99
85 # Expect the fails for checksum mismatches. Print the error message.
86 [WARNING] innochecksum: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=X, page number=Y] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
87 [WARNING] innochecksum: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=X, page number=Y] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
88 [WARNING] innochecksum: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=X, page number=Y] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
89 [WARNING] innochecksum: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=X, page number=Y] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
90 [WARNING] innochecksum: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=X, page number=Y] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
91 [WARNING] innochecksum: innodb_checksum_algorithm is set to "strict_none" but the page [page id: space=X, page number=Y] contains a valid checksum "crc32". Accepting the page as valid. Change innodb_checksum_algorithm to "none" to silently accept such pages or rewrite all pages so that they contain "none" checksum.
92 [5]: Test checksum check for page: 2 to page:5
93 [6]: Test for checksum check for only pageno.= 2
94 [7]: Further Test are for rewrite checksum (innodb|crc32|none) for all ibd file & start the server.
95 # Restart the server
96 # restart
97 DROP TABLE tab1;
98 SET GLOBAL innodb_file_per_table=default;