Debian Codegraph @

mysql-test/suite/innodb/t/import_cfg_corrupt.test

raw
1 --source include/have_innodb.inc
2
3 --echo #
4 --echo # MDEV-39278 Validate .cfg file parser string lengths
5 --echo #
6 --echo # Test that IMPORT TABLESPACE rejects .cfg files with
7 --echo # invalid string lengths in the metadata header.
8 --echo #
9
10 call mtr.add_suppression("InnoDB: Importing tablespace for table `test`\\.`t1`");
11 call mtr.add_suppression("Index for table 't1' is corrupt; try to repair it");
12 call mtr.add_suppression("InnoDB: Discarding tablespace of table `test`\\.`t1`");
13
14 let MYSQLD_DATADIR = `SELECT @@datadir`;
15
16 --echo # Export a valid .ibd/.cfg pair to reuse across tests.
17
18 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
19 INSERT INTO t1 VALUES (1), (2), (3);
20
21 FLUSH TABLES t1 FOR EXPORT;
22
23 --copy_file $MYSQLD_DATADIR/test/t1.ibd $MYSQLD_DATADIR/test/t1.ibd.bak
24 --copy_file $MYSQLD_DATADIR/test/t1.cfg $MYSQLD_DATADIR/test/t1.cfg.bak
25
26 UNLOCK TABLES;
27 DROP TABLE t1;
28
29 --echo #
30 --echo # Test 1: Corrupt hostname length in .cfg
31 --echo # .cfg format: [4 bytes version][4 bytes hostname_len]...
32 --echo # Patch offset 4 to 0x00001000 (4096), exceeding
33 --echo # HOSTNAME_LENGTH + 1 (256).
34 --echo #
35
36 --copy_file $MYSQLD_DATADIR/test/t1.cfg.bak $MYSQLD_DATADIR/test/t1.cfg.corrupt
37
38 perl;
39 use strict;
40 my $file = "$ENV{MYSQLD_DATADIR}/test/t1.cfg.corrupt";
41 open(FILE, "+<", $file) or die "Cannot open $file: $!";
42 binmode FILE;
43 seek(FILE, 4, 0) or die "Cannot seek: $!";
44 # Write 0x00001000 (4096) in big-endian
45 print FILE pack("N", 4096);
46 close FILE or die "Cannot close: $!";
47 EOF
48
49 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
50 ALTER TABLE t1 DISCARD TABLESPACE;
51
52 --copy_file $MYSQLD_DATADIR/test/t1.ibd.bak $MYSQLD_DATADIR/test/t1.ibd
53 --move_file $MYSQLD_DATADIR/test/t1.cfg.corrupt $MYSQLD_DATADIR/test/t1.cfg
54
55 --error ER_IO_READ_ERROR
56 ALTER TABLE t1 IMPORT TABLESPACE;
57
58 DROP TABLE t1;
59
60 --echo #
61 --echo # Test 2: Zero hostname length in .cfg
62 --echo #
63
64 --copy_file $MYSQLD_DATADIR/test/t1.cfg.bak $MYSQLD_DATADIR/test/t1.cfg.corrupt
65
66 perl;
67 use strict;
68 my $file = "$ENV{MYSQLD_DATADIR}/test/t1.cfg.corrupt";
69 open(FILE, "+<", $file) or die "Cannot open $file: $!";
70 binmode FILE;
71 seek(FILE, 4, 0) or die "Cannot seek: $!";
72 # Write 0 in big-endian
73 print FILE pack("N", 0);
74 close FILE or die "Cannot close: $!";
75 EOF
76
77 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
78 ALTER TABLE t1 DISCARD TABLESPACE;
79
80 --copy_file $MYSQLD_DATADIR/test/t1.ibd.bak $MYSQLD_DATADIR/test/t1.ibd
81 --move_file $MYSQLD_DATADIR/test/t1.cfg.corrupt $MYSQLD_DATADIR/test/t1.cfg
82
83 --error ER_IO_READ_ERROR
84 ALTER TABLE t1 IMPORT TABLESPACE;
85
86 DROP TABLE t1;
87
88 --echo #
89 --echo # Test 3: Table name length zero in .cfg
90 --echo #
91
92 --copy_file $MYSQLD_DATADIR/test/t1.cfg.bak $MYSQLD_DATADIR/test/t1.cfg.corrupt
93
94 perl;
95 use strict;
96 my $file = "$ENV{MYSQLD_DATADIR}/test/t1.cfg.corrupt";
97 open(FILE, "+<", $file) or die "Cannot open $file: $!";
98 binmode FILE;
99 # Read hostname length at offset 4
100 seek(FILE, 4, 0) or die "Cannot seek: $!";
101 my $buf;
102 read(FILE, $buf, 4) == 4 or die "Cannot read: $!";
103 my $hostname_len = unpack("N", $buf);
104 # Table name length is at offset 4 + 4 + hostname_len
105 my $tablename_offset = 4 + 4 + $hostname_len;
106 seek(FILE, $tablename_offset, 0) or die "Cannot seek: $!";
107 # Write 0 in big-endian
108 print FILE pack("N", 0);
109 close FILE or die "Cannot close: $!";
110 EOF
111
112 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
113 ALTER TABLE t1 DISCARD TABLESPACE;
114
115 --copy_file $MYSQLD_DATADIR/test/t1.ibd.bak $MYSQLD_DATADIR/test/t1.ibd
116 --move_file $MYSQLD_DATADIR/test/t1.cfg.corrupt $MYSQLD_DATADIR/test/t1.cfg
117
118 --error ER_IO_READ_ERROR
119 ALTER TABLE t1 IMPORT TABLESPACE;
120
121 DROP TABLE t1;
122
123 --echo #
124 --echo # Test 4: Hostname length just over limit (257)
125 --echo # HOSTNAME_LENGTH + 1 = 256 is the max valid value.
126 --echo # 257 should be rejected.
127 --echo #
128
129 --copy_file $MYSQLD_DATADIR/test/t1.cfg.bak $MYSQLD_DATADIR/test/t1.cfg.corrupt
130
131 perl;
132 use strict;
133 my $file = "$ENV{MYSQLD_DATADIR}/test/t1.cfg.corrupt";
134 open(FILE, "+<", $file) or die "Cannot open $file: $!";
135 binmode FILE;
136 seek(FILE, 4, 0) or die "Cannot seek: $!";
137 # Write 257 (HOSTNAME_LENGTH + 2) in big-endian
138 print FILE pack("N", 257);
139 close FILE or die "Cannot close: $!";
140 EOF
141
142 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
143 ALTER TABLE t1 DISCARD TABLESPACE;
144
145 --copy_file $MYSQLD_DATADIR/test/t1.ibd.bak $MYSQLD_DATADIR/test/t1.ibd
146 --move_file $MYSQLD_DATADIR/test/t1.cfg.corrupt $MYSQLD_DATADIR/test/t1.cfg
147
148 --error ER_IO_READ_ERROR
149 ALTER TABLE t1 IMPORT TABLESPACE;
150
151 DROP TABLE t1;
152
153 --echo #
154 --echo # Test 5: Hostname length 0xFFFFFFFF (max uint32)
155 --echo #
156
157 --copy_file $MYSQLD_DATADIR/test/t1.cfg.bak $MYSQLD_DATADIR/test/t1.cfg.corrupt
158
159 perl;
160 use strict;
161 my $file = "$ENV{MYSQLD_DATADIR}/test/t1.cfg.corrupt";
162 open(FILE, "+<", $file) or die "Cannot open $file: $!";
163 binmode FILE;
164 seek(FILE, 4, 0) or die "Cannot seek: $!";
165 # Write 0xFFFFFFFF in big-endian
166 print FILE pack("N", 0xFFFFFFFF);
167 close FILE or die "Cannot close: $!";
168 EOF
169
170 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
171 ALTER TABLE t1 DISCARD TABLESPACE;
172
173 --copy_file $MYSQLD_DATADIR/test/t1.ibd.bak $MYSQLD_DATADIR/test/t1.ibd
174 --move_file $MYSQLD_DATADIR/test/t1.cfg.corrupt $MYSQLD_DATADIR/test/t1.cfg
175
176 --error ER_IO_READ_ERROR
177 ALTER TABLE t1 IMPORT TABLESPACE;
178
179 DROP TABLE t1;
180
181 --echo #
182 --echo # Test 6: Corrupt table name length in .cfg
183 --echo # The table name length field follows the hostname string.
184 --echo # We need to find and patch it dynamically.
185 --echo #
186
187 --copy_file $MYSQLD_DATADIR/test/t1.cfg.bak $MYSQLD_DATADIR/test/t1.cfg.corrupt
188
189 perl;
190 use strict;
191 my $file = "$ENV{MYSQLD_DATADIR}/test/t1.cfg.corrupt";
192 open(FILE, "+<", $file) or die "Cannot open $file: $!";
193 binmode FILE;
194 # Read hostname length at offset 4
195 seek(FILE, 4, 0) or die "Cannot seek: $!";
196 my $buf;
197 read(FILE, $buf, 4) == 4 or die "Cannot read: $!";
198 my $hostname_len = unpack("N", $buf);
199 # Table name length is at offset 4 + 4 + hostname_len
200 my $tablename_offset = 4 + 4 + $hostname_len;
201 seek(FILE, $tablename_offset, 0) or die "Cannot seek: $!";
202 # Write 0x10000000 (268 million) in big-endian
203 print FILE pack("N", 0x10000000);
204 close FILE or die "Cannot close: $!";
205 EOF
206
207 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
208 ALTER TABLE t1 DISCARD TABLESPACE;
209
210 --copy_file $MYSQLD_DATADIR/test/t1.ibd.bak $MYSQLD_DATADIR/test/t1.ibd
211 --move_file $MYSQLD_DATADIR/test/t1.cfg.corrupt $MYSQLD_DATADIR/test/t1.cfg
212
213 --error ER_IO_READ_ERROR
214 ALTER TABLE t1 IMPORT TABLESPACE;
215
216 DROP TABLE t1;
217
218 --remove_files_wildcard $MYSQLD_DATADIR/test t1.*
219
220 --echo # End of 10.11 tests