Debian Codegraph @

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

raw
1 #************************************************************
2 # WL6045:Improve Innochecksum
3 #************************************************************
4 --source include/innodb_page_size_small.inc
5
6 --source include/no_valgrind_without_big.inc
7
8 # Embedded server does not support crashing.
9 --source include/not_embedded.inc
10
11 # Avoid CrashReporter popup on Mac.
12 --source include/not_crashrep.inc
13
14 --echo # Set the environmental variables
15 let MYSQLD_BASEDIR= `SELECT @@basedir`;
16 let MYSQLD_DATADIR= `SELECT @@datadir`;
17 let SEARCH_FILE= $MYSQLTEST_VARDIR/log/my_restart.err;
18
19 call mtr.add_suppression("InnoDB: Unable to read tablespace .* page no .* into the buffer pool after 100 attempts");
20 call mtr.add_suppression("InnoDB: innodb_checksum_algorithm is set to.*");
21
22 CREATE TABLE tab1 (pk INTEGER NOT NULL PRIMARY KEY,
23 linestring_key GEOMETRY NOT NULL,
24 linestring_nokey GEOMETRY NOT NULL)
25 ENGINE=InnoDB ;
26
27 INSERT INTO tab1 (pk, linestring_key, linestring_nokey)
28 VALUES (1, ST_GeomFromText('POINT(10 10) '), ST_GeomFromText('POINT(10 10) '));
29
30 CREATE INDEX linestring_index ON tab1(linestring_nokey(5));
31 ALTER TABLE tab1 ADD KEY (linestring_key(5));
32
33 --echo # create a compressed table
34 CREATE TABLE tab2(col_1 CHAR (255) ,
35 col_2 VARCHAR (255), col_3 longtext,
36 col_4 longtext,col_5 longtext,
37 col_6 longtext , col_7 int )
38 engine = innodb row_format=compressed key_block_size=4;
39
40 CREATE INDEX idx1 ON tab2(col_3(10));
41 CREATE INDEX idx2 ON tab2(col_4(10));
42 CREATE INDEX idx3 ON tab2(col_5(10));
43
44 # load the with repeat function
45 SET @col_1 = repeat('a', 5);
46 SET @col_2 = repeat('b', 20);
47 SET @col_3 = repeat('c', 100);
48 SET @col_4 = repeat('d', 100);
49 SET @col_5 = repeat('e', 100);
50 SET @col_6 = repeat('f', 100);
51
52 # insert 5 records
53 let $i = 5;
54 while ($i) {
55 eval INSERT INTO tab2(col_1,col_2,col_3,col_4,col_5,col_6,col_7)
56 VALUES (@col_1,@col_2,@col_3,@col_4,@cl_5,@col_6,$i);
57 dec $i;
58 }
59
60 --echo # stop the server
61 --source include/shutdown_mysqld.inc
62
63 --echo [2]: Check the page type summary with shortform for tab1.ibd
64 --replace_regex /File.*.ibd/File::tab1.ibd/ /[0-9]+/#/
65 --exec $INNOCHECKSUM -S $MYSQLD_DATADIR/test/tab1.ibd 2>$MYSQLTEST_VARDIR/tmp/page_summary_short.txt
66
67 --echo [3]: Check the page type summary with longform for tab1.ibd
68 --replace_regex /File.*.ibd/File::tab1.ibd/ /[0-9]+/#/
69 --exec $INNOCHECKSUM --page-type-summary $MYSQLD_DATADIR/test/tab1.ibd 2>$MYSQLTEST_VARDIR/tmp/page_summary_long.txt
70
71 --remove_file $MYSQLTEST_VARDIR/tmp/page_summary_short.txt
72 --remove_file $MYSQLTEST_VARDIR/tmp/page_summary_long.txt
73 --echo [4]: Page type dump for with longform for tab1.ibd
74 --replace_result $MYSQLTEST_VARDIR MYSQLTEST_VARDIR
75 --exec $INNOCHECKSUM --page-type-dump $MYSQLTEST_VARDIR/tmp/dump.txt $MYSQLD_DATADIR/test/tab1.ibd
76
77 perl;
78 use strict;
79 use warnings;
80 use File::Copy;
81 my $dir = $ENV{'MYSQLTEST_VARDIR'};
82 opendir(DIR, $dir) or die $!;
83 my $file= 'dump.txt';
84 # open file in write mode
85 open IN_FILE,"<", "$dir/tmp/$file" or die $!;
86 open OUT_FILE, ">", "$dir/tmp/innochecksum_3_tempfile" or die $!;
87 while(<IN_FILE>)
88 {
89 # Replace the intergers to # and complete file path to file name only.
90 $_=~ s/Filename.+/Filename::tab1.ibd/g;
91 $_=~ s/\d+/#/g;
92 print OUT_FILE $_;
93 }
94 close(IN_FILE);
95 close(OUT_FILE);
96 # move the new content from tmp file to the orginal file.
97 move ("$dir/tmp/innochecksum_3_tempfile", "$dir/tmp/$file");
98 closedir(DIR);
99 EOF
100
101 --echo # Print the contents stored in dump.txt
102 cat_file $MYSQLTEST_VARDIR/tmp/dump.txt;
103 --remove_file $MYSQLTEST_VARDIR/tmp/dump.txt
104
105 --echo # Variables used by page type dump for ibdata1
106 --exec $INNOCHECKSUM -v --page-type-dump $MYSQLTEST_VARDIR/tmp/dump.txt $MYSQLD_DATADIR/ibdata1 > $MYSQLTEST_VARDIR/tmp/page_verbose_summary.txt
107
108 --file_exists $MYSQLTEST_VARDIR/tmp/dump.txt
109 --remove_file $MYSQLTEST_VARDIR/tmp/dump.txt
110
111 perl;
112 use strict;
113 use warnings;
114 use File::Copy;
115 my $dir = $ENV{'MYSQLTEST_VARDIR'};
116 opendir(DIR, $dir) or die $!;
117 my $file= 'page_verbose_summary.txt';
118 # open file in write mode
119 open IN_FILE,"<", "$dir/tmp/$file" or die $!;
120 open OUT_FILE, ">", "$dir/tmp/innochecksum_3_tempfile" or die $!;
121 while(<IN_FILE>)
122 {
123 # Replace complete file path to file name only.
124 $_=~ s/$dir/MYSQLTEST_VARDIR/;
125 # Remove debug option, which is not in all builds
126 next if (/debug/);
127 print OUT_FILE $_;
128 }
129 close(IN_FILE);
130 close(OUT_FILE);
131 # move the new content from tmp file to the orginal file.
132 move ("$dir/tmp/innochecksum_3_tempfile", "$dir/tmp/$file");
133 closedir(DIR);
134 EOF
135
136 cat_file $MYSQLTEST_VARDIR/tmp/page_verbose_summary.txt;
137 --remove_file $MYSQLTEST_VARDIR/tmp/page_verbose_summary.txt
138
139 --echo [5]: Page type dump for with shortform for tab1.ibd
140 --exec $INNOCHECKSUM -D $MYSQLTEST_VARDIR/tmp/dump.txt $MYSQLD_DATADIR/test/tab1.ibd
141
142 perl;
143 use strict;
144 use warnings;
145 use File::Copy;
146 my $dir = $ENV{'MYSQLTEST_VARDIR'};
147 opendir(DIR, $dir) or die $!;
148 my $file= 'dump.txt';
149 # open file in write mode
150 open IN_FILE,"<", "$dir/tmp/$file" or die $!;
151 open OUT_FILE, ">", "$dir/tmp/innochecksum_3_tempfile" or die $!;
152 while(<IN_FILE>)
153 {
154 # Replace the intergers to # and complete file path to file name only.
155 $_=~ s/Filename.+/Filename::tab1.ibd/g;
156 $_=~ s/\d+/#/g;
157 print OUT_FILE $_;
158 }
159 close(IN_FILE);
160 close(OUT_FILE);
161 # move the new content from tmp file to the orginal file.
162 move ("$dir/tmp/innochecksum_3_tempfile", "$dir/tmp/$file");
163 closedir(DIR);
164 EOF
165
166 # Print the contents stored in dump.txt
167 cat_file $MYSQLTEST_VARDIR/tmp/dump.txt;
168 --remove_file $MYSQLTEST_VARDIR/tmp/dump.txt
169
170 --echo [6]: check the valid lower bound values for option
171 --echo # allow-mismatches,page,start-page,end-page
172 --exec $INNOCHECKSUM --allow-mismatches=0 $MYSQLD_DATADIR/test/tab1.ibd
173 --exec $INNOCHECKSUM -a 0 $MYSQLD_DATADIR/test/tab1.ibd
174 --exec $INNOCHECKSUM --page=0 $MYSQLD_DATADIR/test/tab1.ibd
175 --exec $INNOCHECKSUM -p 0 $MYSQLD_DATADIR/test/tab1.ibd
176 --exec $INNOCHECKSUM --start-page=0 $MYSQLD_DATADIR/test/tab1.ibd
177 --exec $INNOCHECKSUM -s 0 $MYSQLD_DATADIR/test/tab1.ibd
178 --exec $INNOCHECKSUM --end-page=0 $MYSQLD_DATADIR/test/tab1.ibd
179 --exec $INNOCHECKSUM -e 0 $MYSQLD_DATADIR/test/tab1.ibd
180
181 #
182 # These produce now errors
183 #
184 #--echo [7]: check the negative values for option
185 #--echo # allow-mismatches,page,start-page,end-page.
186 #--echo # They will reset to zero for negative values.
187 #--echo # check the invalid lower bound values
188 #--exec $INNOCHECKSUM --allow-mismatches=-1 $MYSQLD_DATADIR/test/tab1.ibd
189 #--exec $INNOCHECKSUM -a -1 $MYSQLD_DATADIR/test/tab1.ibd
190 #--exec $INNOCHECKSUM --page=-1 $MYSQLD_DATADIR/test/tab1.ibd
191 #--exec $INNOCHECKSUM -p -1 $MYSQLD_DATADIR/test/tab1.ibd
192 #--exec $INNOCHECKSUM --start-page=-1 $MYSQLD_DATADIR/test/tab1.ibd
193 #--exec $INNOCHECKSUM -s -1 $MYSQLD_DATADIR/test/tab1.ibd
194 #--exec $INNOCHECKSUM --end-page=-1 $MYSQLD_DATADIR/test/tab1.ibd
195 #--exec $INNOCHECKSUM -e -1 $MYSQLD_DATADIR/test/tab1.ibd
196 #
197 #--echo [8]: check the valid upper bound values for
198 #--echo # both short and long options "allow-mismatches" and "end-page"
199 #
200 #--exec $INNOCHECKSUM --allow-mismatches=18446744073709551615 $MYSQLD_DATADIR/test/tab1.ibd
201 #--exec $INNOCHECKSUM -a 18446744073709551615 $MYSQLD_DATADIR/test/tab1.ibd
202 #--exec $INNOCHECKSUM --end-page=18446744073709551615 $MYSQLD_DATADIR/test/tab1.ibd
203 #--exec $INNOCHECKSUM -e 18446744073709551615 $MYSQLD_DATADIR/test/tab1.ibd
204
205 --echo [9]: check the both short and long options "page" and "start-page" when
206 --echo # seek value is larger than file size.
207 --error 1
208 --exec $INNOCHECKSUM --page=18446744073709551615 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
209 let SEARCH_PATTERN= Error: Unable to seek to necessary offset;
210 --source include/search_pattern_in_file.inc
211
212 --error 1
213 --exec $INNOCHECKSUM -p 18446744073709551615 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
214 --source include/search_pattern_in_file.inc
215
216 --error 1
217 --exec $INNOCHECKSUM --start-page=18446744073709551615 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
218 --source include/search_pattern_in_file.inc
219
220 --error 1
221 --exec $INNOCHECKSUM -s 18446744073709551615 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
222 --source include/search_pattern_in_file.inc
223
224 --echo [34]: check the invalid upper bound values for options, allow-mismatches, end-page, start-page and page.
225 --echo # innochecksum will fail with error code: 1
226 --error 1
227 --exec $INNOCHECKSUM --allow-mismatches=18446744073709551616 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
228 let SEARCH_PATTERN= Incorrect unsigned integer value: '18446744073709551616';
229 --source include/search_pattern_in_file.inc
230
231 --error 1
232 --exec $INNOCHECKSUM -a 18446744073709551616 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
233 let SEARCH_PATTERN= Incorrect unsigned integer value: '18446744073709551616';
234 --source include/search_pattern_in_file.inc
235
236 --error 1
237 --exec $INNOCHECKSUM --end-page=18446744073709551616 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
238 let SEARCH_PATTERN= Incorrect unsigned integer value: '18446744073709551616';
239 --source include/search_pattern_in_file.inc
240
241 --error 1
242 --exec $INNOCHECKSUM -e 18446744073709551616 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
243 let SEARCH_PATTERN= Incorrect unsigned integer value: '18446744073709551616';
244 --source include/search_pattern_in_file.inc
245
246 --error 1
247 --exec $INNOCHECKSUM --page=18446744073709551616 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
248 let SEARCH_PATTERN= Incorrect unsigned integer value: '18446744073709551616';
249 --source include/search_pattern_in_file.inc
250
251 --error 1
252 --exec $INNOCHECKSUM -p 18446744073709551616 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
253 let SEARCH_PATTERN= Incorrect unsigned integer value: '18446744073709551616';
254 --source include/search_pattern_in_file.inc
255
256 --error 1
257 --exec $INNOCHECKSUM --start-page=18446744073709551616 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
258 let SEARCH_PATTERN= Incorrect unsigned integer value: '18446744073709551616';
259 --source include/search_pattern_in_file.inc
260
261 --error 1
262 --exec $INNOCHECKSUM -s 18446744073709551616 $MYSQLD_DATADIR/test/tab1.ibd 2> $SEARCH_FILE
263 let SEARCH_PATTERN= Incorrect unsigned integer value: '18446744073709551616';
264 --source include/search_pattern_in_file.inc
265 --remove_file $SEARCH_FILE
266
267 # Cleanup
268 --source include/start_mysqld.inc
269
270 DROP TABLE tab1,tab2;