Debian Codegraph @

mysql-test/suite/innodb/r/innodb-wl5522-debug.result

raw
1 call mtr.add_suppression("InnoDB: Operating system error number .* in a file operation.");
2 call mtr.add_suppression("InnoDB: Error number \\d+ means");
3 call mtr.add_suppression("InnoDB: Cannot open datafile for read-only: .*");
4 call mtr.add_suppression("InnoDB: Ignoring tablespace .* because it could not be opened.");
5 call mtr.add_suppression("InnoDB: Tablespace for table .* is set as discarded.");
6 call mtr.add_suppression("InnoDB: Cannot calculate statistics for table .*");
7 call mtr.add_suppression("InnoDB: Page 0 at offset 0 looks corrupted in file");
8 call mtr.add_suppression("InnoDB: Page for tablespace ");
9 call mtr.add_suppression("InnoDB: Invalid FSP_SPACE_FLAGS=");
10 call mtr.add_suppression("InnoDB: Unknown index id .* on page");
11 call mtr.add_suppression("InnoDB: Cannot save statistics for table `test`\\.`t1` because the \\.ibd file is missing");
12 call mtr.add_suppression("InnoDB: Failed to read page \\d+ from file '.*test/t1\\.ibd'");
13 call mtr.add_suppression("InnoDB: File '.*(ibdata1|t1\\.ibd)' is corrupted");
14 FLUSH TABLES;
15 CREATE TABLE t1 (c1 INT) ENGINE = InnoDB;
16 INSERT INTO t1 VALUES(1),(2),(3);
17 SET SESSION debug_dbug="+d,ib_discard_before_commit_crash";
18 ALTER TABLE t1 DISCARD TABLESPACE;
19 ERROR HY000: Lost connection to server during query
20 DROP TABLE t1;
21 CREATE TABLE t1 (c1 INT) ENGINE = InnoDB;
22 INSERT INTO t1 VALUES(1),(2),(3);
23 SET SESSION debug_dbug="+d,ib_discard_after_commit_crash";
24 ALTER TABLE t1 DISCARD TABLESPACE;
25 ERROR HY000: Lost connection to server during query
26 DROP TABLE t1;
27 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
28 INSERT INTO t1 VALUES (1), (2), (3), (4);
29 FLUSH TABLES t1 FOR EXPORT;
30 backup: t1
31 UNLOCK TABLES;
32 DROP TABLE t1;
33 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
34 INSERT INTO t1 VALUES (1);
35 ALTER TABLE t1 DISCARD TABLESPACE;
36 SELECT COUNT(*) FROM t1;
37 ERROR HY000: Tablespace has been discarded for table `t1`
38 restore: t1 .ibd and .cfg files
39 SELECT * FROM t1;
40 ERROR HY000: Tablespace has been discarded for table `t1`
41 SET SESSION debug_dbug="+d,ib_import_before_commit_crash";
42 ALTER TABLE t1 IMPORT TABLESPACE;
43 ERROR HY000: Lost connection to server during query
44 SELECT COUNT(*) FROM t1;
45 ERROR HY000: Tablespace has been discarded for table `t1`
46 SET SESSION debug_dbug="+d,ib_import_before_checkpoint_crash";
47 ALTER TABLE t1 IMPORT TABLESPACE;
48 ERROR HY000: Lost connection to server during query
49 unlink: t1.ibd
50 unlink: t1.cfg
51 DROP TABLE t1;
52 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
53 ALTER TABLE t1 DISCARD TABLESPACE;
54 restore: t1 .ibd and .cfg files
55 ALTER TABLE t1 IMPORT TABLESPACE;
56 CHECK TABLE t1;
57 Table Op Msg_type Msg_text
58 test.t1 check status OK
59 SELECT COUNT(*) FROM t1;
60 COUNT(*)
61 4
62 INSERT INTO t1 VALUES(400), (500), (600);
63 SELECT * FROM t1;
64 c1
65 1
66 2
67 3
68 4
69 400
70 500
71 600
72 DROP TABLE t1;
73 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
74 INSERT INTO t1 VALUES (1);
75 SET @saved_debug_dbug = @@SESSION.debug_dbug;
76 SET SESSION debug_dbug="+d,ib_export_io_write_failure_1";
77 FLUSH TABLES t1 FOR EXPORT;
78 Warnings:
79 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
80 UNLOCK TABLES;
81 SET SESSION debug_dbug=@saved_debug_dbug;
82 DROP TABLE t1;
83 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
84 INSERT INTO t1 VALUES (1);
85 SET SESSION debug_dbug="+d,ib_export_io_write_failure_2";
86 FLUSH TABLES t1 FOR EXPORT;
87 Warnings:
88 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
89 UNLOCK TABLES;
90 SET SESSION debug_dbug=@saved_debug_dbug;
91 DROP TABLE t1;
92 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
93 INSERT INTO t1 VALUES (1);
94 SET SESSION debug_dbug="+d,ib_export_io_write_failure_3";
95 FLUSH TABLES t1 FOR EXPORT;
96 Warnings:
97 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
98 UNLOCK TABLES;
99 SET SESSION debug_dbug=@saved_debug_dbug;
100 DROP TABLE t1;
101 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
102 INSERT INTO t1 VALUES (1);
103 SET SESSION debug_dbug="+d,ib_export_io_write_failure_4";
104 FLUSH TABLES t1 FOR EXPORT;
105 Warnings:
106 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
107 UNLOCK TABLES;
108 SET SESSION debug_dbug=@saved_debug_dbug;
109 DROP TABLE t1;
110 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
111 INSERT INTO t1 VALUES (1);
112 SET SESSION debug_dbug="+d,ib_export_io_write_failure_5";
113 FLUSH TABLES t1 FOR EXPORT;
114 Warnings:
115 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
116 UNLOCK TABLES;
117 SET SESSION debug_dbug=@saved_debug_dbug;
118 DROP TABLE t1;
119 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
120 INSERT INTO t1 VALUES (1);
121 SET SESSION debug_dbug="+d,ib_export_io_write_failure_6";
122 FLUSH TABLES t1 FOR EXPORT;
123 Warnings:
124 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
125 UNLOCK TABLES;
126 SET SESSION debug_dbug=@saved_debug_dbug;
127 DROP TABLE t1;
128 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
129 INSERT INTO t1 VALUES (1);
130 SET SESSION debug_dbug="+d,ib_export_io_write_failure_7";
131 FLUSH TABLES t1 FOR EXPORT;
132 Warnings:
133 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
134 UNLOCK TABLES;
135 SET SESSION debug_dbug=@saved_debug_dbug;
136 DROP TABLE t1;
137 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
138 INSERT INTO t1 VALUES (1);
139 SET SESSION debug_dbug="+d,ib_export_io_write_failure_8";
140 FLUSH TABLES t1 FOR EXPORT;
141 Warnings:
142 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
143 UNLOCK TABLES;
144 SET SESSION debug_dbug=@saved_debug_dbug;
145 DROP TABLE t1;
146 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
147 INSERT INTO t1 VALUES (1);
148 SET SESSION debug_dbug="+d,ib_export_io_write_failure_10";
149 FLUSH TABLES t1 FOR EXPORT;
150 Warnings:
151 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
152 UNLOCK TABLES;
153 SET SESSION debug_dbug=@saved_debug_dbug;
154 DROP TABLE t1;
155 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
156 INSERT INTO t1 VALUES (1);
157 SET SESSION debug_dbug="+d,ib_export_io_write_failure_11";
158 FLUSH TABLES t1 FOR EXPORT;
159 Warnings:
160 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
161 UNLOCK TABLES;
162 SET SESSION debug_dbug=@saved_debug_dbug;
163 DROP TABLE t1;
164 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
165 INSERT INTO t1 VALUES (1);
166 SET SESSION debug_dbug="+d,ib_export_io_write_failure_12";
167 FLUSH TABLES t1 FOR EXPORT;
168 Warnings:
169 Warning 1004 Can't create file './test/t1.cfg' (errno: 9 "Bad file descriptor")
170 UNLOCK TABLES;
171 SET SESSION debug_dbug=@saved_debug_dbug;
172 DROP TABLE t1;
173 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
174 INSERT INTO t1 VALUES (100), (200), (300);
175 SELECT COUNT(*) FROM t1;
176 COUNT(*)
177 3
178 FLUSH TABLES t1 FOR EXPORT;
179 backup: t1
180 UNLOCK TABLES;
181 DROP TABLE t1;
182 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
183 INSERT INTO t1 VALUES (1);
184 ALTER TABLE t1 DISCARD TABLESPACE;
185 SELECT COUNT(*) FROM t1;
186 ERROR HY000: Tablespace has been discarded for table `t1`
187 SET SESSION debug_dbug="+d,ib_import_io_read_error_1";
188 restore: t1 .cfg file
189 ALTER TABLE t1 IMPORT TABLESPACE;
190 ERROR HY000: IO Read error: while reading index fields.
191 SET SESSION debug_dbug=@saved_debug_dbug;
192 DROP TABLE t1;
193 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
194 INSERT INTO t1 VALUES (1);
195 ALTER TABLE t1 DISCARD TABLESPACE;
196 SELECT COUNT(*) FROM t1;
197 ERROR HY000: Tablespace has been discarded for table `t1`
198 SET SESSION debug_dbug="+d,ib_import_io_read_error_2";
199 restore: t1 .cfg file
200 ALTER TABLE t1 IMPORT TABLESPACE;
201 ERROR HY000: IO Read error: while reading index meta-data, expected to read 44 bytes but read only 0 bytes
202 SET SESSION debug_dbug=@saved_debug_dbug;
203 DROP TABLE t1;
204 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
205 INSERT INTO t1 VALUES (1);
206 ALTER TABLE t1 DISCARD TABLESPACE;
207 SELECT COUNT(*) FROM t1;
208 ERROR HY000: Tablespace has been discarded for table `t1`
209 SET SESSION debug_dbug="+d,ib_import_io_read_error_3";
210 restore: t1 .cfg file
211 ALTER TABLE t1 IMPORT TABLESPACE;
212 ERROR HY000: IO Read error: while reading number of indexes.
213 SET SESSION debug_dbug=@saved_debug_dbug;
214 DROP TABLE t1;
215 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
216 INSERT INTO t1 VALUES (1);
217 ALTER TABLE t1 DISCARD TABLESPACE;
218 SELECT COUNT(*) FROM t1;
219 ERROR HY000: Tablespace has been discarded for table `t1`
220 SET SESSION debug_dbug="+d,ib_import_io_read_error_4";
221 restore: t1 .cfg file
222 ALTER TABLE t1 IMPORT TABLESPACE;
223 ERROR HY000: IO Read error: while reading table column meta-data.
224 SET SESSION debug_dbug=@saved_debug_dbug;
225 DROP TABLE t1;
226 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
227 INSERT INTO t1 VALUES (1);
228 ALTER TABLE t1 DISCARD TABLESPACE;
229 SELECT COUNT(*) FROM t1;
230 ERROR HY000: Tablespace has been discarded for table `t1`
231 SET SESSION debug_dbug="+d,ib_import_io_read_error_5";
232 restore: t1 .cfg file
233 ALTER TABLE t1 IMPORT TABLESPACE;
234 ERROR HY000: IO Read error: while reading meta-data export hostname length.
235 SET SESSION debug_dbug=@saved_debug_dbug;
236 DROP TABLE t1;
237 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
238 INSERT INTO t1 VALUES (1);
239 ALTER TABLE t1 DISCARD TABLESPACE;
240 SELECT COUNT(*) FROM t1;
241 ERROR HY000: Tablespace has been discarded for table `t1`
242 SET SESSION debug_dbug="+d,ib_import_io_read_error_6";
243 restore: t1 .cfg file
244 ALTER TABLE t1 IMPORT TABLESPACE;
245 ERROR HY000: IO Read error: while reading meta-data table name length.
246 SET SESSION debug_dbug=@saved_debug_dbug;
247 DROP TABLE t1;
248 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
249 INSERT INTO t1 VALUES (1);
250 ALTER TABLE t1 DISCARD TABLESPACE;
251 SELECT COUNT(*) FROM t1;
252 ERROR HY000: Tablespace has been discarded for table `t1`
253 SET SESSION debug_dbug="+d,ib_import_io_read_error_7";
254 restore: t1 .cfg file
255 ALTER TABLE t1 IMPORT TABLESPACE;
256 ERROR HY000: IO Read error: while reading autoinc value.
257 SET SESSION debug_dbug=@saved_debug_dbug;
258 DROP TABLE t1;
259 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
260 INSERT INTO t1 VALUES (1);
261 ALTER TABLE t1 DISCARD TABLESPACE;
262 SELECT COUNT(*) FROM t1;
263 ERROR HY000: Tablespace has been discarded for table `t1`
264 SET SESSION debug_dbug="+d,ib_import_io_read_error_8";
265 restore: t1 .cfg file
266 ALTER TABLE t1 IMPORT TABLESPACE;
267 ERROR HY000: IO Read error: while reading meta-data header.
268 SET SESSION debug_dbug=@saved_debug_dbug;
269 DROP TABLE t1;
270 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
271 INSERT INTO t1 VALUES (1);
272 ALTER TABLE t1 DISCARD TABLESPACE;
273 SELECT COUNT(*) FROM t1;
274 ERROR HY000: Tablespace has been discarded for table `t1`
275 SET SESSION debug_dbug="+d,ib_import_io_read_error_9";
276 restore: t1 .cfg file
277 ALTER TABLE t1 IMPORT TABLESPACE;
278 ERROR HY000: IO Read error: while reading meta-data version.
279 SET SESSION debug_dbug=@saved_debug_dbug;
280 DROP TABLE t1;
281 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
282 INSERT INTO t1 VALUES (1);
283 ALTER TABLE t1 DISCARD TABLESPACE;
284 SELECT COUNT(*) FROM t1;
285 ERROR HY000: Tablespace has been discarded for table `t1`
286 SET SESSION debug_dbug="+d,ib_import_string_read_error";
287 restore: t1 .cfg file
288 ALTER TABLE t1 IMPORT TABLESPACE;
289 ERROR HY000: IO Read error: while parsing export hostname.
290 SET SESSION debug_dbug=@saved_debug_dbug;
291 DROP TABLE t1;
292 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
293 INSERT INTO t1 VALUES (1);
294 ALTER TABLE t1 DISCARD TABLESPACE;
295 SELECT COUNT(*) FROM t1;
296 ERROR HY000: Tablespace has been discarded for table `t1`
297 restore: t1 .ibd and .cfg files
298 SET SESSION debug_dbug="+d,ib_import_OOM_1";
299 ALTER TABLE t1 IMPORT TABLESPACE;
300 ERROR HY000: Out of memory.
301 SET SESSION debug_dbug=@saved_debug_dbug;
302 DROP TABLE t1;
303 unlink: t1.ibd
304 unlink: t1.cfg
305 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
306 INSERT INTO t1 VALUES (1);
307 ALTER TABLE t1 DISCARD TABLESPACE;
308 SELECT COUNT(*) FROM t1;
309 ERROR HY000: Tablespace has been discarded for table `t1`
310 restore: t1 .ibd and .cfg files
311 SET SESSION debug_dbug="+d,ib_import_OOM_2";
312 ALTER TABLE t1 IMPORT TABLESPACE;
313 ERROR HY000: Out of memory.
314 SET SESSION debug_dbug=@saved_debug_dbug;
315 DROP TABLE t1;
316 unlink: t1.ibd
317 unlink: t1.cfg
318 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
319 INSERT INTO t1 VALUES (1);
320 ALTER TABLE t1 DISCARD TABLESPACE;
321 SELECT COUNT(*) FROM t1;
322 ERROR HY000: Tablespace has been discarded for table `t1`
323 restore: t1 .ibd and .cfg files
324 SET SESSION debug_dbug="+d,ib_import_OOM_4";
325 ALTER TABLE t1 IMPORT TABLESPACE;
326 ERROR HY000: Out of memory.
327 SET SESSION debug_dbug=@saved_debug_dbug;
328 DROP TABLE t1;
329 unlink: t1.ibd
330 unlink: t1.cfg
331 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
332 INSERT INTO t1 VALUES (1);
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_OOM_5";
338 ALTER TABLE t1 IMPORT TABLESPACE;
339 ERROR HY000: Out of memory.
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) ENGINE = Innodb;
345 INSERT INTO t1 VALUES (1);
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_OOM_6";
351 ALTER TABLE t1 IMPORT TABLESPACE;
352 ERROR HY000: Out of memory.
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) ENGINE = Innodb;
358 INSERT INTO t1 VALUES (1);
359 ALTER TABLE t1 DISCARD TABLESPACE;
360 SELECT COUNT(*) FROM t1;
361 ERROR HY000: Tablespace has been discarded for table `t1`
362 restore: t1 .ibd and .cfg files
363 SET SESSION debug_dbug="+d,ib_import_OOM_7";
364 ALTER TABLE t1 IMPORT TABLESPACE;
365 ERROR HY000: Out of memory.
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) ENGINE = Innodb;
371 INSERT INTO t1 VALUES (1);
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,ib_import_OOM_8";
377 ALTER TABLE t1 IMPORT TABLESPACE;
378 ERROR HY000: Out of memory.
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) ENGINE = Innodb;
384 INSERT INTO t1 VALUES (1);
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,ib_import_OOM_9";
390 ALTER TABLE t1 IMPORT TABLESPACE;
391 ERROR HY000: Out of memory.
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) ENGINE = Innodb;
397 INSERT INTO t1 VALUES (1);
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,ib_import_OOM_10";
403 ALTER TABLE t1 IMPORT TABLESPACE;
404 ERROR HY000: Out of memory.
405 SET SESSION debug_dbug=@saved_debug_dbug;
406 DROP TABLE t1;
407 unlink: t1.ibd
408 unlink: t1.cfg
409 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
410 ALTER TABLE t1 DISCARD TABLESPACE;
411 SELECT COUNT(*) FROM t1;
412 ERROR HY000: Tablespace has been discarded for table `t1`
413 restore: t1 .ibd and .cfg files
414 SET SESSION debug_dbug="+d,ib_import_internal_error";
415 ALTER TABLE t1 IMPORT TABLESPACE;
416 ERROR HY000: Internal error: While updating the <space, root page number> of index GEN_CLUST_INDEX - Generic error
417 SET SESSION debug_dbug=@saved_debug_dbug;
418 restore: t1 .ibd and .cfg files
419 ALTER TABLE t1 IMPORT TABLESPACE;
420 DROP TABLE t1;
421 CREATE TABLE t1 (c1 INT) ENGINE = Innodb;
422 ALTER TABLE t1 DISCARD TABLESPACE;
423 SELECT COUNT(*) FROM t1;
424 ERROR HY000: Tablespace has been discarded for table `t1`
425 restore: t1 .ibd and .cfg files
426 SET SESSION debug_dbug="+d,ib_import_reset_space_and_lsn_failure";
427 ALTER TABLE t1 IMPORT TABLESPACE;
428 ERROR HY000: Internal error: Error importing tablespace for table `test`.`t1` : Too many concurrent transactions
429 restore: t1 .ibd and .cfg files
430 SET SESSION debug_dbug=@saved_debug_dbug;
431 SET SESSION debug_dbug="+d,ib_import_open_tablespace_failure";
432 ALTER TABLE t1 IMPORT TABLESPACE;
433 ERROR HY000: Got error 41 'Tablespace not found' from ./test/t1.ibd
434 SET SESSION debug_dbug=@saved_debug_dbug;
435 restore: t1 .ibd and .cfg files
436 SET SESSION debug_dbug="+d,ib_import_cluster_root_adjust_failure";
437 ALTER TABLE t1 IMPORT TABLESPACE;
438 ERROR HY000: Index for table 't1' is corrupt; try to repair it
439 SET SESSION debug_dbug=@saved_debug_dbug;
440 restore: t1 .ibd and .cfg files
441 SET SESSION debug_dbug="+d,ib_import_cluster_failure";
442 ALTER TABLE t1 IMPORT TABLESPACE;
443 ERROR HY000: Index for table 't1' is corrupt; try to repair it
444 SET SESSION debug_dbug=@saved_debug_dbug;
445 restore: t1 .ibd and .cfg files
446 SET SESSION debug_dbug="+d,ib_import_sec_root_adjust_failure";
447 ALTER TABLE t1 IMPORT TABLESPACE;
448 ERROR HY000: Index for table 't1' is corrupt; try to repair it
449 SET SESSION debug_dbug=@saved_debug_dbug;
450 restore: t1 .ibd and .cfg files
451 ALTER TABLE t1 IMPORT TABLESPACE;
452 DROP TABLE t1;
453 CREATE TABLE t1 (
454 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
455 c2 BIGINT,
456 c3 VARCHAR(2048),
457 c4 VARCHAR(2048),
458 INDEX idx1(c2),
459 INDEX idx2(c3(512)),
460 INDEX idx3(c4(512))) Engine=InnoDB;
461 connect purge_control,localhost,root;
462 START TRANSACTION WITH CONSISTENT SNAPSHOT;
463 connection default;
464 INSERT INTO t1
465 SELECT 1 + seq, 1 + (seq MOD 4),
466 REPEAT(SUBSTR('abcd', 1 + (seq MOD 4), 1), 2048),
467 REPEAT(SUBSTR('abcd', 1 + (seq MOD 4), 1), 2048)
468 FROM seq_0_to_127;
469 UPDATE t1 SET c2 = c2 + c1;
470 UPDATE t1 SET c2 = c2 + c1;
471 UPDATE t1 SET c2 = c2 + c1;
472 UPDATE t1 SET c2 = c2 + c1;
473 UPDATE t1 SET c2 = c2 + c1;
474 UPDATE t1 SET c2 = c2 + c1;
475 UPDATE t1 SET c2 = c2 + c1;
476 UPDATE t1 SET c2 = c2 + c1;
477 UPDATE t1 SET c2 = c2 + c1;
478 UPDATE t1 SET c2 = c2 + c1;
479 UPDATE t1 SET c2 = c2 + c1;
480 UPDATE t1 SET c2 = c2 + c1;
481 UPDATE t1 SET c2 = c2 + c1;
482 UPDATE t1 SET c2 = c2 + c1;
483 UPDATE t1 SET c2 = c2 + c1;
484 UPDATE t1 SET c3 = REPEAT("c2", 1024);
485 UPDATE t1 SET c4 = REPEAT("c4", 1024);
486 SHOW CREATE TABLE t1;
487 Table Create Table
488 t1 CREATE TABLE `t1` (
489 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
490 `c2` bigint(20) DEFAULT NULL,
491 `c3` varchar(2048) DEFAULT NULL,
492 `c4` varchar(2048) DEFAULT NULL,
493 PRIMARY KEY (`c1`),
494 KEY `idx1` (`c2`),
495 KEY `idx2` (`c3`(512)),
496 KEY `idx3` (`c4`(512))
497 ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
498 SELECT c1, c2 FROM t1;
499 c1 c2
500 1 16
501 2 32
502 3 48
503 4 64
504 5 76
505 6 92
506 7 108
507 8 124
508 9 136
509 10 152
510 11 168
511 12 184
512 13 196
513 14 212
514 15 228
515 16 244
516 17 256
517 18 272
518 19 288
519 20 304
520 21 316
521 22 332
522 23 348
523 24 364
524 25 376
525 26 392
526 27 408
527 28 424
528 29 436
529 30 452
530 31 468
531 32 484
532 33 496
533 34 512
534 35 528
535 36 544
536 37 556
537 38 572
538 39 588
539 40 604
540 41 616
541 42 632
542 43 648
543 44 664
544 45 676
545 46 692
546 47 708
547 48 724
548 49 736
549 50 752
550 51 768
551 52 784
552 53 796
553 54 812
554 55 828
555 56 844
556 57 856
557 58 872
558 59 888
559 60 904
560 61 916
561 62 932
562 63 948
563 64 964
564 65 976
565 66 992
566 67 1008
567 68 1024
568 69 1036
569 70 1052
570 71 1068
571 72 1084
572 73 1096
573 74 1112
574 75 1128
575 76 1144
576 77 1156
577 78 1172
578 79 1188
579 80 1204
580 81 1216
581 82 1232
582 83 1248
583 84 1264
584 85 1276
585 86 1292
586 87 1308
587 88 1324
588 89 1336
589 90 1352
590 91 1368
591 92 1384
592 93 1396
593 94 1412
594 95 1428
595 96 1444
596 97 1456
597 98 1472
598 99 1488
599 100 1504
600 101 1516
601 102 1532
602 103 1548
603 104 1564
604 105 1576
605 106 1592
606 107 1608
607 108 1624
608 109 1636
609 110 1652
610 111 1668
611 112 1684
612 113 1696
613 114 1712
614 115 1728
615 116 1744
616 117 1756
617 118 1772
618 119 1788
619 120 1804
620 121 1816
621 122 1832
622 123 1848
623 124 1864
624 125 1876
625 126 1892
626 127 1908
627 128 1924
628 SELECT COUNT(*) FROM t1;
629 COUNT(*)
630 128
631 SELECT SUM(c2) FROM t1;
632 SUM(c2)
633 124160
634 FLUSH TABLES t1 FOR EXPORT;
635 backup: t1
636 UNLOCK TABLES;
637 connection purge_control;
638 COMMIT;
639 disconnect purge_control;
640 connection default;
641 DROP TABLE t1;
642 CREATE TABLE t1 (
643 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
644 c2 BIGINT,
645 c3 VARCHAR(2048),
646 c4 VARCHAR(2048),
647 INDEX idx1(c2),
648 INDEX idx2(c3(512)),
649 INDEX idx3(c4(512))) Engine=InnoDB;
650 SELECT c1, c2 FROM t1;
651 c1 c2
652 ALTER TABLE t1 DISCARD TABLESPACE;
653 restore: t1 .ibd and .cfg files
654 ALTER TABLE t1 IMPORT TABLESPACE;
655 CHECK TABLE t1;
656 Table Op Msg_type Msg_text
657 test.t1 check status OK
658 SELECT c1,c2 FROM t1;
659 c1 c2
660 1 16
661 2 32
662 3 48
663 4 64
664 5 76
665 6 92
666 7 108
667 8 124
668 9 136
669 10 152
670 11 168
671 12 184
672 13 196
673 14 212
674 15 228
675 16 244
676 17 256
677 18 272
678 19 288
679 20 304
680 21 316
681 22 332
682 23 348
683 24 364
684 25 376
685 26 392
686 27 408
687 28 424
688 29 436
689 30 452
690 31 468
691 32 484
692 33 496
693 34 512
694 35 528
695 36 544
696 37 556
697 38 572
698 39 588
699 40 604
700 41 616
701 42 632
702 43 648
703 44 664
704 45 676
705 46 692
706 47 708
707 48 724
708 49 736
709 50 752
710 51 768
711 52 784
712 53 796
713 54 812
714 55 828
715 56 844
716 57 856
717 58 872
718 59 888
719 60 904
720 61 916
721 62 932
722 63 948
723 64 964
724 65 976
725 66 992
726 67 1008
727 68 1024
728 69 1036
729 70 1052
730 71 1068
731 72 1084
732 73 1096
733 74 1112
734 75 1128
735 76 1144
736 77 1156
737 78 1172
738 79 1188
739 80 1204
740 81 1216
741 82 1232
742 83 1248
743 84 1264
744 85 1276
745 86 1292
746 87 1308
747 88 1324
748 89 1336
749 90 1352
750 91 1368
751 92 1384
752 93 1396
753 94 1412
754 95 1428
755 96 1444
756 97 1456
757 98 1472
758 99 1488
759 100 1504
760 101 1516
761 102 1532
762 103 1548
763 104 1564
764 105 1576
765 106 1592
766 107 1608
767 108 1624
768 109 1636
769 110 1652
770 111 1668
771 112 1684
772 113 1696
773 114 1712
774 115 1728
775 116 1744
776 117 1756
777 118 1772
778 119 1788
779 120 1804
780 121 1816
781 122 1832
782 123 1848
783 124 1864
784 125 1876
785 126 1892
786 127 1908
787 128 1924
788 SELECT COUNT(*) FROM t1;
789 COUNT(*)
790 128
791 SELECT SUM(c2) FROM t1;
792 SUM(c2)
793 124160
794 SHOW CREATE TABLE t1;
795 Table Create Table
796 t1 CREATE TABLE `t1` (
797 `c1` bigint(20) NOT NULL AUTO_INCREMENT,
798 `c2` bigint(20) DEFAULT NULL,
799 `c3` varchar(2048) DEFAULT NULL,
800 `c4` varchar(2048) DEFAULT NULL,
801 PRIMARY KEY (`c1`),
802 KEY `idx1` (`c2`),
803 KEY `idx2` (`c3`(512)),
804 KEY `idx3` (`c4`(512))
805 ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
806 DROP TABLE t1;
807 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
808 INSERT IGNORE INTO t1 VALUES
809 (100, REPEAT('Karanbir', 899), REPEAT('Ajeeth', 2731));
810 Warnings:
811 Warning 1265 Data truncated for column 'c2' at row 1
812 INSERT INTO t1
813 SELECT 100, REPEAT('Karanbir', 128), REPEAT('Ajeeth', 1200)
814 FROM seq_1_to_256;
815 FLUSH TABLES t1 FOR EXPORT;
816 backup: t1
817 UNLOCK TABLES;
818 DROP TABLE t1;
819 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
820 ALTER TABLE t1 DISCARD TABLESPACE;
821 SELECT COUNT(*) FROM t1;
822 ERROR HY000: Tablespace has been discarded for table `t1`
823 restore: t1 .ibd and .cfg files
824 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_1";
825 ALTER TABLE t1 IMPORT TABLESPACE;
826 ERROR HY000: Internal error: Error importing tablespace for table `test`.`t1` : Data structure corruption
827 SET SESSION debug_dbug=@saved_debug_dbug;
828 DROP TABLE t1;
829 unlink: t1.ibd
830 unlink: t1.cfg
831 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
832 ALTER TABLE t1 DISCARD TABLESPACE;
833 SELECT COUNT(*) FROM t1;
834 ERROR HY000: Tablespace has been discarded for table `t1`
835 restore: t1 .ibd and .cfg files
836 ALTER TABLE t1 IMPORT TABLESPACE;
837 ERROR HY000: Index for table 't1' is corrupt; try to repair it
838 DROP TABLE t1;
839 unlink: t1.ibd
840 unlink: t1.cfg
841 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
842 ALTER TABLE t1 DISCARD TABLESPACE;
843 SELECT COUNT(*) FROM t1;
844 ERROR HY000: Tablespace has been discarded for table `t1`
845 restore: t1 .ibd and .cfg files
846 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_2";
847 ALTER TABLE t1 IMPORT TABLESPACE;
848 ERROR HY000: Index corrupt: Externally stored column(5) has a reference length of 19 in the cluster index GEN_CLUST_INDEX
849 SET SESSION debug_dbug=@saved_debug_dbug;
850 DROP TABLE t1;
851 unlink: t1.ibd
852 unlink: t1.cfg
853 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
854 ALTER TABLE t1 DISCARD TABLESPACE;
855 SELECT COUNT(*) FROM t1;
856 ERROR HY000: Tablespace has been discarded for table `t1`
857 restore: t1 .ibd and .cfg files
858 SET SESSION debug_dbug="+d,ib_import_trigger_corruption_3";
859 ALTER TABLE t1 IMPORT TABLESPACE;
860 ERROR HY000: Index for table 't1' is corrupt; try to repair it
861 SET SESSION debug_dbug=@saved_debug_dbug;
862 DROP TABLE t1;
863 unlink: t1.ibd
864 unlink: t1.cfg
865 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
866 SET SESSION debug_dbug="+d,ib_import_create_index_failure_1";
867 ALTER TABLE t1 ADD INDEX idx(c1);
868 ERROR HY000: The table 't1' is full
869 SET SESSION debug_dbug=@saved_debug_dbug;
870 ALTER TABLE t1 DISCARD TABLESPACE;
871 SELECT COUNT(*) FROM t1;
872 ERROR HY000: Tablespace has been discarded for table `t1`
873 ALTER TABLE t1 ADD INDEX idx(c1);
874 Warnings:
875 Warning 1814 Tablespace has been discarded for table `t1`
876 DROP TABLE t1;
877 unlink: t1.ibd
878 unlink: t1.cfg
879 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
880 ALTER TABLE t1 DISCARD TABLESPACE;
881 SELECT COUNT(*) FROM t1;
882 ERROR HY000: Tablespace has been discarded for table `t1`
883 restore: t1 .ibd and .cfg files
884 SET SESSION debug_dbug="+d,fil_space_create_failure";
885 ALTER TABLE t1 IMPORT TABLESPACE;
886 ERROR HY000: Got error 11 'Generic error' from ./test/t1.ibd
887 SET SESSION debug_dbug=@saved_debug_dbug;
888 DROP TABLE t1;
889 unlink: t1.ibd
890 unlink: t1.cfg
891 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
892 ALTER TABLE t1 DISCARD TABLESPACE;
893 SELECT COUNT(*) FROM t1;
894 ERROR HY000: Tablespace has been discarded for table `t1`
895 restore: t1 .ibd and .cfg files
896 SET SESSION debug_dbug="+d,dict_tf_to_fsp_flags_failure";
897 ALTER TABLE t1 IMPORT TABLESPACE;
898 ERROR HY000: Got error 37 'Data structure corruption' from ./test/t1.ibd
899 SET SESSION debug_dbug=@saved_debug_dbug;
900 DROP TABLE t1;
901 unlink: t1.ibd
902 unlink: t1.cfg
903 CREATE TABLE t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
904 ALTER TABLE t1 DISCARD TABLESPACE;
905 SELECT COUNT(*) FROM t1;
906 ERROR HY000: Tablespace has been discarded for table `t1`
907 restore: t1 .ibd and .cfg files
908 SET SESSION debug_dbug="+d,fsp_flags_is_valid_failure";
909 ALTER TABLE t1 IMPORT TABLESPACE;
910 ERROR HY000: Index for table 't1' is corrupt; try to repair it
911 SET SESSION debug_dbug=@saved_debug_dbug;
912 DROP TABLE t1;
913 unlink: t1.ibd
914 unlink: t1.cfg