Debian Codegraph @

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

raw
1 SET GLOBAL innodb_file_per_table = 1;
2 SELECT @@innodb_file_per_table;
3 @@innodb_file_per_table
4 1
5 SET SESSION innodb_strict_mode=1;
6 SELECT @@SESSION.innodb_strict_mode;
7 @@SESSION.innodb_strict_mode
8 1
9 DROP DATABASE IF EXISTS test_wl5522;
10 Warnings:
11 Note 1008 Can't drop database 'test_wl5522'; database doesn't exist
12 CREATE DATABASE test_wl5522;
13 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb
14 ROW_FORMAT=COMPRESSED;
15 INSERT INTO test_wl5522.t1 VALUES (1), (2), (3), (4);
16 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
17 backup: t1
18 UNLOCK TABLES;
19 DROP TABLE test_wl5522.t1;
20 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb
21 ROW_FORMAT=COMPRESSED;
22 INSERT INTO test_wl5522.t1 VALUES (1);
23 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
24 SELECT COUNT(*) FROM test_wl5522.t1;
25 ERROR HY000: Tablespace has been discarded for table 't1'
26 restore: t1 .ibd and .cfg files
27 SET SESSION debug="+d,ib_import_before_commit_crash";
28 SELECT * FROM test_wl5522.t1;
29 ERROR HY000: Tablespace has been discarded for table 't1'
30 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
31 ERROR HY000: Lost connection to MySQL server during query
32 unlink: t1.ibd
33 unlink: t1.cfg
34 SET SESSION debug="+d,ib_import_before_checkpoint_crash";
35 SELECT COUNT(*) FROM test_wl5522.t1;
36 ERROR HY000: Tablespace has been discarded for table 't1'
37 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
38 ERROR HY000: Lost connection to MySQL server during query
39 unlink: t1.ibd
40 unlink: t1.cfg
41 # Restart and reconnect to the server
42 DROP TABLE test_wl5522.t1;
43 SET GLOBAL innodb_file_per_table = 1;
44 SELECT @@innodb_file_per_table;
45 @@innodb_file_per_table
46 1
47 SET SESSION innodb_strict_mode=1;
48 SELECT @@SESSION.innodb_strict_mode;
49 @@SESSION.innodb_strict_mode
50 1
51 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb
52 ROW_FORMAT=COMPRESSED;
53 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
54 restore: t1 .ibd and .cfg files
55 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
56 CHECK TABLE test_wl5522.t1;
57 Table Op Msg_type Msg_text
58 test_wl5522.t1 check status OK
59 SELECT COUNT(*) FROM test_wl5522.t1;
60 COUNT(*)
61 4
62 INSERT INTO test_wl5522.t1 VALUES(400), (500), (600);
63 SELECT * FROM test_wl5522.t1;
64 c1
65 1
66 2
67 3
68 4
69 400
70 500
71 600
72 DROP TABLE test_wl5522.t1;
73 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb
74 ROW_FORMAT=COMPRESSED;
75 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
76 SELECT COUNT(*) FROM test_wl5522.t1;
77 ERROR HY000: Tablespace has been discarded for table 't1'
78 restore: t1 .ibd and .cfg files
79 SET SESSION debug="+d,ib_import_internal_error";
80 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
81 ERROR HY000: Internal error: While importing table test_wl5522/t1
82 SET SESSION debug="-d,ib_import_internal_error";
83 restore: t1 .ibd and .cfg files
84 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
85 DROP TABLE test_wl5522.t1;
86 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb
87 ROW_FORMAT=COMPRESSED;
88 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
89 SELECT COUNT(*) FROM test_wl5522.t1;
90 ERROR HY000: Tablespace has been discarded for table 't1'
91 restore: t1 .ibd and .cfg files
92 SET SESSION debug="+d,ib_import_reset_space_and_lsn_failure";
93 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
94 ERROR HY000: Internal error: Cannot reset LSNs in table `test_wl5522`.`t1` : Too many concurrent transactions
95 restore: t1 .ibd and .cfg files
96 SET SESSION debug="-d,ib_import_reset_space_and_lsn_failure";
97 SET SESSION debug="+d,ib_import_open_tablespace_failure";
98 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
99 ERROR HY000: Can't find 't1.ibd' (errno: 44 - Tablespace not found)
100 SET SESSION debug="-d,ib_import_open_tablespace_failure";
101 restore: t1 .ibd and .cfg files
102 SET SESSION debug="+d,ib_import_check_bitmap_failure";
103 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
104 ERROR HY000: Incorrect key file for table 't1'; try to repair it
105 SET SESSION debug="-d,ib_import_check_bitmap_failure";
106 restore: t1 .ibd and .cfg files
107 SET SESSION debug="+d,ib_import_cluster_root_adjust_failure";
108 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
109 ERROR HY000: Incorrect key file for table 't1'; try to repair it
110 SET SESSION debug="-d,ib_import_cluster_root_adjust_failure";
111 restore: t1 .ibd and .cfg files
112 SET SESSION debug="+d,ib_import_cluster_failure";
113 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
114 ERROR HY000: Incorrect key file for table 't1'; try to repair it
115 SET SESSION debug="-d,ib_import_cluster_failure";
116 restore: t1 .ibd and .cfg files
117 SET SESSION debug="+d,ib_import_sec_root_adjust_failure";
118 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
119 ERROR HY000: Incorrect key file for table 't1'; try to repair it
120 SET SESSION debug="-d,ib_import_sec_root_adjust_failure";
121 restore: t1 .ibd and .cfg files
122 SET SESSION debug="+d,ib_import_set_max_rowid_failure";
123 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
124 ERROR HY000: Incorrect key file for table 't1'; try to repair it
125 SET SESSION debug="-d,ib_import_set_max_rowid_failure";
126 unlink: t1.ibd
127 unlink: t1.cfg
128 DROP TABLE test_wl5522.t1;
129 CREATE TABLE test_wl5522.t1 (
130 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
131 c2 BIGINT,
132 c3 VARCHAR(2048),
133 c4 VARCHAR(2048),
134 INDEX idx1(c2),
135 INDEX idx2(c3(512)),
136 INDEX idx3(c4(512))) Engine=InnoDB
137 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
138 SET GLOBAL INNODB_PURGE_STOP_NOW=ON;
139 SET GLOBAL innodb_disable_background_merge=ON;
140 SET GLOBAL innodb_monitor_reset = ibuf_merges;
141 SET GLOBAL innodb_monitor_reset = ibuf_merges_insert;
142 INSERT INTO test_wl5522.t1(c2, c3, c4) VALUES
143 (1, REPEAT('a', 2048), REPEAT('a', 2048)),
144 (2, REPEAT('b', 2048), REPEAT('b', 2048)),
145 (3, REPEAT('c', 2048), REPEAT('c', 2048)),
146 (4, REPEAT('d', 2048), REPEAT('d', 2048));
147 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
148 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
149 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
150 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
151 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
152 DELETE FROM test_wl5522.t1 WHERE c2 = 1;
153 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
154 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
155 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
156 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
157 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
158 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
159 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
160 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
161 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
162 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
163 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
164 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
165 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
166 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
167 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
168 UPDATE test_wl5522.t1 SET c3 = REPEAT("c2", 1024);
169 UPDATE test_wl5522.t1 SET c4 = REPEAT("c4", 1024);
170 SHOW CREATE TABLE test_wl5522.t1;
171 Table Create Table
172 t1 CREATE TABLE `t1` (
173 `c1` bigint NOT NULL AUTO_INCREMENT,
174 `c2` bigint DEFAULT NULL,
175 `c3` varchar(2048) DEFAULT NULL,
176 `c4` varchar(2048) DEFAULT NULL,
177 PRIMARY KEY (`c1`),
178 KEY `idx1` (`c2`),
179 KEY `idx2` (`c3`(512)),
180 KEY `idx3` (`c4`(512))
181 ) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
182 SELECT c1, c2 FROM test_wl5522.t1;
183 c1 c2
184 2 32
185 3 48
186 4 64
187 6 92
188 7 108
189 8 124
190 13 197
191 14 213
192 15 229
193 17 257
194 18 273
195 19 289
196 28 422
197 29 438
198 30 454
199 32 482
200 33 498
201 34 514
202 36 542
203 37 558
204 38 574
205 40 602
206 41 618
207 42 634
208 59 887
209 60 903
210 61 919
211 63 947
212 64 963
213 65 979
214 67 1007
215 68 1023
216 69 1039
217 71 1067
218 72 1083
219 73 1099
220 75 1127
221 76 1143
222 77 1159
223 79 1187
224 80 1203
225 81 1219
226 83 1247
227 84 1263
228 85 1279
229 87 1307
230 88 1323
231 89 1339
232 122 1832
233 123 1848
234 124 1864
235 126 1892
236 127 1908
237 128 1924
238 130 1952
239 131 1968
240 132 1984
241 134 2012
242 135 2028
243 136 2044
244 138 2072
245 139 2088
246 140 2104
247 142 2132
248 143 2148
249 144 2164
250 146 2192
251 147 2208
252 148 2224
253 150 2252
254 151 2268
255 152 2284
256 154 2312
257 155 2328
258 156 2344
259 158 2372
260 159 2388
261 160 2404
262 162 2432
263 163 2448
264 164 2464
265 166 2492
266 167 2508
267 168 2524
268 170 2552
269 171 2568
270 172 2584
271 174 2612
272 175 2628
273 176 2644
274 178 2672
275 179 2688
276 180 2704
277 182 2732
278 183 2748
279 184 2764
280 SELECT COUNT(*) FROM test_wl5522.t1;
281 COUNT(*)
282 96
283 SELECT SUM(c2) FROM test_wl5522.t1;
284 SUM(c2)
285 145278
286 SELECT name
287 FROM information_schema.innodb_metrics
288 WHERE name = 'ibuf_merges_insert' AND count = 0;
289 name
290 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
291 backup: t1
292 UNLOCK TABLES;
293 SELECT name
294 FROM information_schema.innodb_metrics
295 WHERE name = 'ibuf_merges' AND count > 0;
296 name
297 ibuf_merges
298 SELECT name
299 FROM information_schema.innodb_metrics
300 WHERE name = 'ibuf_merges_inserts' AND count > 0;
301 name
302 SET GLOBAL innodb_disable_background_merge=OFF;
303 SET GLOBAL INNODB_PURGE_RUN_NOW=ON;
304 DROP TABLE test_wl5522.t1;
305 CREATE TABLE test_wl5522.t1 (
306 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
307 c2 BIGINT,
308 c3 VARCHAR(2048),
309 c4 VARCHAR(2048),
310 INDEX idx1(c2),
311 INDEX idx2(c3(512)),
312 INDEX idx3(c4(512))) Engine=InnoDB
313 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8;
314 SELECT c1, c2 FROM test_wl5522.t1;
315 c1 c2
316 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
317 restore: t1 .ibd and .cfg files
318 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
319 CHECK TABLE test_wl5522.t1;
320 Table Op Msg_type Msg_text
321 test_wl5522.t1 check status OK
322 SELECT c1,c2 FROM test_wl5522.t1;
323 c1 c2
324 2 32
325 3 48
326 4 64
327 6 92
328 7 108
329 8 124
330 13 197
331 14 213
332 15 229
333 17 257
334 18 273
335 19 289
336 28 422
337 29 438
338 30 454
339 32 482
340 33 498
341 34 514
342 36 542
343 37 558
344 38 574
345 40 602
346 41 618
347 42 634
348 59 887
349 60 903
350 61 919
351 63 947
352 64 963
353 65 979
354 67 1007
355 68 1023
356 69 1039
357 71 1067
358 72 1083
359 73 1099
360 75 1127
361 76 1143
362 77 1159
363 79 1187
364 80 1203
365 81 1219
366 83 1247
367 84 1263
368 85 1279
369 87 1307
370 88 1323
371 89 1339
372 122 1832
373 123 1848
374 124 1864
375 126 1892
376 127 1908
377 128 1924
378 130 1952
379 131 1968
380 132 1984
381 134 2012
382 135 2028
383 136 2044
384 138 2072
385 139 2088
386 140 2104
387 142 2132
388 143 2148
389 144 2164
390 146 2192
391 147 2208
392 148 2224
393 150 2252
394 151 2268
395 152 2284
396 154 2312
397 155 2328
398 156 2344
399 158 2372
400 159 2388
401 160 2404
402 162 2432
403 163 2448
404 164 2464
405 166 2492
406 167 2508
407 168 2524
408 170 2552
409 171 2568
410 172 2584
411 174 2612
412 175 2628
413 176 2644
414 178 2672
415 179 2688
416 180 2704
417 182 2732
418 183 2748
419 184 2764
420 SELECT COUNT(*) FROM test_wl5522.t1;
421 COUNT(*)
422 96
423 SELECT SUM(c2) FROM test_wl5522.t1;
424 SUM(c2)
425 145278
426 SHOW CREATE TABLE test_wl5522.t1;
427 Table Create Table
428 t1 CREATE TABLE `t1` (
429 `c1` bigint NOT NULL AUTO_INCREMENT,
430 `c2` bigint DEFAULT NULL,
431 `c3` varchar(2048) DEFAULT NULL,
432 `c4` varchar(2048) DEFAULT NULL,
433 PRIMARY KEY (`c1`),
434 KEY `idx1` (`c2`),
435 KEY `idx2` (`c3`(512)),
436 KEY `idx3` (`c4`(512))
437 ) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
438 DROP TABLE test_wl5522.t1;
439 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
440 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
441 INSERT IGNORE INTO test_wl5522.t1 VALUES
442 (100, REPEAT('Karanbir', 899), REPEAT('Ajeeth', 1200));
443 Warnings:
444 Warning 1265 Data truncated for column 'c2' at row 1
445 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
446 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
447 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
448 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
449 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
450 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
451 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
452 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
453 SELECT COUNT(*) FROM test_wl5522.t1;
454 COUNT(*)
455 256
456 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
457 backup: t1
458 UNLOCK TABLES;
459 DROP TABLE test_wl5522.t1;
460 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
461 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
462 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
463 SELECT COUNT(*) FROM test_wl5522.t1;
464 ERROR HY000: Tablespace has been discarded for table 't1'
465 restore: t1 .ibd and .cfg files
466 SET SESSION debug="+d,ib_import_trigger_corruption_1";
467 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
468 ERROR HY000: Internal error: Cannot reset LSNs in table `test_wl5522`.`t1` : Data structure corruption
469 SET SESSION debug="-d,ib_import_trigger_corruption_1";
470 DROP TABLE test_wl5522.t1;
471 unlink: t1.ibd
472 unlink: t1.cfg
473 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
474 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
475 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
476 SELECT COUNT(*) FROM test_wl5522.t1;
477 ERROR HY000: Tablespace has been discarded for table 't1'
478 restore: t1 .ibd and .cfg files
479 SET SESSION debug="+d,buf_page_import_corrupt_failure";
480 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
481 SET SESSION debug="-d,buf_page_import_corrupt_failure";
482 DROP TABLE test_wl5522.t1;
483 unlink: t1.ibd
484 unlink: t1.cfg
485 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
486 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
487 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
488 SELECT COUNT(*) FROM test_wl5522.t1;
489 ERROR HY000: Tablespace has been discarded for table 't1'
490 restore: t1 .ibd and .cfg files
491 SET SESSION debug="+d,ib_import_trigger_corruption_2";
492 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
493 ERROR HY000: Index corrupt: Externally stored column(5) has a reference length of 19 in the cluster index GEN_CLUST_INDEX
494 SET SESSION debug="-d,ib_import_trigger_corruption_2";
495 DROP TABLE test_wl5522.t1;
496 unlink: t1.ibd
497 unlink: t1.cfg
498 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
499 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
500 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
501 SELECT COUNT(*) FROM test_wl5522.t1;
502 ERROR HY000: Tablespace has been discarded for table 't1'
503 restore: t1 .ibd and .cfg files
504 SET SESSION debug="+d,ib_import_trigger_corruption_3";
505 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
506 ERROR HY000: Incorrect key file for table 't1'; try to repair it
507 SET SESSION debug="-d,ib_import_trigger_corruption_3";
508 DROP TABLE test_wl5522.t1;
509 unlink: t1.ibd
510 unlink: t1.cfg
511 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
512 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
513 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
514 SELECT COUNT(*) FROM test_wl5522.t1;
515 ERROR HY000: Tablespace has been discarded for table 't1'
516 SET SESSION debug="+d,ib_import_create_index_failure_1";
517 ALTER TABLE test_wl5522.t1 ADD INDEX idx(c1);
518 Warnings:
519 Warning 1814 InnoDB: Tablespace has been discarded for table 't1'
520 SET SESSION debug="-d,ib_import_create_index_failure_1";
521 DROP TABLE test_wl5522.t1;
522 unlink: t1.ibd
523 unlink: t1.cfg
524 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
525 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
526 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
527 SELECT COUNT(*) FROM test_wl5522.t1;
528 ERROR HY000: Tablespace has been discarded for table 't1'
529 restore: t1 .ibd and .cfg files
530 SET SESSION debug="+d,fil_space_create_failure";
531 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
532 ERROR HY000: Can't find file: './test_wl5522/t1.ibd' (errno: 11 - Generic error)
533 SET SESSION debug="-d,fil_space_create_failure";
534 DROP TABLE test_wl5522.t1;
535 unlink: t1.ibd
536 unlink: t1.cfg
537 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
538 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
539 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
540 SELECT COUNT(*) FROM test_wl5522.t1;
541 ERROR HY000: Tablespace has been discarded for table 't1'
542 restore: t1 .ibd and .cfg files
543 SET SESSION debug="+d,dict_tf_to_fsp_flags_failure";
544 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
545 ERROR HY000: Can't find file: './test_wl5522/t1.ibd' (errno: 39 - Data structure corruption)
546 SET SESSION debug="-d,dict_tf_to_fsp_flags_failure";
547 DROP TABLE test_wl5522.t1;
548 unlink: t1.ibd
549 unlink: t1.cfg
550 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb
551 ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4;
552 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
553 SELECT COUNT(*) FROM test_wl5522.t1;
554 ERROR HY000: Tablespace has been discarded for table 't1'
555 restore: t1 .ibd and .cfg files
556 SET SESSION debug="+d,fsp_flags_is_valid_failure";
557 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
558 ERROR HY000: Internal error: Cannot reset LSNs in table `test_wl5522`.`t1` : Unsupported
559 SET SESSION debug="-d,fsp_flags_is_valid_failure";
560 DROP TABLE test_wl5522.t1;
561 unlink: t1.ibd
562 unlink: t1.cfg
563 DROP DATABASE test_wl5522;
564 set global innodb_monitor_disable = all;
565 set global innodb_monitor_reset_all = all;
566 SET GLOBAL INNODB_FILE_PER_TABLE=1;