Debian Codegraph @

mysql-test/suite/innodb_zip/r/wl5522_debug_zip.result

raw
1 ALTER DATABASE test CHARACTER SET latin1 COLLATE latin1_swedish_ci;
2 call mtr.add_suppression("InnoDB: Tablespace for table .* is set as discarded\\.");
3 call mtr.add_suppression("InnoDB: Cannot calculate statistics for table .* because the .ibd file is missing. Please refer to .* for how to resolve the issue\\.");
4 call mtr.add_suppression("InnoDB: Page 0 at offset 0 looks corrupted in file");
5 call mtr.add_suppression("InnoDB: Page for tablespace ");
6 call mtr.add_suppression("InnoDB: Invalid FSP_SPACE_FLAGS=0x");
7 call mtr.add_suppression("InnoDB: Unknown index id .* on page");
8 call mtr.add_suppression("InnoDB: Operating system error number");
9 call mtr.add_suppression("InnoDB: Error number \\d+ means");
10 call mtr.add_suppression("InnoDB: Cannot open datafile .*t1\\.ibd");
11 call mtr.add_suppression("InnoDB: Ignoring tablespace for test/t1 ");
12 call mtr.add_suppression("InnoDB: Cannot save statistics for table `test`\\.`t1` because the \\.ibd file is missing");
13 call mtr.add_suppression("InnoDB: Failed to read page \\d+ from file '.*test/t1\\.ibd'");
14 call mtr.add_suppression("InnoDB: File '.*(ibdata1|t1\\.ibd)' is corrupted");
15 FLUSH TABLES;
16 SET SESSION innodb_strict_mode=1;
17 CREATE TABLE t1 (c1 INT) ENGINE = Innodb
18 ROW_FORMAT=COMPRESSED;
19 INSERT INTO t1 VALUES (1), (2), (3), (4);
20 FLUSH TABLES t1 FOR EXPORT;
21 backup: t1
22 UNLOCK TABLES;
23 DROP TABLE t1;
24 CREATE TABLE t1 (c1 INT) ENGINE = Innodb
25 ROW_FORMAT=COMPRESSED;
26 INSERT INTO t1 VALUES (1);
27 ALTER TABLE t1 DISCARD TABLESPACE;
28 SELECT COUNT(*) FROM t1;
29 ERROR HY000: Tablespace has been discarded for table `t1`
30 restore: t1 .ibd and .cfg files
31 SET SESSION debug_dbug="+d,ib_import_before_commit_crash";
32 SELECT * FROM t1;
33 ERROR HY000: Tablespace has been discarded for table `t1`
34 ALTER TABLE t1 IMPORT TABLESPACE;
35 ERROR HY000: Lost connection to server during query
36 SET SESSION debug_dbug="+d,ib_import_before_checkpoint_crash";
37 SELECT COUNT(*) FROM t1;
38 ERROR HY000: Tablespace has been discarded for table `t1`
39 ALTER TABLE t1 IMPORT TABLESPACE;
40 ERROR HY000: Lost connection to server during query
41 unlink: t1.ibd
42 unlink: t1.cfg
43 # Restart and reconnect to the server
44 DROP TABLE t1;
45 SET SESSION innodb_strict_mode=1;
46 CREATE TABLE t1 (c1 INT) ENGINE = Innodb
47 ROW_FORMAT=COMPRESSED;
48 ALTER TABLE t1 DISCARD TABLESPACE;
49 restore: t1 .ibd and .cfg files
50 ALTER TABLE t1 IMPORT TABLESPACE;
51 CHECK TABLE t1;
52 Table Op Msg_type Msg_text
53 test.t1 check status OK
54 SELECT COUNT(*) FROM t1;
55 COUNT(*)
56 4
57 INSERT INTO t1 VALUES(400), (500), (600);
58 SELECT * FROM t1;
59 c1
60 1
61 2
62 3
63 4
64 400
65 500
66 600
67 DROP TABLE t1;
68 CREATE TABLE t1 (c1 INT) ENGINE = Innodb
69 ROW_FORMAT=COMPRESSED;
70 ALTER TABLE t1 DISCARD TABLESPACE;
71 SELECT COUNT(*) FROM t1;
72 ERROR HY000: Tablespace has been discarded for table `t1`
73 restore: t1 .ibd and .cfg files
74 SET @saved_debug_dbug = @@SESSION.debug_dbug;
75 SET SESSION debug_dbug="+d,ib_import_internal_error";
76 ALTER TABLE t1 IMPORT TABLESPACE;
77 ERROR HY000: Internal error: While updating the <space, root page number> of index GEN_CLUST_INDEX - Generic error
78 SET SESSION debug_dbug=@saved_debug_dbug;
79 restore: t1 .ibd and .cfg files
80 ALTER TABLE t1 IMPORT TABLESPACE;
81 DROP TABLE t1;
82 CREATE TABLE t1 (c1 INT) ENGINE = Innodb
83 ROW_FORMAT=COMPRESSED;
84 ALTER TABLE t1 DISCARD TABLESPACE;
85 SELECT COUNT(*) FROM t1;
86 ERROR HY000: Tablespace has been discarded for table `t1`
87 restore: t1 .ibd and .cfg files
88 SET SESSION debug_dbug="+d,ib_import_reset_space_and_lsn_failure";
89 ALTER TABLE t1 IMPORT TABLESPACE;
90 ERROR HY000: Internal error: Error importing tablespace for table `test`.`t1` : Too many concurrent transactions
91 restore: t1 .ibd and .cfg files
92 SET SESSION debug_dbug=@saved_debug_dbug;
93 SET SESSION debug_dbug="+d,ib_import_open_tablespace_failure";
94 ALTER TABLE t1 IMPORT TABLESPACE;
95 ERROR HY000: Got error 41 'Tablespace not found' from ./test/t1.ibd
96 SET SESSION debug_dbug=@saved_debug_dbug;
97 restore: t1 .ibd and .cfg files
98 SET SESSION debug_dbug="+d,ib_import_cluster_root_adjust_failure";
99 ALTER TABLE t1 IMPORT TABLESPACE;
100 ERROR HY000: Index for table 't1' is corrupt; try to repair it
101 SET SESSION debug_dbug=@saved_debug_dbug;
102 restore: t1 .ibd and .cfg files
103 SET SESSION debug_dbug="+d,ib_import_cluster_failure";
104 ALTER TABLE t1 IMPORT TABLESPACE;
105 ERROR HY000: Index for table 't1' is corrupt; try to repair it
106 SET SESSION debug_dbug=@saved_debug_dbug;
107 restore: t1 .ibd and .cfg files
108 SET SESSION debug_dbug="+d,ib_import_sec_root_adjust_failure";
109 ALTER TABLE t1 IMPORT TABLESPACE;
110 ERROR HY000: Index for table 't1' is corrupt; try to repair it
111 SET SESSION debug_dbug=@saved_debug_dbug;
112 restore: t1 .ibd and .cfg files
113 ALTER TABLE t1 IMPORT TABLESPACE;
114 DROP TABLE t1;
115 CREATE TABLE t1 (
116 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
117 c2 BIGINT,
118 c3 VARCHAR(2048),
119 c4 VARCHAR(2048),
120 INDEX idx1(c2),
121 INDEX idx2(c3(512)),
122 INDEX idx3(c4(512))) Engine=InnoDB
123 ROW_FORMAT=COMPRESSED;
124 connect purge_control,localhost,root;
125 START TRANSACTION WITH CONSISTENT SNAPSHOT;
126 connection default;
127 INSERT INTO t1
128 SELECT 1 + seq, 1 + (seq MOD 4),
129 REPEAT(SUBSTR('abcd', 1 + (seq MOD 4), 1), 2048),
130 REPEAT(SUBSTR('abcd', 1 + (seq MOD 4), 1), 2048)
131 FROM seq_0_to_127;
132 DELETE FROM t1 WHERE c2 = 1;
133 UPDATE t1 SET c2 = c2 + c1;
134 UPDATE t1 SET c2 = c2 + c1;
135 UPDATE t1 SET c2 = c2 + c1;
136 UPDATE t1 SET c2 = c2 + c1;
137 UPDATE t1 SET c2 = c2 + c1;
138 UPDATE t1 SET c2 = c2 + c1;
139 UPDATE t1 SET c2 = c2 + c1;
140 UPDATE t1 SET c2 = c2 + c1;
141 UPDATE t1 SET c2 = c2 + c1;
142 UPDATE t1 SET c2 = c2 + c1;
143 UPDATE t1 SET c2 = c2 + c1;
144 UPDATE t1 SET c2 = c2 + c1;
145 UPDATE t1 SET c2 = c2 + c1;
146 UPDATE t1 SET c2 = c2 + c1;
147 UPDATE t1 SET c2 = c2 + c1;
148 UPDATE t1 SET c3 = REPEAT("c2", 1024);
149 UPDATE t1 SET c4 = REPEAT("c4", 1024);
150 SHOW CREATE TABLE t1;
151 Table Create Table
152 t1 CREATE TABLE `t1` (
153 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
154 `c2` bigint(20) DEFAULT NULL,
155 `c3` varchar(2048) DEFAULT NULL,
156 `c4` varchar(2048) DEFAULT NULL,
157 PRIMARY KEY (`c1`),
158 KEY `idx1` (`c2`),
159 KEY `idx2` (`c3`(512)),
160 KEY `idx3` (`c4`(512))
161 ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPRESSED
162 FLUSH TABLES t1 FOR EXPORT;
163 backup: t1
164 UNLOCK TABLES;
165 connection purge_control;
166 COMMIT;
167 disconnect purge_control;
168 connection default;
169 DROP TABLE t1;
170 CREATE TABLE t1 (
171 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
172 c2 BIGINT,
173 c3 VARCHAR(2048),
174 c4 VARCHAR(2048),
175 INDEX idx1(c2),
176 INDEX idx2(c3(512)),
177 INDEX idx3(c4(512))) Engine=InnoDB
178 ROW_FORMAT=COMPRESSED;
179 SELECT c1, c2 FROM t1;
180 c1 c2
181 ALTER TABLE t1 DISCARD TABLESPACE;
182 restore: t1 .ibd and .cfg files
183 ALTER TABLE t1 IMPORT TABLESPACE;
184 CHECK TABLE t1;
185 Table Op Msg_type Msg_text
186 test.t1 check status OK
187 SELECT c1,c2 FROM t1;
188 c1 c2
189 2 32
190 3 48
191 4 64
192 6 92
193 7 108
194 8 124
195 10 152
196 11 168
197 12 184
198 14 212
199 15 228
200 16 244
201 18 272
202 19 288
203 20 304
204 22 332
205 23 348
206 24 364
207 26 392
208 27 408
209 28 424
210 30 452
211 31 468
212 32 484
213 34 512
214 35 528
215 36 544
216 38 572
217 39 588
218 40 604
219 42 632
220 43 648
221 44 664
222 46 692
223 47 708
224 48 724
225 50 752
226 51 768
227 52 784
228 54 812
229 55 828
230 56 844
231 58 872
232 59 888
233 60 904
234 62 932
235 63 948
236 64 964
237 66 992
238 67 1008
239 68 1024
240 70 1052
241 71 1068
242 72 1084
243 74 1112
244 75 1128
245 76 1144
246 78 1172
247 79 1188
248 80 1204
249 82 1232
250 83 1248
251 84 1264
252 86 1292
253 87 1308
254 88 1324
255 90 1352
256 91 1368
257 92 1384
258 94 1412
259 95 1428
260 96 1444
261 98 1472
262 99 1488
263 100 1504
264 102 1532
265 103 1548
266 104 1564
267 106 1592
268 107 1608
269 108 1624
270 110 1652
271 111 1668
272 112 1684
273 114 1712
274 115 1728
275 116 1744
276 118 1772
277 119 1788
278 120 1804
279 122 1832
280 123 1848
281 124 1864
282 126 1892
283 127 1908
284 128 1924
285 SHOW CREATE TABLE t1;
286 Table Create Table
287 t1 CREATE TABLE `t1` (
288 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
289 `c2` bigint(20) DEFAULT NULL,
290 `c3` varchar(2048) DEFAULT NULL,
291 `c4` varchar(2048) DEFAULT NULL,
292 PRIMARY KEY (`c1`),
293 KEY `idx1` (`c2`),
294 KEY `idx2` (`c3`(512)),
295 KEY `idx3` (`c4`(512))
296 ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci ROW_FORMAT=COMPRESSED
297 DROP TABLE t1;
298 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
299 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
300 INSERT INTO t1
301 SELECT 100, REPEAT('Karanbir', 128), REPEAT('Ajeeth', 1200)
302 FROM seq_1_to_256;
303 FLUSH TABLES t1 FOR EXPORT;
304 backup: t1
305 UNLOCK TABLES;
306 DROP TABLE t1;
307 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
308 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
309 ALTER TABLE t1 DISCARD TABLESPACE;
310 SELECT COUNT(*) FROM t1;
311 ERROR HY000: Tablespace has been discarded for table `t1`
312 restore: t1 .ibd and .cfg files
313 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_1";
314 ALTER TABLE t1 IMPORT TABLESPACE;
315 ERROR HY000: Internal error: Error importing tablespace for table `test`.`t1` : Data structure corruption
316 SET SESSION debug_dbug=@saved_debug_dbug;
317 DROP TABLE t1;
318 unlink: t1.ibd
319 unlink: t1.cfg
320 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
321 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
322 ALTER TABLE t1 DISCARD TABLESPACE;
323 SELECT COUNT(*) FROM t1;
324 ERROR HY000: Tablespace has been discarded for table `t1`
325 restore: t1 .ibd and .cfg files
326 ALTER TABLE t1 IMPORT TABLESPACE;
327 Got one of the listed errors
328 DROP TABLE t1;
329 unlink: t1.ibd
330 unlink: t1.cfg
331 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
332 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
333 ALTER TABLE t1 DISCARD TABLESPACE;
334 SELECT COUNT(*) FROM t1;
335 ERROR HY000: Tablespace has been discarded for table `t1`
336 restore: t1 .ibd and .cfg files
337 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_2";
338 ALTER TABLE t1 IMPORT TABLESPACE;
339 ERROR HY000: Index corrupt: Externally stored column(5) has a reference length of 19 in the cluster index GEN_CLUST_INDEX
340 SET SESSION debug_dbug=@saved_debug_dbug;
341 DROP TABLE t1;
342 unlink: t1.ibd
343 unlink: t1.cfg
344 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
345 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
346 ALTER TABLE t1 DISCARD TABLESPACE;
347 SELECT COUNT(*) FROM t1;
348 ERROR HY000: Tablespace has been discarded for table `t1`
349 restore: t1 .ibd and .cfg files
350 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_3";
351 ALTER TABLE t1 IMPORT TABLESPACE;
352 ERROR HY000: Index for table 't1' is corrupt; try to repair it
353 SET SESSION debug_dbug=@saved_debug_dbug;
354 DROP TABLE t1;
355 unlink: t1.ibd
356 unlink: t1.cfg
357 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
358 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
359 ALTER TABLE t1 DISCARD TABLESPACE;
360 SELECT COUNT(*) FROM t1;
361 ERROR HY000: Tablespace has been discarded for table `t1`
362 SET SESSION debug_dbug="+d,ib_import_create_index_failure_1";
363 ALTER TABLE t1 ADD INDEX idx(c1);
364 Warnings:
365 Warning 1814 Tablespace has been discarded for table `t1`
366 SET SESSION debug_dbug=@saved_debug_dbug;
367 DROP TABLE t1;
368 unlink: t1.ibd
369 unlink: t1.cfg
370 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
371 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
372 ALTER TABLE t1 DISCARD TABLESPACE;
373 SELECT COUNT(*) FROM t1;
374 ERROR HY000: Tablespace has been discarded for table `t1`
375 restore: t1 .ibd and .cfg files
376 SET SESSION debug_dbug="+d,fil_space_create_failure";
377 ALTER TABLE t1 IMPORT TABLESPACE;
378 ERROR HY000: Got error 11 'Generic error' from ./test/t1.ibd
379 SET SESSION debug_dbug=@saved_debug_dbug;
380 DROP TABLE t1;
381 unlink: t1.ibd
382 unlink: t1.cfg
383 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
384 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
385 ALTER TABLE t1 DISCARD TABLESPACE;
386 SELECT COUNT(*) FROM t1;
387 ERROR HY000: Tablespace has been discarded for table `t1`
388 restore: t1 .ibd and .cfg files
389 SET SESSION debug_dbug="+d,dict_tf_to_fsp_flags_failure";
390 ALTER TABLE t1 IMPORT TABLESPACE;
391 ERROR HY000: Got error 37 'Data structure corruption' from ./test/t1.ibd
392 SET SESSION debug_dbug=@saved_debug_dbug;
393 DROP TABLE t1;
394 unlink: t1.ibd
395 unlink: t1.cfg
396 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
397 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
398 ALTER TABLE t1 DISCARD TABLESPACE;
399 SELECT COUNT(*) FROM t1;
400 ERROR HY000: Tablespace has been discarded for table `t1`
401 restore: t1 .ibd and .cfg files
402 SET SESSION debug_dbug="+d,fsp_flags_is_valid_failure";
403 ALTER TABLE t1 IMPORT TABLESPACE;
404 ERROR HY000: Index for table 't1' is corrupt; try to repair it
405 SET SESSION debug_dbug=@saved_debug_dbug;
406 DROP TABLE t1;
407 unlink: t1.ibd
408 unlink: t1.cfg
409 ALTER DATABASE test CHARACTER SET utf8mb4 COLLATE utf8mb4_uca1400_ai_ci;