Debian Codegraph @

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

raw
1 SET GLOBAL innodb_file_per_table = 1;
2 SELECT @@innodb_file_per_table;
3 @@innodb_file_per_table
4 1
5 DROP DATABASE IF EXISTS test_wl5522;
6 Warnings:
7 Note 1008 Can't drop database 'test_wl5522'; database doesn't exist
8 CREATE DATABASE test_wl5522;
9 SET SESSION debug="+d,ib_discard_before_commit_crash";
10 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = InnoDB;
11 INSERT INTO test_wl5522.t1 VALUES(1),(2),(3);
12 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
13 ERROR HY000: Lost connection to MySQL server during query
14 SET SESSION debug="-d,ib_discard_before_commit_crash";
15 DROP TABLE test_wl5522.t1;
16 SET GLOBAL innodb_file_per_table = 1;
17 SELECT @@innodb_file_per_table;
18 @@innodb_file_per_table
19 1
20 SET SESSION debug="+d,ib_discard_after_commit_crash";
21 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = InnoDB;
22 INSERT INTO test_wl5522.t1 VALUES(1),(2),(3);
23 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
24 ERROR HY000: Lost connection to MySQL server during query
25 SET SESSION debug="-d,ib_discard_after_commit_crash";
26 DROP TABLE test_wl5522.t1;
27 SET GLOBAL innodb_file_per_table = 1;
28 SELECT @@innodb_file_per_table;
29 @@innodb_file_per_table
30 1
31 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
32 INSERT INTO test_wl5522.t1 VALUES (1), (2), (3), (4);
33 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
34 backup: t1
35 UNLOCK TABLES;
36 DROP TABLE test_wl5522.t1;
37 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
38 INSERT INTO test_wl5522.t1 VALUES (1);
39 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
40 SELECT COUNT(*) FROM test_wl5522.t1;
41 ERROR HY000: Tablespace has been discarded for table 't1'
42 restore: t1 .ibd and .cfg files
43 SET SESSION debug="+d,ib_import_before_commit_crash";
44 SELECT * FROM test_wl5522.t1;
45 ERROR HY000: Tablespace has been discarded for table 't1'
46 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
47 ERROR HY000: Lost connection to MySQL server during query
48 unlink: t1.ibd
49 unlink: t1.cfg
50 SET SESSION debug="-d,ib_import_before_commit_crash";
51 SET SESSION debug="+d,ib_import_before_checkpoint_crash";
52 SELECT COUNT(*) FROM test_wl5522.t1;
53 ERROR HY000: Tablespace has been discarded for table 't1'
54 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
55 ERROR HY000: Lost connection to MySQL server during query
56 unlink: t1.ibd
57 unlink: t1.cfg
58 # Restart and reconnect to the server
59 SET SESSION debug="-d,ib_import_before_checkpoint_crash";
60 DROP TABLE test_wl5522.t1;
61 SET GLOBAL innodb_file_per_table = 1;
62 SELECT @@innodb_file_per_table;
63 @@innodb_file_per_table
64 1
65 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
66 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
67 restore: t1 .ibd and .cfg files
68 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
69 CHECK TABLE test_wl5522.t1;
70 Table Op Msg_type Msg_text
71 test_wl5522.t1 check status OK
72 SELECT COUNT(*) FROM test_wl5522.t1;
73 COUNT(*)
74 4
75 INSERT INTO test_wl5522.t1 VALUES(400), (500), (600);
76 SELECT * FROM test_wl5522.t1;
77 c1
78 1
79 2
80 3
81 4
82 400
83 500
84 600
85 DROP TABLE test_wl5522.t1;
86 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
87 INSERT INTO test_wl5522.t1 VALUES (1);
88 SET SESSION debug="+d,ib_export_io_write_failure_1";
89 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
90 Warnings:
91 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
92 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
93 UNLOCK TABLES;
94 SET SESSION debug="-d,ib_export_io_write_failure_1";
95 DROP TABLE test_wl5522.t1;
96 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
97 INSERT INTO test_wl5522.t1 VALUES (1);
98 SET SESSION debug="+d,ib_export_io_write_failure_2";
99 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
100 Warnings:
101 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
102 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
103 UNLOCK TABLES;
104 SET SESSION debug="-d,ib_export_io_write_failure_2";
105 DROP TABLE test_wl5522.t1;
106 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
107 INSERT INTO test_wl5522.t1 VALUES (1);
108 SET SESSION debug="+d,ib_export_io_write_failure_3";
109 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
110 Warnings:
111 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
112 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
113 UNLOCK TABLES;
114 SET SESSION debug="-d,ib_export_io_write_failure_3";
115 DROP TABLE test_wl5522.t1;
116 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
117 INSERT INTO test_wl5522.t1 VALUES (1);
118 SET SESSION debug="+d,ib_export_io_write_failure_4";
119 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
120 Warnings:
121 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
122 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
123 UNLOCK TABLES;
124 SET SESSION debug="-d,ib_export_io_write_failure_4";
125 DROP TABLE test_wl5522.t1;
126 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
127 INSERT INTO test_wl5522.t1 VALUES (1);
128 SET SESSION debug="+d,ib_export_io_write_failure_5";
129 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
130 Warnings:
131 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
132 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
133 UNLOCK TABLES;
134 SET SESSION debug="-d,ib_export_io_write_failure_5";
135 DROP TABLE test_wl5522.t1;
136 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
137 INSERT INTO test_wl5522.t1 VALUES (1);
138 SET SESSION debug="+d,ib_export_io_write_failure_6";
139 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
140 Warnings:
141 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
142 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
143 UNLOCK TABLES;
144 SET SESSION debug="-d,ib_export_io_write_failure_6";
145 DROP TABLE test_wl5522.t1;
146 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
147 INSERT INTO test_wl5522.t1 VALUES (1);
148 SET SESSION debug="+d,ib_export_io_write_failure_7";
149 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
150 Warnings:
151 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
152 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
153 UNLOCK TABLES;
154 SET SESSION debug="-d,ib_export_io_write_failure_7";
155 DROP TABLE test_wl5522.t1;
156 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
157 INSERT INTO test_wl5522.t1 VALUES (1);
158 SET SESSION debug="+d,ib_export_io_write_failure_8";
159 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
160 Warnings:
161 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
162 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
163 UNLOCK TABLES;
164 SET SESSION debug="-d,ib_export_io_write_failure_8";
165 DROP TABLE test_wl5522.t1;
166 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
167 INSERT INTO test_wl5522.t1 VALUES (1);
168 SET SESSION debug="+d,ib_export_io_write_failure_9";
169 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
170 Warnings:
171 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
172 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
173 UNLOCK TABLES;
174 SET SESSION debug="-d,ib_export_io_write_failure_9";
175 DROP TABLE test_wl5522.t1;
176 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
177 INSERT INTO test_wl5522.t1 VALUES (1);
178 SET SESSION debug="+d,ib_export_io_write_failure_10";
179 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
180 Warnings:
181 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
182 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
183 UNLOCK TABLES;
184 SET SESSION debug="-d,ib_export_io_write_failure_10";
185 DROP TABLE test_wl5522.t1;
186 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
187 INSERT INTO test_wl5522.t1 VALUES (1);
188 SET SESSION debug="+d,ib_export_io_write_failure_11";
189 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
190 Warnings:
191 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
192 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
193 UNLOCK TABLES;
194 SET SESSION debug="-d,ib_export_io_write_failure_11";
195 DROP TABLE test_wl5522.t1;
196 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
197 INSERT INTO test_wl5522.t1 VALUES (1);
198 SET SESSION debug="+d,ib_export_io_write_failure_12";
199 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
200 Warnings:
201 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flush() failed
202 Warning 1811 InnoDB: IO Write error: (9, Bad file descriptor) t1.cfg flose() failed
203 UNLOCK TABLES;
204 SET SESSION debug="-d,ib_export_io_write_failure_12";
205 DROP TABLE test_wl5522.t1;
206 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
207 INSERT INTO test_wl5522.t1 VALUES (100), (200), (300);
208 SELECT COUNT(*) FROM test_wl5522.t1;
209 COUNT(*)
210 3
211 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
212 backup: t1
213 UNLOCK TABLES;
214 DROP TABLE test_wl5522.t1;
215 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
216 INSERT INTO test_wl5522.t1 VALUES (1);
217 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
218 SELECT COUNT(*) FROM test_wl5522.t1;
219 ERROR HY000: Tablespace has been discarded for table 't1'
220 SET SESSION debug="+d,ib_import_io_read_error_1";
221 restore: t1 .cfg file
222 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
223 ERROR HY000: IO Read error: while reading index fields.
224 SET SESSION debug="-d,ib_import_io_read_error_1";
225 DROP TABLE test_wl5522.t1;
226 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
227 INSERT INTO test_wl5522.t1 VALUES (1);
228 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
229 SELECT COUNT(*) FROM test_wl5522.t1;
230 ERROR HY000: Tablespace has been discarded for table 't1'
231 SET SESSION debug="+d,ib_import_io_read_error_2";
232 restore: t1 .cfg file
233 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
234 ERROR HY000: IO Read error: while reading index meta-data, expected to read 44 bytes but read only 0 bytes
235 SET SESSION debug="-d,ib_import_io_read_error_2";
236 DROP TABLE test_wl5522.t1;
237 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
238 INSERT INTO test_wl5522.t1 VALUES (1);
239 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
240 SELECT COUNT(*) FROM test_wl5522.t1;
241 ERROR HY000: Tablespace has been discarded for table 't1'
242 SET SESSION debug="+d,ib_import_io_read_error_3";
243 restore: t1 .cfg file
244 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
245 ERROR HY000: IO Read error: while reading number of indexes.
246 SET SESSION debug="-d,ib_import_io_read_error_3";
247 DROP TABLE test_wl5522.t1;
248 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
249 INSERT INTO test_wl5522.t1 VALUES (1);
250 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
251 SELECT COUNT(*) FROM test_wl5522.t1;
252 ERROR HY000: Tablespace has been discarded for table 't1'
253 SET SESSION debug="+d,ib_import_io_read_error_4";
254 restore: t1 .cfg file
255 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
256 ERROR HY000: IO Read error: while reading table column meta-data.
257 SET SESSION debug="-d,ib_import_io_read_error_4";
258 DROP TABLE test_wl5522.t1;
259 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
260 INSERT INTO test_wl5522.t1 VALUES (1);
261 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
262 SELECT COUNT(*) FROM test_wl5522.t1;
263 ERROR HY000: Tablespace has been discarded for table 't1'
264 SET SESSION debug="+d,ib_import_io_read_error_5";
265 restore: t1 .cfg file
266 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
267 ERROR HY000: IO Read error: while reading meta-data export hostname length.
268 SET SESSION debug="-d,ib_import_io_read_error_5";
269 DROP TABLE test_wl5522.t1;
270 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
271 INSERT INTO test_wl5522.t1 VALUES (1);
272 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
273 SELECT COUNT(*) FROM test_wl5522.t1;
274 ERROR HY000: Tablespace has been discarded for table 't1'
275 SET SESSION debug="+d,ib_import_io_read_error_6";
276 restore: t1 .cfg file
277 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
278 ERROR HY000: IO Read error: while reading meta-data table name length.
279 SET SESSION debug="-d,ib_import_io_read_error_6";
280 DROP TABLE test_wl5522.t1;
281 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
282 INSERT INTO test_wl5522.t1 VALUES (1);
283 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
284 SELECT COUNT(*) FROM test_wl5522.t1;
285 ERROR HY000: Tablespace has been discarded for table 't1'
286 SET SESSION debug="+d,ib_import_io_read_error_7";
287 restore: t1 .cfg file
288 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
289 ERROR HY000: IO Read error: while reading autoinc value.
290 SET SESSION debug="-d,ib_import_io_read_error_7";
291 DROP TABLE test_wl5522.t1;
292 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
293 INSERT INTO test_wl5522.t1 VALUES (1);
294 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
295 SELECT COUNT(*) FROM test_wl5522.t1;
296 ERROR HY000: Tablespace has been discarded for table 't1'
297 SET SESSION debug="+d,ib_import_io_read_error_8";
298 restore: t1 .cfg file
299 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
300 ERROR HY000: IO Read error: while reading meta-data header.
301 SET SESSION debug="-d,ib_import_io_read_error_8";
302 DROP TABLE test_wl5522.t1;
303 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
304 INSERT INTO test_wl5522.t1 VALUES (1);
305 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
306 SELECT COUNT(*) FROM test_wl5522.t1;
307 ERROR HY000: Tablespace has been discarded for table 't1'
308 SET SESSION debug="+d,ib_import_io_read_error_9";
309 restore: t1 .cfg file
310 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
311 ERROR HY000: IO Read error: while reading meta-data version.
312 SET SESSION debug="-d,ib_import_io_read_error_9";
313 DROP TABLE test_wl5522.t1;
314 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
315 INSERT INTO test_wl5522.t1 VALUES (1);
316 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
317 SELECT COUNT(*) FROM test_wl5522.t1;
318 ERROR HY000: Tablespace has been discarded for table 't1'
319 SET SESSION debug="+d,ib_import_string_read_error";
320 restore: t1 .cfg file
321 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
322 ERROR HY000: IO Read error: while parsing export hostname.
323 SET SESSION debug="-d,ib_import_string_read_error";
324 DROP TABLE test_wl5522.t1;
325 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
326 INSERT INTO test_wl5522.t1 VALUES (1);
327 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
328 SELECT COUNT(*) FROM test_wl5522.t1;
329 ERROR HY000: Tablespace has been discarded for table 't1'
330 restore: t1 .ibd and .cfg files
331 SET SESSION debug="+d,ib_import_OOM_1";
332 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
333 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
334 SET SESSION debug="-d,ib_import_OOM_1";
335 SET SESSION debug="+d,ib_import_OOM_2";
336 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
337 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
338 SET SESSION debug="-d,ib_import_OOM_2";
339 SET SESSION debug="+d,ib_import_OOM_4";
340 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
341 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
342 SET SESSION debug="-d,ib_import_OOM_4";
343 SET SESSION debug="+d,ib_import_OOM_5";
344 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
345 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
346 SET SESSION debug="-d,ib_import_OOM_5";
347 SET SESSION debug="+d,ib_import_OOM_6";
348 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
349 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
350 SET SESSION debug="-d,ib_import_OOM_6";
351 SET SESSION debug="+d,ib_import_OOM_7";
352 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
353 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
354 SET SESSION debug="-d,ib_import_OOM_7";
355 SET SESSION debug="+d,ib_import_OOM_8";
356 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
357 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
358 SET SESSION debug="-d,ib_import_OOM_8";
359 SET SESSION debug="+d,ib_import_OOM_9";
360 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
361 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
362 SET SESSION debug="-d,ib_import_OOM_9";
363 SET SESSION debug="+d,ib_import_OOM_10";
364 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
365 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
366 SET SESSION debug="-d,ib_import_OOM_10";
367 SET SESSION debug="+d,ib_import_OOM_15";
368 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
369 ERROR HY000: Out of memory; check if mysqld or some other process uses all available memory; if not, you may have to use 'ulimit' to allow mysqld to use more memory or you can add more swap space
370 SET SESSION debug="-d,ib_import_OOM_15";
371 DROP TABLE test_wl5522.t1;
372 unlink: t1.ibd
373 unlink: t1.cfg
374 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
375 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
376 SELECT COUNT(*) FROM test_wl5522.t1;
377 ERROR HY000: Tablespace has been discarded for table 't1'
378 restore: t1 .ibd and .cfg files
379 SET SESSION debug="+d,ib_import_internal_error";
380 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
381 ERROR HY000: Internal error: While importing table test_wl5522/t1
382 SET SESSION debug="-d,ib_import_internal_error";
383 restore: t1 .ibd and .cfg files
384 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
385 DROP TABLE test_wl5522.t1;
386 CREATE TABLE test_wl5522.t1 (c1 INT) ENGINE = Innodb;
387 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
388 SELECT COUNT(*) FROM test_wl5522.t1;
389 ERROR HY000: Tablespace has been discarded for table 't1'
390 restore: t1 .ibd and .cfg files
391 SET SESSION debug="+d,ib_import_reset_space_and_lsn_failure";
392 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
393 ERROR HY000: Internal error: Cannot reset LSNs in table `test_wl5522`.`t1` : Too many concurrent transactions
394 restore: t1 .ibd and .cfg files
395 SET SESSION debug="-d,ib_import_reset_space_and_lsn_failure";
396 SET SESSION debug="+d,ib_import_open_tablespace_failure";
397 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
398 ERROR HY000: Can't find 't1.ibd' (errno: 44 - Tablespace not found)
399 SET SESSION debug="-d,ib_import_open_tablespace_failure";
400 restore: t1 .ibd and .cfg files
401 SET SESSION debug="+d,ib_import_check_bitmap_failure";
402 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
403 ERROR HY000: Incorrect key file for table 't1'; try to repair it
404 SET SESSION debug="-d,ib_import_check_bitmap_failure";
405 restore: t1 .ibd and .cfg files
406 SET SESSION debug="+d,ib_import_cluster_root_adjust_failure";
407 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
408 ERROR HY000: Incorrect key file for table 't1'; try to repair it
409 SET SESSION debug="-d,ib_import_cluster_root_adjust_failure";
410 restore: t1 .ibd and .cfg files
411 SET SESSION debug="+d,ib_import_cluster_failure";
412 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
413 ERROR HY000: Incorrect key file for table 't1'; try to repair it
414 SET SESSION debug="-d,ib_import_cluster_failure";
415 restore: t1 .ibd and .cfg files
416 SET SESSION debug="+d,ib_import_sec_root_adjust_failure";
417 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
418 ERROR HY000: Incorrect key file for table 't1'; try to repair it
419 SET SESSION debug="-d,ib_import_sec_root_adjust_failure";
420 restore: t1 .ibd and .cfg files
421 SET SESSION debug="+d,ib_import_set_max_rowid_failure";
422 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
423 ERROR HY000: Incorrect key file for table 't1'; try to repair it
424 SET SESSION debug="-d,ib_import_set_max_rowid_failure";
425 unlink: t1.ibd
426 unlink: t1.cfg
427 DROP TABLE test_wl5522.t1;
428 CREATE TABLE test_wl5522.t1 (
429 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
430 c2 BIGINT,
431 c3 VARCHAR(2048),
432 c4 VARCHAR(2048),
433 INDEX idx1(c2),
434 INDEX idx2(c3(512)),
435 INDEX idx3(c4(512))) Engine=InnoDB Charset=latin1;
436 SET GLOBAL INNODB_PURGE_STOP_NOW=ON;
437 SET GLOBAL innodb_disable_background_merge=ON;
438 SET GLOBAL innodb_monitor_reset = ibuf_merges;
439 SET GLOBAL innodb_monitor_reset = ibuf_merges_insert;
440 INSERT INTO test_wl5522.t1(c2, c3, c4) VALUES
441 (1, REPEAT('a', 2048), REPEAT('a', 2048)),
442 (2, REPEAT('b', 2048), REPEAT('b', 2048)),
443 (3, REPEAT('c', 2048), REPEAT('c', 2048)),
444 (4, REPEAT('d', 2048), REPEAT('d', 2048));
445 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
446 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
447 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
448 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
449 INSERT INTO test_wl5522.t1(c2, c3, c4) SELECT c2, c3, c4 FROM test_wl5522.t1;
450 DELETE FROM test_wl5522.t1 WHERE c2 = 1;
451 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
452 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
453 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
454 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
455 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
456 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
457 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
458 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
459 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
460 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
461 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
462 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
463 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
464 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
465 UPDATE test_wl5522.t1 SET c2 = c2 + c1;
466 UPDATE test_wl5522.t1 SET c3 = REPEAT("c2", 1024);
467 UPDATE test_wl5522.t1 SET c4 = REPEAT("c4", 1024);
468 SHOW CREATE TABLE test_wl5522.t1;
469 Table Create Table
470 t1 CREATE TABLE `t1` (
471 `c1` bigint NOT NULL AUTO_INCREMENT,
472 `c2` bigint DEFAULT NULL,
473 `c3` varchar(2048) DEFAULT NULL,
474 `c4` varchar(2048) DEFAULT NULL,
475 PRIMARY KEY (`c1`),
476 KEY `idx1` (`c2`),
477 KEY `idx2` (`c3`(512)),
478 KEY `idx3` (`c4`(512))
479 ) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=latin1
480 SELECT c1, c2 FROM test_wl5522.t1;
481 c1 c2
482 2 32
483 3 48
484 4 64
485 6 92
486 7 108
487 8 124
488 13 197
489 14 213
490 15 229
491 17 257
492 18 273
493 19 289
494 28 422
495 29 438
496 30 454
497 32 482
498 33 498
499 34 514
500 36 542
501 37 558
502 38 574
503 40 602
504 41 618
505 42 634
506 59 887
507 60 903
508 61 919
509 63 947
510 64 963
511 65 979
512 67 1007
513 68 1023
514 69 1039
515 71 1067
516 72 1083
517 73 1099
518 75 1127
519 76 1143
520 77 1159
521 79 1187
522 80 1203
523 81 1219
524 83 1247
525 84 1263
526 85 1279
527 87 1307
528 88 1323
529 89 1339
530 122 1832
531 123 1848
532 124 1864
533 126 1892
534 127 1908
535 128 1924
536 130 1952
537 131 1968
538 132 1984
539 134 2012
540 135 2028
541 136 2044
542 138 2072
543 139 2088
544 140 2104
545 142 2132
546 143 2148
547 144 2164
548 146 2192
549 147 2208
550 148 2224
551 150 2252
552 151 2268
553 152 2284
554 154 2312
555 155 2328
556 156 2344
557 158 2372
558 159 2388
559 160 2404
560 162 2432
561 163 2448
562 164 2464
563 166 2492
564 167 2508
565 168 2524
566 170 2552
567 171 2568
568 172 2584
569 174 2612
570 175 2628
571 176 2644
572 178 2672
573 179 2688
574 180 2704
575 182 2732
576 183 2748
577 184 2764
578 SELECT COUNT(*) FROM test_wl5522.t1;
579 COUNT(*)
580 96
581 SELECT SUM(c2) FROM test_wl5522.t1;
582 SUM(c2)
583 145278
584 SELECT name
585 FROM information_schema.innodb_metrics
586 WHERE name = 'ibuf_merges_insert' AND count = 0;
587 name
588 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
589 backup: t1
590 UNLOCK TABLES;
591 SELECT name
592 FROM information_schema.innodb_metrics
593 WHERE name = 'ibuf_merges' AND count > 0;
594 name
595 ibuf_merges
596 SELECT name
597 FROM information_schema.innodb_metrics
598 WHERE name = 'ibuf_merges_inserts' AND count > 0;
599 name
600 SET GLOBAL innodb_disable_background_merge=OFF;
601 SET GLOBAL INNODB_PURGE_RUN_NOW=ON;
602 DROP TABLE test_wl5522.t1;
603 CREATE TABLE test_wl5522.t1 (
604 c1 BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
605 c2 BIGINT,
606 c3 VARCHAR(2048),
607 c4 VARCHAR(2048),
608 INDEX idx1(c2),
609 INDEX idx2(c3(512)),
610 INDEX idx3(c4(512))) Engine=InnoDB Charset=latin1;
611 SELECT c1, c2 FROM test_wl5522.t1;
612 c1 c2
613 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
614 restore: t1 .ibd and .cfg files
615 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
616 CHECK TABLE test_wl5522.t1;
617 Table Op Msg_type Msg_text
618 test_wl5522.t1 check status OK
619 SELECT c1,c2 FROM test_wl5522.t1;
620 c1 c2
621 2 32
622 3 48
623 4 64
624 6 92
625 7 108
626 8 124
627 13 197
628 14 213
629 15 229
630 17 257
631 18 273
632 19 289
633 28 422
634 29 438
635 30 454
636 32 482
637 33 498
638 34 514
639 36 542
640 37 558
641 38 574
642 40 602
643 41 618
644 42 634
645 59 887
646 60 903
647 61 919
648 63 947
649 64 963
650 65 979
651 67 1007
652 68 1023
653 69 1039
654 71 1067
655 72 1083
656 73 1099
657 75 1127
658 76 1143
659 77 1159
660 79 1187
661 80 1203
662 81 1219
663 83 1247
664 84 1263
665 85 1279
666 87 1307
667 88 1323
668 89 1339
669 122 1832
670 123 1848
671 124 1864
672 126 1892
673 127 1908
674 128 1924
675 130 1952
676 131 1968
677 132 1984
678 134 2012
679 135 2028
680 136 2044
681 138 2072
682 139 2088
683 140 2104
684 142 2132
685 143 2148
686 144 2164
687 146 2192
688 147 2208
689 148 2224
690 150 2252
691 151 2268
692 152 2284
693 154 2312
694 155 2328
695 156 2344
696 158 2372
697 159 2388
698 160 2404
699 162 2432
700 163 2448
701 164 2464
702 166 2492
703 167 2508
704 168 2524
705 170 2552
706 171 2568
707 172 2584
708 174 2612
709 175 2628
710 176 2644
711 178 2672
712 179 2688
713 180 2704
714 182 2732
715 183 2748
716 184 2764
717 SELECT COUNT(*) FROM test_wl5522.t1;
718 COUNT(*)
719 96
720 SELECT SUM(c2) FROM test_wl5522.t1;
721 SUM(c2)
722 145278
723 SHOW CREATE TABLE test_wl5522.t1;
724 Table Create Table
725 t1 CREATE TABLE `t1` (
726 `c1` bigint NOT NULL AUTO_INCREMENT,
727 `c2` bigint DEFAULT NULL,
728 `c3` varchar(2048) DEFAULT NULL,
729 `c4` varchar(2048) DEFAULT NULL,
730 PRIMARY KEY (`c1`),
731 KEY `idx1` (`c2`),
732 KEY `idx2` (`c3`(512)),
733 KEY `idx3` (`c4`(512))
734 ) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=latin1
735 DROP TABLE test_wl5522.t1;
736 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
737 INSERT IGNORE INTO test_wl5522.t1 VALUES
738 (100, REPEAT('Karanbir', 899), REPEAT('Ajeeth', 4800));
739 Warnings:
740 Warning 1265 Data truncated for column 'c2' at row 1
741 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
742 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
743 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
744 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
745 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
746 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
747 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
748 INSERT INTO test_wl5522.t1 SELECT * FROM test_wl5522.t1;
749 SELECT COUNT(*) FROM test_wl5522.t1;
750 COUNT(*)
751 256
752 FLUSH TABLES test_wl5522.t1 FOR EXPORT;
753 backup: t1
754 UNLOCK TABLES;
755 DROP TABLE test_wl5522.t1;
756 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
757 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
758 SELECT COUNT(*) FROM test_wl5522.t1;
759 ERROR HY000: Tablespace has been discarded for table 't1'
760 restore: t1 .ibd and .cfg files
761 SET SESSION debug="+d,ib_import_trigger_corruption_1";
762 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
763 ERROR HY000: Internal error: Cannot reset LSNs in table `test_wl5522`.`t1` : Data structure corruption
764 SET SESSION debug="-d,ib_import_trigger_corruption_1";
765 DROP TABLE test_wl5522.t1;
766 unlink: t1.ibd
767 unlink: t1.cfg
768 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
769 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
770 SELECT COUNT(*) FROM test_wl5522.t1;
771 ERROR HY000: Tablespace has been discarded for table 't1'
772 restore: t1 .ibd and .cfg files
773 SET SESSION debug="+d,buf_page_import_corrupt_failure";
774 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
775 ERROR HY000: Internal error: Cannot reset LSNs in table `test_wl5522`.`t1` : Data structure corruption
776 SET SESSION debug="-d,buf_page_import_corrupt_failure";
777 DROP TABLE test_wl5522.t1;
778 unlink: t1.ibd
779 unlink: t1.cfg
780 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
781 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
782 SELECT COUNT(*) FROM test_wl5522.t1;
783 ERROR HY000: Tablespace has been discarded for table 't1'
784 restore: t1 .ibd and .cfg files
785 SET SESSION debug="+d,ib_import_trigger_corruption_2";
786 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
787 ERROR HY000: Index corrupt: Externally stored column(5) has a reference length of 19 in the cluster index GEN_CLUST_INDEX
788 SET SESSION debug="-d,ib_import_trigger_corruption_2";
789 DROP TABLE test_wl5522.t1;
790 unlink: t1.ibd
791 unlink: t1.cfg
792 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
793 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
794 SELECT COUNT(*) FROM test_wl5522.t1;
795 ERROR HY000: Tablespace has been discarded for table 't1'
796 restore: t1 .ibd and .cfg files
797 SET SESSION debug="+d,ib_import_trigger_corruption_3";
798 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
799 ERROR HY000: Incorrect key file for table 't1'; try to repair it
800 SET SESSION debug="-d,ib_import_trigger_corruption_3";
801 DROP TABLE test_wl5522.t1;
802 unlink: t1.ibd
803 unlink: t1.cfg
804 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
805 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
806 SELECT COUNT(*) FROM test_wl5522.t1;
807 ERROR HY000: Tablespace has been discarded for table 't1'
808 SET SESSION debug="+d,ib_import_create_index_failure_1";
809 ALTER TABLE test_wl5522.t1 ADD INDEX idx(c1);
810 Warnings:
811 Warning 1814 InnoDB: Tablespace has been discarded for table 't1'
812 SET SESSION debug="-d,ib_import_create_index_failure_1";
813 DROP TABLE test_wl5522.t1;
814 unlink: t1.ibd
815 unlink: t1.cfg
816 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
817 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
818 SELECT COUNT(*) FROM test_wl5522.t1;
819 ERROR HY000: Tablespace has been discarded for table 't1'
820 restore: t1 .ibd and .cfg files
821 SET SESSION debug="+d,fil_space_create_failure";
822 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
823 ERROR HY000: Can't find file: './test_wl5522/t1.ibd' (errno: 11 - Generic error)
824 SET SESSION debug="-d,fil_space_create_failure";
825 DROP TABLE test_wl5522.t1;
826 unlink: t1.ibd
827 unlink: t1.cfg
828 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
829 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
830 SELECT COUNT(*) FROM test_wl5522.t1;
831 ERROR HY000: Tablespace has been discarded for table 't1'
832 restore: t1 .ibd and .cfg files
833 SET SESSION debug="+d,dict_tf_to_fsp_flags_failure";
834 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
835 ERROR HY000: Can't find file: './test_wl5522/t1.ibd' (errno: 39 - Data structure corruption)
836 SET SESSION debug="-d,dict_tf_to_fsp_flags_failure";
837 DROP TABLE test_wl5522.t1;
838 unlink: t1.ibd
839 unlink: t1.cfg
840 CREATE TABLE test_wl5522.t1 (c1 INT, c2 VARCHAR(1024), c3 BLOB) ENGINE = Innodb;
841 ALTER TABLE test_wl5522.t1 DISCARD TABLESPACE;
842 SELECT COUNT(*) FROM test_wl5522.t1;
843 ERROR HY000: Tablespace has been discarded for table 't1'
844 restore: t1 .ibd and .cfg files
845 SET SESSION debug="+d,fsp_flags_is_valid_failure";
846 ALTER TABLE test_wl5522.t1 IMPORT TABLESPACE;
847 ERROR HY000: Internal error: Cannot reset LSNs in table `test_wl5522`.`t1` : Unsupported
848 SET SESSION debug="-d,fsp_flags_is_valid_failure";
849 DROP TABLE test_wl5522.t1;
850 unlink: t1.ibd
851 unlink: t1.cfg
852 DROP DATABASE test_wl5522;
853 set global innodb_monitor_disable = all;
854 set global innodb_monitor_reset_all = all;
855 SET GLOBAL INNODB_FILE_PER_TABLE=1;
856 count_alloc WHERE event_name like 'memory/innodb/other'
857 count_alloc
858 0