Debian Codegraph @

mysql-test/suite/innodb_zip/t/innochecksum.test

raw
1 #************************************************************
2 # WL6045:Improve Innochecksum
3 #************************************************************
4 --source include/have_innodb_max_16k.inc
5 --source include/no_valgrind_without_big.inc
6
7 # Avoid CrashReporter popup on Mac.
8 --source include/not_crashrep.inc
9
10 --echo # Set the environmental variables
11 let MYSQLD_BASEDIR= `SELECT @@basedir`;
12 let MYSQLD_DATADIR= `SELECT @@datadir`;
13 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/my_restart.err;
14 call mtr.add_suppression("Unable to read tablespace .* page no .* into the buffer pool after 100 attempts");
15 call mtr.add_suppression("Warning: database page corruption or a failed");
16
17 SET GLOBAL innodb_file_per_table=on;
18
19 CREATE TABLE tab1(c1 INT PRIMARY KEY,c2 VARCHAR(20)) ENGINE=InnoDB;
20 CREATE INDEX idx1 ON tab1(c2(10));
21 INSERT INTO tab1 VALUES(1, 'Innochecksum InnoDB1');
22 CREATE TABLE t1(id INT AUTO_INCREMENT PRIMARY KEY, msg VARCHAR(255)) ENGINE=INNODB ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
23 insert into t1 values(1,"i");
24 insert into t1 values(2,"am");
25 insert into t1 values(3,"compressed table");
26
27 --echo # Shutdown the Server
28 --source include/shutdown_mysqld.inc
29 --echo # Server Default checksum = innodb
30
31 --echo [1a]: check the innochecksum when file doesn't exists
32 --error 1
33 --exec $INNOCHECKSUM $MYSQLD_DATADIR/test/aa.ibd 2> $SEARCH_FILE
34 --replace_result $MYSQLD_DATADIR MYSQLD_DATADIR
35 let SEARCH_PATTERN= Error: $MYSQLD_DATADIR/test/aa.ibd cannot be found;
36 --source include/search_pattern.inc
37
38 --echo [1b]: check the innochecksum without --strict-check
39 --exec $INNOCHECKSUM $MYSQLD_DATADIR/test/tab1.ibd
40
41 --echo [2]: check the innochecksum with full form --strict-check=crc32
42 --exec $INNOCHECKSUM --strict-check=crc32 $MYSQLD_DATADIR/test/tab1.ibd
43
44 --echo [3]: check the innochecksum with short form -C crc32
45 --exec $INNOCHECKSUM -C crc32 $MYSQLD_DATADIR/test/tab1.ibd
46
47 --echo [4]: check the innochecksum with --no-check ignores algorithm check, warning is expected
48 --error 1
49 --exec $INNOCHECKSUM --no-check $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
50 let SEARCH_PATTERN= Error: --no-check must be associated with --write option.;
51 --source include/search_pattern.inc
52
53 --echo [5]: check the innochecksum with short form --no-check ignores algorithm check, warning is expected
54 --error 1
55 --exec $INNOCHECKSUM -n $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
56 let SEARCH_PATTERN= Error: --no-check must be associated with --write option.;
57 --source include/search_pattern.inc
58
59 --echo [6]: check the innochecksum with full form strict-check & no-check , an error is expected
60 --error 1
61 --exec $INNOCHECKSUM --strict-check=innodb --no-check $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
62 let SEARCH_PATTERN= Error: --strict-check option cannot be used together with --no-check option.;
63 --source include/search_pattern.inc
64
65 --echo [7]: check the innochecksum with short form strict-check & no-check , an error is expected
66 --error 1
67 --exec $INNOCHECKSUM -C innodb -n $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
68 let SEARCH_PATTERN= Error: --strict-check option cannot be used together with --no-check option.;
69 --source include/search_pattern.inc
70
71 --echo [8]: check the innochecksum with short & full form combination
72 --echo # strict-check & no-check, an error is expected
73 --error 1
74 --exec $INNOCHECKSUM --strict-check=innodb -n $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
75 let SEARCH_PATTERN= Error: --strict-check option cannot be used together with --no-check option.;
76 --source include/search_pattern.inc
77
78 --echo [9]: check the innochecksum with full form --strict-check=innodb
79 # Server Default checksum = crc32
80 --exec $INNOCHECKSUM --strict-check=innodb $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
81
82 --echo [10]: check the innochecksum with full form --strict-check=none
83 --echo # when server Default checksum=crc32
84 --exec $INNOCHECKSUM --strict-check=none $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
85
86 --echo [11]: check the innochecksum with short form -C innodb
87 --echo # when server Default checksum=crc32
88 --exec $INNOCHECKSUM -C innodb $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
89
90 --echo [12]: check the innochecksum with short form -C none
91 --echo # when server Default checksum=crc32
92 --exec $INNOCHECKSUM -C none $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
93
94 --echo [13]: check strict-check with invalid values
95 --error 1
96 --exec $INNOCHECKSUM --strict-check=strict_innodb $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
97 let SEARCH_PATTERN= Error while setting value \'strict_innodb\' to \'strict-check\';
98 --source include/search_pattern.inc
99
100 --error 1
101 --exec $INNOCHECKSUM -C strict_innodb $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
102 let SEARCH_PATTERN= Error while setting value \'strict_innodb\' to \'strict-check\';
103 --source include/search_pattern.inc
104
105 --error 1
106 --exec $INNOCHECKSUM --strict-check=strict_crc32 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
107 let SEARCH_PATTERN= Error while setting value \'strict_crc32\' to \'strict-check\';
108 --source include/search_pattern.inc
109
110 --error 1
111 --exec $INNOCHECKSUM -C strict_crc32 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
112 let SEARCH_PATTERN= Error while setting value \'strict_crc32\' to \'strict-check\';
113 --source include/search_pattern.inc
114
115 --error 1
116 --exec $INNOCHECKSUM --strict-check=strict_none $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
117 let SEARCH_PATTERN= Error while setting value \'strict_none\' to \'strict-check\';
118 --source include/search_pattern.inc
119
120 --error 1
121 --exec $INNOCHECKSUM -C strict_none $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
122 let SEARCH_PATTERN= Error while setting value \'strict_none\' to \'strict-check\';
123 --source include/search_pattern.inc
124
125 --error 1
126 --exec $INNOCHECKSUM --strict-check=InnoBD $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
127 let SEARCH_PATTERN= Error while setting value \'InnoBD\' to \'strict-check\';
128 --source include/search_pattern.inc
129
130 --error 1
131 --exec $INNOCHECKSUM -C InnoBD $MYSQLD_DATADIR/test/tab1.ibd 2>$SEARCH_FILE
132 let SEARCH_PATTERN= Error while setting value \'InnoBD\' to \'strict-check\';
133 --source include/search_pattern.inc
134
135 --error 1
136 --exec $INNOCHECKSUM --strict-check=crc $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
137 let SEARCH_PATTERN= Error while setting value \'crc\' to \'strict-check\';
138 --source include/search_pattern.inc
139
140 --error 1
141 --exec $INNOCHECKSUM --strict-check=no $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
142 let SEARCH_PATTERN= Error while setting value \'no\' to \'strict-check\';
143 --source include/search_pattern.inc
144
145 --echo [14a]: when server default checksum=crc32 rewrite new checksum=crc32 with innochecksum
146 --echo # Also check the long form of write option.
147 --exec $INNOCHECKSUM --strict-check=crc32 --write=crc32 $MYSQLD_DATADIR/test/tab1.ibd
148 --exec $INNOCHECKSUM --strict-check=crc32 --write=crc32 $MYSQLD_DATADIR/test/t1.ibd
149 # Rewrite done, verify with --strict-check=crc32
150 --exec $INNOCHECKSUM --strict-check=crc32 $MYSQLD_DATADIR/test/tab1.ibd
151 --exec $INNOCHECKSUM --strict-check=crc32 $MYSQLD_DATADIR/test/t1.ibd
152
153 --echo [14b]: when server default checksum=crc32 rewrite new checksum=innodb with innochecksum
154 --echo # Also check the long form of write option.
155 --exec $INNOCHECKSUM --no-check --write=innodb $MYSQLD_DATADIR/test/tab1.ibd
156 --exec $INNOCHECKSUM --strict-check=crc32 --write=innodb $MYSQLD_DATADIR/test/t1.ibd
157 # Rewrite done, verify with --strict-check=innodb
158 --exec $INNOCHECKSUM --strict-check=innodb $MYSQLD_DATADIR/test/tab1.ibd
159
160 --echo # start the server with innodb_checksum_algorithm=InnoDB
161 --let restart_parameters= restart: --innodb_checksum_algorithm=innodb
162 --source include/start_mysqld.inc
163
164 INSERT INTO tab1 VALUES(2, 'Innochecksum CRC32');
165 SELECT c1,c2 FROM tab1 order by c1,c2;
166
167 --echo # Stop the server
168 --source include/shutdown_mysqld.inc
169
170 --echo [15]: when server default checksum=crc32 rewrite new checksum=none with innochecksum
171 --echo # Also check the short form of write option.
172 --exec $INNOCHECKSUM --no-check -w none $MYSQLD_DATADIR/test/tab1.ibd
173 --exec $INNOCHECKSUM --no-check -w none $MYSQLD_DATADIR/test/t1.ibd
174 # Rewrite done, verify with --strict-check=none
175 --exec $INNOCHECKSUM --strict-check=none $MYSQLD_DATADIR/test/tab1.ibd
176 --exec $INNOCHECKSUM --strict-check=none $MYSQLD_DATADIR/test/t1.ibd
177
178 --echo # Start the server with checksum algorithm=none
179 --let restart_parameters=restart: --innodb_checksum_algorithm=none
180 --source include/start_mysqld.inc
181
182 INSERT INTO tab1 VALUES(3, 'Innochecksum None');
183 SELECT c1,c2 FROM tab1 order by c1,c2;
184 DROP TABLE t1;
185
186 --echo # Stop the server
187 --source include/shutdown_mysqld.inc
188
189 --echo [16]: rewrite into new checksum=crc32 with innochecksum
190 --exec $INNOCHECKSUM --no-check --write=crc32 $MYSQLD_DATADIR/test/tab1.ibd
191
192 --echo # Restart the DB server with innodb_checksum_algorithm=crc32
193 --let restart_parameters=restart: --innodb_checksum_algorithm=crc32 --innodb_file_per_table=on
194 --source include/start_mysqld.inc
195
196 SELECT * FROM tab1;
197 DELETE FROM tab1 where c1=3;
198 SELECT c1,c2 FROM tab1 order by c1,c2;
199
200 --echo # Stop server
201 --source include/shutdown_mysqld.inc
202
203 --echo [17]: rewrite into new checksum=InnoDB
204 --exec $INNOCHECKSUM --no-check --write=InnoDB $MYSQLD_DATADIR/test/tab1.ibd
205
206 --echo # Restart the DB server with innodb_checksum_algorithm=InnoDB
207 --let restart_parameters=restart: --innodb_checksum_algorithm=innodb --innodb_file_per_table=on
208 --source include/start_mysqld.inc
209
210 DELETE FROM tab1 where c1=2;
211 SELECT * FROM tab1;
212
213 --echo # Stop server
214 --source include/shutdown_mysqld.inc
215
216 --echo [18]:check Innochecksum with invalid write options
217 --error 1
218 --exec $INNOCHECKSUM --no-check --write=strict_crc32 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
219 let SEARCH_PATTERN=Error while setting value \'strict_crc32\' to \'write\';
220 --source include/search_pattern.inc
221
222 --error 1
223 --exec $INNOCHECKSUM --no-check --write=strict_innodb $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
224 let SEARCH_PATTERN=Error while setting value \'strict_innodb\' to \'write\';
225 --source include/search_pattern.inc
226
227 --error 1
228 --exec $INNOCHECKSUM --no-check --write=crc23 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
229 let SEARCH_PATTERN=Error while setting value \'crc23\' to \'write\';
230 --source include/search_pattern.inc
231 --remove_file $SEARCH_FILE
232
233 # Cleanup
234 --echo # Restart the server
235 --let $restart_parameters=
236 --source include/start_mysqld.inc
237
238 DROP TABLE tab1;
239 SET GLOBAL innodb_file_per_table=default;