Debian Codegraph @

mysql-test/suite/clone/r/ddl_undo.result

raw
1 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
2 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
3 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
4 PARTITION BY KEY(col1) PARTITIONS 5;
5 CREATE PROCEDURE execute_dml(
6 p_dml_type INT,
7 p_key_min INT,
8 p_key_range INT,
9 p_loop_count INT,
10 p_frequency INT,
11 p_is_rand INT)
12 BEGIN
13 DECLARE v_idx INT DEFAULT 0;
14 DECLARE v_commit INT DEFAULT 0;
15 DECLARE v_key INT DEFAULT 0;
16 /* Loop and INSERT data at random position */
17 WHILE(v_idx < p_loop_count) DO
18 /* Generate key between 1 to p_loop_count */
19 IF p_is_rand = 1 THEN
20 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
21 ELSE
22 SET v_key = p_key_min + (v_idx % p_key_range);
23 END IF;
24 CASE p_dml_type
25 WHEN 0 THEN
26 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
27 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
28 v_key, v_key * 10,
29 @clol3_text, REPEAT('Large Column Data ', 2048))
30 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
31 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
32 v_key, v_key * 10,
33 @clol3_text, REPEAT('Large Column Data ', 2048))
34 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
35 WHEN 1 THEN
36 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
37 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
38 WHEN 2 THEN
39 DELETE FROM t1 WHERE col1 = v_key;
40 DELETE FROM t2 WHERE col1 = v_key;
41 ELSE
42 DELETE FROM t1;
43 DELETE FROM t2;
44 END CASE;
45 SET v_idx = v_idx + 1;
46 /* Commit or rollback work at specified frequency. */
47 IF v_idx % p_frequency = 0 THEN
48 SET v_commit = FLOOR(RAND() * 2);
49 IF v_commit = 0 AND p_is_rand = 1 THEN
50 ROLLBACK;
51 START TRANSACTION;
52 ELSE
53 COMMIT;
54 START TRANSACTION;
55 END IF;
56 END IF;
57 END WHILE;
58 COMMIT;
59 END|
60 call execute_dml(0, 0, 100, 100, 10, 0);
61 CREATE TABLE t SELECT * FROM t1;
62 CREATE TABLE t0 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
63 CREATE TABLE t01 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
64 CREATE TABLE t3 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
65 CREATE TABLE t11 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
66 CREATE TABLE t21 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
67 INSERT INTO t11 SELECT * FROM t;
68 INSERT INTO t21 SELECT * FROM t;
69 SHOW VARIABLES LIKE 'clone_ddl_timeout';
70 Variable_name Value
71 clone_ddl_timeout 300
72 SHOW VARIABLES LIKE 'clone_block_ddl';
73 Variable_name Value
74 clone_block_ddl OFF
75 # 1. CREATE UNDO TABLESPACE while clone in progress
76 RESET MASTER;
77 SET GLOBAL DEBUG = '+d,local_release_clone_file_pin';
78 CREATE UNDO TABLESPACE undo_00 ADD DATAFILE 'undo_00.ibu';
79 SET DEBUG_SYNC = 'clone_before_init_meta SIGNAL start_ddl_file_init WAIT_FOR resume_file_init';
80 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl_file WAIT_FOR resume_file';
81 SET DEBUG_SYNC = 'clone_file_copy_end_before_ack SIGNAL start_ddl_file_ack WAIT_FOR resume_file_ack';
82 SET DEBUG_SYNC = 'clone_before_file_ddl_meta SIGNAL start_ddl_file_meta WAIT_FOR resume_file_meta';
83 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_ddl_page WAIT_FOR resume_page';
84 SET DEBUG_SYNC = 'clone_before_page_ddl_meta SIGNAL start_ddl_page_meta WAIT_FOR resume_page_meta';
85 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL start_ddl_redo WAIT_FOR resume_redo';
86 SET GLOBAL clone_autotune_concurrency = OFF;
87 SET GLOBAL clone_max_concurrency = 8;
88 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
89 # In connection CON1
90 # Waiting for clone to reach 'Initial metadata transfer'
91 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_init';
92 # Wait finished
93 CREATE UNDO TABLESPACE undo_001 ADD DATAFILE 'undo_001.ibu';
94 SET DEBUG_SYNC = 'now SIGNAL resume_file_init';
95 # Waiting for clone to reach 'file copy'
96 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file';
97 # Wait finished
98 CREATE UNDO TABLESPACE undo_01 ADD DATAFILE 'undo_01.ibu';
99 CALL execute_dml(0, 0, 100, 100, 10, 0);
100 # Flush all dirty pages to track
101 SET GLOBAL innodb_buf_flush_list_now = 1;
102 SET DEBUG_SYNC = 'now SIGNAL resume_file';
103 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_ack';
104 SET DEBUG_SYNC = 'now SIGNAL resume_file_ack';
105 # Waiting for clone to reach DDL metadata for 'file copy'
106 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_meta';
107 # Wait finished
108 CREATE UNDO TABLESPACE undo_011 ADD DATAFILE 'undo_011.ibu';
109 CALL execute_dml(0, 0, 100, 100, 10, 0);
110 SET DEBUG_SYNC = 'now SIGNAL resume_file_meta';
111 # Waiting for clone to reach 'page copy'
112 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_page';
113 # Wait finished
114 CREATE UNDO TABLESPACE undo_02 ADD DATAFILE 'undo_02.ibu';
115 CALL execute_dml(0, 0, 100, 100, 10, 0);
116 SET DEBUG_SYNC = 'now SIGNAL resume_page';
117 # Waiting for clone to reach DDL metadata for 'page copy'
118 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_page_meta';
119 # Wait finished
120 CREATE UNDO TABLESPACE undo_021 ADD DATAFILE 'undo_021.ibu';
121 CALL execute_dml(0, 0, 100, 100, 10, 0);
122 SET DEBUG_SYNC = 'now SIGNAL resume_page_meta';
123 # Waiting for clone to reach 'redo copy'
124 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_redo';
125 # Wait finished
126 CREATE UNDO TABLESPACE undo_03 ADD DATAFILE 'undo_03.ibu';
127 SET DEBUG_SYNC = 'now SIGNAL resume_redo';
128 # In connection DEFAULT
129 # Waiting for clone to complete
130 # Wait finished
131 SET GLOBAL DEBUG = '-d,local_release_clone_file_pin';
132 # Restart server on cloned data directory
133 # restart: --datadir=CLONE_DATADIR
134 # Check cloned data
135 SHOW TABLES;
136 Tables_in_test
137 t
138 t0
139 t01
140 t1
141 t11
142 t2
143 t21
144 t3
145 SHOW CREATE TABLE t1;
146 Table Create Table
147 t1 CREATE TABLE `t1` (
148 `col1` int NOT NULL,
149 `col2` int DEFAULT NULL,
150 `col3` varchar(64) DEFAULT NULL,
151 `col4` blob,
152 PRIMARY KEY (`col1`)
153 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
154 CHECK TABLE t1 EXTENDED;
155 Table Op Msg_type Msg_text
156 test.t1 check status OK
157 SELECT count(*) from t1;
158 count(*)
159 100
160 SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;;
161 col1 col2 col3
162 0 3 Clone Test Row - 0
163 1 13 Clone Test Row - 1
164 2 23 Clone Test Row - 2
165 3 33 Clone Test Row - 3
166 4 43 Clone Test Row - 4
167 5 53 Clone Test Row - 5
168 6 63 Clone Test Row - 6
169 7 73 Clone Test Row - 7
170 8 83 Clone Test Row - 8
171 9 93 Clone Test Row - 9
172 SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;;
173 col1 col2 col3
174 99 993 Clone Test Row - 99
175 98 983 Clone Test Row - 98
176 97 973 Clone Test Row - 97
177 96 963 Clone Test Row - 96
178 95 953 Clone Test Row - 95
179 94 943 Clone Test Row - 94
180 93 933 Clone Test Row - 93
181 92 923 Clone Test Row - 92
182 91 913 Clone Test Row - 91
183 90 903 Clone Test Row - 90
184 SELECT NAME, SPACE_TYPE, STATE
185 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
186 WHERE SPACE_TYPE = 'Undo'
187 ORDER BY NAME;
188 NAME SPACE_TYPE STATE
189 innodb_undo_001 Undo active
190 innodb_undo_002 Undo active
191 undo_00 Undo active
192 undo_001 Undo active
193 undo_01 Undo active
194 undo_011 Undo active
195 undo_02 Undo active
196 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
197 FROM INFORMATION_SCHEMA.FILES
198 WHERE FILE_NAME LIKE '%undo_0%'
199 ORDER BY TABLESPACE_NAME;
200 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
201 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
202 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
203 undo_00 ./undo_00.ibu UNDO LOG InnoDB
204 undo_001 ./undo_001.ibu UNDO LOG InnoDB
205 undo_01 ./undo_01.ibu UNDO LOG InnoDB
206 undo_011 ./undo_011.ibu UNDO LOG InnoDB
207 undo_02 ./undo_02.ibu UNDO LOG InnoDB
208 SHOW CREATE TABLE t11;
209 Table Create Table
210 t11 CREATE TABLE `t11` (
211 `col1` int NOT NULL,
212 `col2` int DEFAULT NULL,
213 `col3` varchar(64) DEFAULT NULL,
214 `col4` blob,
215 PRIMARY KEY (`col1`)
216 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
217 CHECK TABLE t11 EXTENDED;
218 Table Op Msg_type Msg_text
219 test.t11 check status OK
220 SELECT count(*) from t11;
221 count(*)
222 100
223 SELECT col1, col2, col3 FROM t11 ORDER BY col1 LIMIT 10;;
224 col1 col2 col3
225 0 0 Clone Test Row - 0
226 1 10 Clone Test Row - 1
227 2 20 Clone Test Row - 2
228 3 30 Clone Test Row - 3
229 4 40 Clone Test Row - 4
230 5 50 Clone Test Row - 5
231 6 60 Clone Test Row - 6
232 7 70 Clone Test Row - 7
233 8 80 Clone Test Row - 8
234 9 90 Clone Test Row - 9
235 SELECT col1, col2, col3 FROM t11 ORDER BY col1 DESC LIMIT 10;;
236 col1 col2 col3
237 99 990 Clone Test Row - 99
238 98 980 Clone Test Row - 98
239 97 970 Clone Test Row - 97
240 96 960 Clone Test Row - 96
241 95 950 Clone Test Row - 95
242 94 940 Clone Test Row - 94
243 93 930 Clone Test Row - 93
244 92 920 Clone Test Row - 92
245 91 910 Clone Test Row - 91
246 90 900 Clone Test Row - 90
247 SELECT NAME, SPACE_TYPE, STATE
248 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
249 WHERE SPACE_TYPE = 'Undo'
250 ORDER BY NAME;
251 NAME SPACE_TYPE STATE
252 innodb_undo_001 Undo active
253 innodb_undo_002 Undo active
254 undo_00 Undo active
255 undo_001 Undo active
256 undo_01 Undo active
257 undo_011 Undo active
258 undo_02 Undo active
259 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
260 FROM INFORMATION_SCHEMA.FILES
261 WHERE FILE_NAME LIKE '%undo_0%'
262 ORDER BY TABLESPACE_NAME;
263 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
264 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
265 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
266 undo_00 ./undo_00.ibu UNDO LOG InnoDB
267 undo_001 ./undo_001.ibu UNDO LOG InnoDB
268 undo_01 ./undo_01.ibu UNDO LOG InnoDB
269 undo_011 ./undo_011.ibu UNDO LOG InnoDB
270 undo_02 ./undo_02.ibu UNDO LOG InnoDB
271 SHOW CREATE TABLE t2;
272 Table Create Table
273 t2 CREATE TABLE `t2` (
274 `col1` int NOT NULL,
275 `col2` int DEFAULT NULL,
276 `col3` varchar(64) DEFAULT NULL,
277 `col4` blob,
278 PRIMARY KEY (`col1`)
279 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
280 /*!50100 PARTITION BY KEY (col1)
281 PARTITIONS 5 */
282 CHECK TABLE t2 EXTENDED;
283 Table Op Msg_type Msg_text
284 test.t2 check status OK
285 SELECT count(*) from t2;
286 count(*)
287 100
288 SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;;
289 col1 col2 col3
290 0 3 Clone Test Row - 0
291 1 13 Clone Test Row - 1
292 2 23 Clone Test Row - 2
293 3 33 Clone Test Row - 3
294 4 43 Clone Test Row - 4
295 5 53 Clone Test Row - 5
296 6 63 Clone Test Row - 6
297 7 73 Clone Test Row - 7
298 8 83 Clone Test Row - 8
299 9 93 Clone Test Row - 9
300 SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;;
301 col1 col2 col3
302 99 993 Clone Test Row - 99
303 98 983 Clone Test Row - 98
304 97 973 Clone Test Row - 97
305 96 963 Clone Test Row - 96
306 95 953 Clone Test Row - 95
307 94 943 Clone Test Row - 94
308 93 933 Clone Test Row - 93
309 92 923 Clone Test Row - 92
310 91 913 Clone Test Row - 91
311 90 903 Clone Test Row - 90
312 SELECT NAME, SPACE_TYPE, STATE
313 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
314 WHERE SPACE_TYPE = 'Undo'
315 ORDER BY NAME;
316 NAME SPACE_TYPE STATE
317 innodb_undo_001 Undo active
318 innodb_undo_002 Undo active
319 undo_00 Undo active
320 undo_001 Undo active
321 undo_01 Undo active
322 undo_011 Undo active
323 undo_02 Undo active
324 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
325 FROM INFORMATION_SCHEMA.FILES
326 WHERE FILE_NAME LIKE '%undo_0%'
327 ORDER BY TABLESPACE_NAME;
328 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
329 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
330 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
331 undo_00 ./undo_00.ibu UNDO LOG InnoDB
332 undo_001 ./undo_001.ibu UNDO LOG InnoDB
333 undo_01 ./undo_01.ibu UNDO LOG InnoDB
334 undo_011 ./undo_011.ibu UNDO LOG InnoDB
335 undo_02 ./undo_02.ibu UNDO LOG InnoDB
336 CALL execute_dml(1, 0, 100, 100, 10, 0);
337 # Restart server back on base data directory
338 # restart:
339 SET DEBUG_SYNC = 'RESET';
340 # 2. TRUNCATE UNDO TABLESPACE while clone in progress
341 RESET MASTER;
342 SET GLOBAL DEBUG = '+d,local_release_clone_file_pin';
343 ALTER UNDO TABLESPACE undo_00 SET INACTIVE ;
344 SET DEBUG_SYNC = 'clone_before_init_meta SIGNAL start_ddl_file_init WAIT_FOR resume_file_init';
345 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl_file WAIT_FOR resume_file';
346 SET DEBUG_SYNC = 'clone_file_copy_end_before_ack SIGNAL start_ddl_file_ack WAIT_FOR resume_file_ack';
347 SET DEBUG_SYNC = 'clone_before_file_ddl_meta SIGNAL start_ddl_file_meta WAIT_FOR resume_file_meta';
348 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_ddl_page WAIT_FOR resume_page';
349 SET DEBUG_SYNC = 'clone_before_page_ddl_meta SIGNAL start_ddl_page_meta WAIT_FOR resume_page_meta';
350 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL start_ddl_redo WAIT_FOR resume_redo';
351 SET GLOBAL clone_autotune_concurrency = OFF;
352 SET GLOBAL clone_max_concurrency = 8;
353 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
354 # In connection CON1
355 # Waiting for clone to reach 'Initial metadata transfer'
356 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_init';
357 # Wait finished
358 ALTER UNDO TABLESPACE undo_001 SET INACTIVE ;
359 SET DEBUG_SYNC = 'now SIGNAL resume_file_init';
360 # Waiting for clone to reach 'file copy'
361 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file';
362 # Wait finished
363 ALTER UNDO TABLESPACE undo_01 SET INACTIVE ;
364 CALL execute_dml(0, 0, 100, 100, 10, 0);
365 # Flush all dirty pages to track
366 SET GLOBAL innodb_buf_flush_list_now = 1;
367 SET DEBUG_SYNC = 'now SIGNAL resume_file';
368 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_ack';
369 SET DEBUG_SYNC = 'now SIGNAL resume_file_ack';
370 # Waiting for clone to reach DDL metadata for 'file copy'
371 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_meta';
372 # Wait finished
373 ALTER UNDO TABLESPACE undo_011 SET INACTIVE ;
374 CALL execute_dml(0, 0, 100, 100, 10, 0);
375 SET DEBUG_SYNC = 'now SIGNAL resume_file_meta';
376 # Waiting for clone to reach 'page copy'
377 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_page';
378 # Wait finished
379 ALTER UNDO TABLESPACE undo_02 SET INACTIVE ;
380 CALL execute_dml(0, 0, 100, 100, 10, 0);
381 SET DEBUG_SYNC = 'now SIGNAL resume_page';
382 # Waiting for clone to reach DDL metadata for 'page copy'
383 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_page_meta';
384 # Wait finished
385 ALTER UNDO TABLESPACE undo_021 SET INACTIVE ;
386 CALL execute_dml(0, 0, 100, 100, 10, 0);
387 SET DEBUG_SYNC = 'now SIGNAL resume_page_meta';
388 # Waiting for clone to reach 'redo copy'
389 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_redo';
390 # Wait finished
391 ALTER UNDO TABLESPACE undo_03 SET INACTIVE ;
392 SET DEBUG_SYNC = 'now SIGNAL resume_redo';
393 # In connection DEFAULT
394 # Waiting for clone to complete
395 # Wait finished
396 SET GLOBAL DEBUG = '-d,local_release_clone_file_pin';
397 # Restart server on cloned data directory
398 # restart: --datadir=CLONE_DATADIR
399 # Check cloned data
400 SHOW TABLES;
401 Tables_in_test
402 t
403 t0
404 t01
405 t1
406 t11
407 t2
408 t21
409 t3
410 SHOW CREATE TABLE t1;
411 Table Create Table
412 t1 CREATE TABLE `t1` (
413 `col1` int NOT NULL,
414 `col2` int DEFAULT NULL,
415 `col3` varchar(64) DEFAULT NULL,
416 `col4` blob,
417 PRIMARY KEY (`col1`)
418 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
419 CHECK TABLE t1 EXTENDED;
420 Table Op Msg_type Msg_text
421 test.t1 check status OK
422 SELECT count(*) from t1;
423 count(*)
424 100
425 SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;;
426 col1 col2 col3
427 0 7 Clone Test Row - 0
428 1 17 Clone Test Row - 1
429 2 27 Clone Test Row - 2
430 3 37 Clone Test Row - 3
431 4 47 Clone Test Row - 4
432 5 57 Clone Test Row - 5
433 6 67 Clone Test Row - 6
434 7 77 Clone Test Row - 7
435 8 87 Clone Test Row - 8
436 9 97 Clone Test Row - 9
437 SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;;
438 col1 col2 col3
439 99 997 Clone Test Row - 99
440 98 987 Clone Test Row - 98
441 97 977 Clone Test Row - 97
442 96 967 Clone Test Row - 96
443 95 957 Clone Test Row - 95
444 94 947 Clone Test Row - 94
445 93 937 Clone Test Row - 93
446 92 927 Clone Test Row - 92
447 91 917 Clone Test Row - 91
448 90 907 Clone Test Row - 90
449 SELECT NAME, SPACE_TYPE, STATE
450 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
451 WHERE SPACE_TYPE = 'Undo'
452 ORDER BY NAME;
453 NAME SPACE_TYPE STATE
454 innodb_undo_001 Undo active
455 innodb_undo_002 Undo active
456 undo_00 Undo empty
457 undo_001 Undo empty
458 undo_01 Undo empty
459 undo_011 Undo empty
460 undo_02 Undo empty
461 undo_021 Undo active
462 undo_03 Undo active
463 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
464 FROM INFORMATION_SCHEMA.FILES
465 WHERE FILE_NAME LIKE '%undo_0%'
466 ORDER BY TABLESPACE_NAME;
467 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
468 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
469 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
470 undo_00 ./undo_00.ibu UNDO LOG InnoDB
471 undo_001 ./undo_001.ibu UNDO LOG InnoDB
472 undo_01 ./undo_01.ibu UNDO LOG InnoDB
473 undo_011 ./undo_011.ibu UNDO LOG InnoDB
474 undo_02 ./undo_02.ibu UNDO LOG InnoDB
475 undo_021 ./undo_021.ibu UNDO LOG InnoDB
476 undo_03 ./undo_03.ibu UNDO LOG InnoDB
477 SHOW CREATE TABLE t11;
478 Table Create Table
479 t11 CREATE TABLE `t11` (
480 `col1` int NOT NULL,
481 `col2` int DEFAULT NULL,
482 `col3` varchar(64) DEFAULT NULL,
483 `col4` blob,
484 PRIMARY KEY (`col1`)
485 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
486 CHECK TABLE t11 EXTENDED;
487 Table Op Msg_type Msg_text
488 test.t11 check status OK
489 SELECT count(*) from t11;
490 count(*)
491 100
492 SELECT col1, col2, col3 FROM t11 ORDER BY col1 LIMIT 10;;
493 col1 col2 col3
494 0 0 Clone Test Row - 0
495 1 10 Clone Test Row - 1
496 2 20 Clone Test Row - 2
497 3 30 Clone Test Row - 3
498 4 40 Clone Test Row - 4
499 5 50 Clone Test Row - 5
500 6 60 Clone Test Row - 6
501 7 70 Clone Test Row - 7
502 8 80 Clone Test Row - 8
503 9 90 Clone Test Row - 9
504 SELECT col1, col2, col3 FROM t11 ORDER BY col1 DESC LIMIT 10;;
505 col1 col2 col3
506 99 990 Clone Test Row - 99
507 98 980 Clone Test Row - 98
508 97 970 Clone Test Row - 97
509 96 960 Clone Test Row - 96
510 95 950 Clone Test Row - 95
511 94 940 Clone Test Row - 94
512 93 930 Clone Test Row - 93
513 92 920 Clone Test Row - 92
514 91 910 Clone Test Row - 91
515 90 900 Clone Test Row - 90
516 SELECT NAME, SPACE_TYPE, STATE
517 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
518 WHERE SPACE_TYPE = 'Undo'
519 ORDER BY NAME;
520 NAME SPACE_TYPE STATE
521 innodb_undo_001 Undo active
522 innodb_undo_002 Undo active
523 undo_00 Undo empty
524 undo_001 Undo empty
525 undo_01 Undo empty
526 undo_011 Undo empty
527 undo_02 Undo empty
528 undo_021 Undo active
529 undo_03 Undo active
530 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
531 FROM INFORMATION_SCHEMA.FILES
532 WHERE FILE_NAME LIKE '%undo_0%'
533 ORDER BY TABLESPACE_NAME;
534 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
535 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
536 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
537 undo_00 ./undo_00.ibu UNDO LOG InnoDB
538 undo_001 ./undo_001.ibu UNDO LOG InnoDB
539 undo_01 ./undo_01.ibu UNDO LOG InnoDB
540 undo_011 ./undo_011.ibu UNDO LOG InnoDB
541 undo_02 ./undo_02.ibu UNDO LOG InnoDB
542 undo_021 ./undo_021.ibu UNDO LOG InnoDB
543 undo_03 ./undo_03.ibu UNDO LOG InnoDB
544 SHOW CREATE TABLE t2;
545 Table Create Table
546 t2 CREATE TABLE `t2` (
547 `col1` int NOT NULL,
548 `col2` int DEFAULT NULL,
549 `col3` varchar(64) DEFAULT NULL,
550 `col4` blob,
551 PRIMARY KEY (`col1`)
552 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
553 /*!50100 PARTITION BY KEY (col1)
554 PARTITIONS 5 */
555 CHECK TABLE t2 EXTENDED;
556 Table Op Msg_type Msg_text
557 test.t2 check status OK
558 SELECT count(*) from t2;
559 count(*)
560 100
561 SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;;
562 col1 col2 col3
563 0 7 Clone Test Row - 0
564 1 17 Clone Test Row - 1
565 2 27 Clone Test Row - 2
566 3 37 Clone Test Row - 3
567 4 47 Clone Test Row - 4
568 5 57 Clone Test Row - 5
569 6 67 Clone Test Row - 6
570 7 77 Clone Test Row - 7
571 8 87 Clone Test Row - 8
572 9 97 Clone Test Row - 9
573 SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;;
574 col1 col2 col3
575 99 997 Clone Test Row - 99
576 98 987 Clone Test Row - 98
577 97 977 Clone Test Row - 97
578 96 967 Clone Test Row - 96
579 95 957 Clone Test Row - 95
580 94 947 Clone Test Row - 94
581 93 937 Clone Test Row - 93
582 92 927 Clone Test Row - 92
583 91 917 Clone Test Row - 91
584 90 907 Clone Test Row - 90
585 SELECT NAME, SPACE_TYPE, STATE
586 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
587 WHERE SPACE_TYPE = 'Undo'
588 ORDER BY NAME;
589 NAME SPACE_TYPE STATE
590 innodb_undo_001 Undo active
591 innodb_undo_002 Undo active
592 undo_00 Undo empty
593 undo_001 Undo empty
594 undo_01 Undo empty
595 undo_011 Undo empty
596 undo_02 Undo empty
597 undo_021 Undo active
598 undo_03 Undo active
599 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
600 FROM INFORMATION_SCHEMA.FILES
601 WHERE FILE_NAME LIKE '%undo_0%'
602 ORDER BY TABLESPACE_NAME;
603 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
604 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
605 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
606 undo_00 ./undo_00.ibu UNDO LOG InnoDB
607 undo_001 ./undo_001.ibu UNDO LOG InnoDB
608 undo_01 ./undo_01.ibu UNDO LOG InnoDB
609 undo_011 ./undo_011.ibu UNDO LOG InnoDB
610 undo_02 ./undo_02.ibu UNDO LOG InnoDB
611 undo_021 ./undo_021.ibu UNDO LOG InnoDB
612 undo_03 ./undo_03.ibu UNDO LOG InnoDB
613 CALL execute_dml(1, 0, 100, 100, 10, 0);
614 # Restart server back on base data directory
615 # restart:
616 SET DEBUG_SYNC = 'RESET';
617 # 3. DROP UNDO TABLESPACE while clone in progress
618 RESET MASTER;
619 SET GLOBAL DEBUG = '+d,local_release_clone_file_pin';
620 DROP UNDO TABLESPACE undo_00 ;
621 SET DEBUG_SYNC = 'clone_before_init_meta SIGNAL start_ddl_file_init WAIT_FOR resume_file_init';
622 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl_file WAIT_FOR resume_file';
623 SET DEBUG_SYNC = 'clone_file_copy_end_before_ack SIGNAL start_ddl_file_ack WAIT_FOR resume_file_ack';
624 SET DEBUG_SYNC = 'clone_before_file_ddl_meta SIGNAL start_ddl_file_meta WAIT_FOR resume_file_meta';
625 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_ddl_page WAIT_FOR resume_page';
626 SET DEBUG_SYNC = 'clone_before_page_ddl_meta SIGNAL start_ddl_page_meta WAIT_FOR resume_page_meta';
627 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL start_ddl_redo WAIT_FOR resume_redo';
628 SET GLOBAL clone_autotune_concurrency = OFF;
629 SET GLOBAL clone_max_concurrency = 8;
630 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
631 # In connection CON1
632 # Waiting for clone to reach 'Initial metadata transfer'
633 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_init';
634 # Wait finished
635 DROP UNDO TABLESPACE undo_001 ;
636 SET DEBUG_SYNC = 'now SIGNAL resume_file_init';
637 # Waiting for clone to reach 'file copy'
638 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file';
639 # Wait finished
640 DROP UNDO TABLESPACE undo_01 ;
641 CALL execute_dml(0, 0, 100, 100, 10, 0);
642 # Flush all dirty pages to track
643 SET GLOBAL innodb_buf_flush_list_now = 1;
644 SET DEBUG_SYNC = 'now SIGNAL resume_file';
645 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_ack';
646 SET DEBUG_SYNC = 'now SIGNAL resume_file_ack';
647 # Waiting for clone to reach DDL metadata for 'file copy'
648 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_file_meta';
649 # Wait finished
650 DROP UNDO TABLESPACE undo_011 ;
651 CALL execute_dml(0, 0, 100, 100, 10, 0);
652 SET DEBUG_SYNC = 'now SIGNAL resume_file_meta';
653 # Waiting for clone to reach 'page copy'
654 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_page';
655 # Wait finished
656 DROP UNDO TABLESPACE undo_02 ;
657 CALL execute_dml(0, 0, 100, 100, 10, 0);
658 SET DEBUG_SYNC = 'now SIGNAL resume_page';
659 # Waiting for clone to reach DDL metadata for 'page copy'
660 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_page_meta';
661 # Wait finished
662 DROP UNDO TABLESPACE undo_021 ;
663 CALL execute_dml(0, 0, 100, 100, 10, 0);
664 SET DEBUG_SYNC = 'now SIGNAL resume_page_meta';
665 # Waiting for clone to reach 'redo copy'
666 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_redo';
667 # Wait finished
668 DROP UNDO TABLESPACE undo_03 ;
669 SET DEBUG_SYNC = 'now SIGNAL resume_redo';
670 # In connection DEFAULT
671 # Waiting for clone to complete
672 # Wait finished
673 SET GLOBAL DEBUG = '-d,local_release_clone_file_pin';
674 # Restart server on cloned data directory
675 # restart: --datadir=CLONE_DATADIR
676 # Check cloned data
677 SHOW TABLES;
678 Tables_in_test
679 t
680 t0
681 t01
682 t1
683 t11
684 t2
685 t21
686 t3
687 SHOW CREATE TABLE t1;
688 Table Create Table
689 t1 CREATE TABLE `t1` (
690 `col1` int NOT NULL,
691 `col2` int DEFAULT NULL,
692 `col3` varchar(64) DEFAULT NULL,
693 `col4` blob,
694 PRIMARY KEY (`col1`)
695 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
696 CHECK TABLE t1 EXTENDED;
697 Table Op Msg_type Msg_text
698 test.t1 check status OK
699 SELECT count(*) from t1;
700 count(*)
701 100
702 SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;;
703 col1 col2 col3
704 0 11 Clone Test Row - 0
705 1 21 Clone Test Row - 1
706 2 31 Clone Test Row - 2
707 3 41 Clone Test Row - 3
708 4 51 Clone Test Row - 4
709 5 61 Clone Test Row - 5
710 6 71 Clone Test Row - 6
711 7 81 Clone Test Row - 7
712 8 91 Clone Test Row - 8
713 9 101 Clone Test Row - 9
714 SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;;
715 col1 col2 col3
716 99 1001 Clone Test Row - 99
717 98 991 Clone Test Row - 98
718 97 981 Clone Test Row - 97
719 96 971 Clone Test Row - 96
720 95 961 Clone Test Row - 95
721 94 951 Clone Test Row - 94
722 93 941 Clone Test Row - 93
723 92 931 Clone Test Row - 92
724 91 921 Clone Test Row - 91
725 90 911 Clone Test Row - 90
726 SELECT NAME, SPACE_TYPE, STATE
727 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
728 WHERE SPACE_TYPE = 'Undo'
729 ORDER BY NAME;
730 NAME SPACE_TYPE STATE
731 innodb_undo_001 Undo active
732 innodb_undo_002 Undo active
733 undo_021 Undo empty
734 undo_03 Undo empty
735 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
736 FROM INFORMATION_SCHEMA.FILES
737 WHERE FILE_NAME LIKE '%undo_0%'
738 ORDER BY TABLESPACE_NAME;
739 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
740 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
741 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
742 undo_021 ./undo_021.ibu UNDO LOG InnoDB
743 undo_03 ./undo_03.ibu UNDO LOG InnoDB
744 SHOW CREATE TABLE t11;
745 Table Create Table
746 t11 CREATE TABLE `t11` (
747 `col1` int NOT NULL,
748 `col2` int DEFAULT NULL,
749 `col3` varchar(64) DEFAULT NULL,
750 `col4` blob,
751 PRIMARY KEY (`col1`)
752 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
753 CHECK TABLE t11 EXTENDED;
754 Table Op Msg_type Msg_text
755 test.t11 check status OK
756 SELECT count(*) from t11;
757 count(*)
758 100
759 SELECT col1, col2, col3 FROM t11 ORDER BY col1 LIMIT 10;;
760 col1 col2 col3
761 0 0 Clone Test Row - 0
762 1 10 Clone Test Row - 1
763 2 20 Clone Test Row - 2
764 3 30 Clone Test Row - 3
765 4 40 Clone Test Row - 4
766 5 50 Clone Test Row - 5
767 6 60 Clone Test Row - 6
768 7 70 Clone Test Row - 7
769 8 80 Clone Test Row - 8
770 9 90 Clone Test Row - 9
771 SELECT col1, col2, col3 FROM t11 ORDER BY col1 DESC LIMIT 10;;
772 col1 col2 col3
773 99 990 Clone Test Row - 99
774 98 980 Clone Test Row - 98
775 97 970 Clone Test Row - 97
776 96 960 Clone Test Row - 96
777 95 950 Clone Test Row - 95
778 94 940 Clone Test Row - 94
779 93 930 Clone Test Row - 93
780 92 920 Clone Test Row - 92
781 91 910 Clone Test Row - 91
782 90 900 Clone Test Row - 90
783 SELECT NAME, SPACE_TYPE, STATE
784 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
785 WHERE SPACE_TYPE = 'Undo'
786 ORDER BY NAME;
787 NAME SPACE_TYPE STATE
788 innodb_undo_001 Undo active
789 innodb_undo_002 Undo active
790 undo_021 Undo empty
791 undo_03 Undo empty
792 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
793 FROM INFORMATION_SCHEMA.FILES
794 WHERE FILE_NAME LIKE '%undo_0%'
795 ORDER BY TABLESPACE_NAME;
796 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
797 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
798 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
799 undo_021 ./undo_021.ibu UNDO LOG InnoDB
800 undo_03 ./undo_03.ibu UNDO LOG InnoDB
801 SHOW CREATE TABLE t2;
802 Table Create Table
803 t2 CREATE TABLE `t2` (
804 `col1` int NOT NULL,
805 `col2` int DEFAULT NULL,
806 `col3` varchar(64) DEFAULT NULL,
807 `col4` blob,
808 PRIMARY KEY (`col1`)
809 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
810 /*!50100 PARTITION BY KEY (col1)
811 PARTITIONS 5 */
812 CHECK TABLE t2 EXTENDED;
813 Table Op Msg_type Msg_text
814 test.t2 check status OK
815 SELECT count(*) from t2;
816 count(*)
817 100
818 SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;;
819 col1 col2 col3
820 0 11 Clone Test Row - 0
821 1 21 Clone Test Row - 1
822 2 31 Clone Test Row - 2
823 3 41 Clone Test Row - 3
824 4 51 Clone Test Row - 4
825 5 61 Clone Test Row - 5
826 6 71 Clone Test Row - 6
827 7 81 Clone Test Row - 7
828 8 91 Clone Test Row - 8
829 9 101 Clone Test Row - 9
830 SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;;
831 col1 col2 col3
832 99 1001 Clone Test Row - 99
833 98 991 Clone Test Row - 98
834 97 981 Clone Test Row - 97
835 96 971 Clone Test Row - 96
836 95 961 Clone Test Row - 95
837 94 951 Clone Test Row - 94
838 93 941 Clone Test Row - 93
839 92 931 Clone Test Row - 92
840 91 921 Clone Test Row - 91
841 90 911 Clone Test Row - 90
842 SELECT NAME, SPACE_TYPE, STATE
843 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES
844 WHERE SPACE_TYPE = 'Undo'
845 ORDER BY NAME;
846 NAME SPACE_TYPE STATE
847 innodb_undo_001 Undo active
848 innodb_undo_002 Undo active
849 undo_021 Undo empty
850 undo_03 Undo empty
851 SELECT TABLESPACE_NAME, FILE_NAME, FILE_TYPE, ENGINE
852 FROM INFORMATION_SCHEMA.FILES
853 WHERE FILE_NAME LIKE '%undo_0%'
854 ORDER BY TABLESPACE_NAME;
855 TABLESPACE_NAME FILE_NAME FILE_TYPE ENGINE
856 innodb_undo_001 ./undo_001 UNDO LOG InnoDB
857 innodb_undo_002 ./undo_002 UNDO LOG InnoDB
858 undo_021 ./undo_021.ibu UNDO LOG InnoDB
859 undo_03 ./undo_03.ibu UNDO LOG InnoDB
860 CALL execute_dml(1, 0, 100, 100, 10, 0);
861 # Restart server back on base data directory
862 # restart:
863 SET DEBUG_SYNC = 'RESET';
864 # Cleanup
865 DROP TABLE t;
866 DROP TABLE t1;
867 DROP TABLE t2;
868 DROP PROCEDURE execute_dml;
869 DROP TABLE t0;
870 DROP TABLE t01;
871 DROP TABLE t3;
872 DROP TABLE t11;
873 DROP TABLE t21;
874 # Uninstall clone
875 UNINSTALL PLUGIN clone;