Debian Codegraph @

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