Debian Codegraph @

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

raw
1 # In connection CON1
2 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
3 SHOW VARIABLES LIKE 'clone_ddl_timeout';
4 Variable_name Value
5 clone_ddl_timeout 300
6 SHOW VARIABLES LIKE 'clone_block_ddl';
7 Variable_name Value
8 clone_block_ddl OFF
9 # Set backup lock timeout to 1 sec
10 SET GLOBAL clone_block_ddl = true;
11 SET GLOBAL clone_ddl_timeout = 1;
12 SHOW VARIABLES LIKE 'clone_block_ddl';
13 Variable_name Value
14 clone_block_ddl ON
15 SHOW VARIABLES LIKE 'clone_ddl_timeout';
16 Variable_name Value
17 clone_ddl_timeout 1
18 SHOW VARIABLES LIKE "lock_wait_timeout";
19 Variable_name Value
20 lock_wait_timeout 1
21 # In connection DEFAULT
22 # 1A. Clone while CREATE TABLE in progress
23 # In connection CON1
24 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
25 CREATE TABLE t1 (col1 INT PRIMARY KEY);
26 # In connection DEFAULT
27 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
28 SET GLOBAL clone_autotune_concurrency = OFF;
29 SET GLOBAL clone_max_concurrency = 8;
30 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
31 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
32 select ID, STATE, ERROR_NO from performance_schema.clone_status;
33 ID STATE ERROR_NO
34 1 Failed 1205
35 select ID, STAGE, STATE from performance_schema.clone_progress;
36 ID STAGE STATE
37 1 DROP DATA Failed
38 1 FILE COPY Not Started
39 1 PAGE COPY Not Started
40 1 REDO COPY Not Started
41 1 FILE SYNC Not Started
42 1 RESTART Not Started
43 1 RECOVERY Not Started
44 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
45 # In connection CON1
46 # In connection DEFAULT
47 SHOW CREATE TABLE t1;
48 Table Create Table
49 t1 CREATE TABLE `t1` (
50 `col1` int NOT NULL,
51 PRIMARY KEY (`col1`)
52 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
53 # 1B. CREATE TABLE while clone in progress
54 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
55 SET GLOBAL clone_autotune_concurrency = OFF;
56 SET GLOBAL clone_max_concurrency = 8;
57 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
58 # In connection CON1
59 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
60 CREATE TABLE t2 (col1 INT PRIMARY KEY);
61 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
62 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
63 # In connection DEFAULT
64 SET DEBUG_SYNC = 'RESET';
65 # 1C. ALTER INSTANCE while clone in progress
66 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
67 SET GLOBAL clone_autotune_concurrency = OFF;
68 SET GLOBAL clone_max_concurrency = 8;
69 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
70 # In connection CON1
71 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
72 ALTER INSTANCE DISABLE INNODB REDO_LOG;
73 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
74 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
75 # In connection DEFAULT
76 SET DEBUG_SYNC = 'RESET';
77 SHOW STATUS LIKE 'innodb_redo_log_enabled';
78 Variable_name Value
79 Innodb_redo_log_enabled ON
80 # 1C. Clone while ALTER INSTANCE in progress
81 # In connection CON1
82 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
83 ALTER INSTANCE DISABLE INNODB REDO_LOG;
84 # In connection DEFAULT
85 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
86 SET GLOBAL clone_autotune_concurrency = OFF;
87 SET GLOBAL clone_max_concurrency = 8;
88 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
89 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
90 select ID, STATE, ERROR_NO from performance_schema.clone_status;
91 ID STATE ERROR_NO
92 1 Failed 1205
93 select ID, STAGE, STATE from performance_schema.clone_progress;
94 ID STAGE STATE
95 1 DROP DATA Failed
96 1 FILE COPY Not Started
97 1 PAGE COPY Not Started
98 1 REDO COPY Not Started
99 1 FILE SYNC Not Started
100 1 RESTART Not Started
101 1 RECOVERY Not Started
102 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
103 # In connection CON1
104 # In connection DEFAULT
105 SHOW STATUS LIKE 'innodb_redo_log_enabled';
106 Variable_name Value
107 Innodb_redo_log_enabled OFF
108 ALTER INSTANCE ENABLE INNODB REDO_LOG;
109 # 2A. Clone while ALTER TABLE ADD COLUMN [COPY] in progress
110 INSERT INTO t1 values(10), (20), (30);
111 SELECT * FROM t1 ORDER BY col1;
112 col1
113 10
114 20
115 30
116 # In connection CON1
117 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
118 ALTER TABLE t1 ADD COLUMN col2 int, ALGORITHM=COPY;
119 # In connection DEFAULT
120 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
121 SET GLOBAL clone_autotune_concurrency = OFF;
122 SET GLOBAL clone_max_concurrency = 8;
123 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
124 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
125 select ID, STATE, ERROR_NO from performance_schema.clone_status;
126 ID STATE ERROR_NO
127 1 Failed 1205
128 select ID, STAGE, STATE from performance_schema.clone_progress;
129 ID STAGE STATE
130 1 DROP DATA Failed
131 1 FILE COPY Not Started
132 1 PAGE COPY Not Started
133 1 REDO COPY Not Started
134 1 FILE SYNC Not Started
135 1 RESTART Not Started
136 1 RECOVERY Not Started
137 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
138 # In connection CON1
139 # In connection DEFAULT
140 SHOW CREATE TABLE t1;
141 Table Create Table
142 t1 CREATE TABLE `t1` (
143 `col1` int NOT NULL,
144 `col2` int DEFAULT NULL,
145 PRIMARY KEY (`col1`)
146 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
147 SELECT * FROM t1 ORDER BY col1;
148 col1 col2
149 10 NULL
150 20 NULL
151 30 NULL
152 UPDATE t1 SET col2 = col1 + 1000;
153 # 2B. ALTER TABLE ADD COLUMN [COPY] while clone in progress
154 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
155 SET GLOBAL clone_autotune_concurrency = OFF;
156 SET GLOBAL clone_max_concurrency = 8;
157 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
158 # In connection CON1
159 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
160 ALTER TABLE t1 ADD COLUMN col3 int, ALGORITHM=COPY;
161 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
162 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
163 # In connection DEFAULT
164 SET DEBUG_SYNC = 'RESET';
165 # 2C. Clone while ALTER TABLE ADD COLUMN [INPLACE] in progress
166 SELECT * FROM t1 ORDER BY col1;
167 col1 col2
168 10 1010
169 20 1020
170 30 1030
171 # In connection CON1
172 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
173 ALTER TABLE t1 ADD COLUMN col3 int, ALGORITHM=INPLACE;
174 # In connection DEFAULT
175 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
176 SET GLOBAL clone_autotune_concurrency = OFF;
177 SET GLOBAL clone_max_concurrency = 8;
178 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
179 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
180 select ID, STATE, ERROR_NO from performance_schema.clone_status;
181 ID STATE ERROR_NO
182 1 Failed 1205
183 select ID, STAGE, STATE from performance_schema.clone_progress;
184 ID STAGE STATE
185 1 DROP DATA Failed
186 1 FILE COPY Not Started
187 1 PAGE COPY Not Started
188 1 REDO COPY Not Started
189 1 FILE SYNC Not Started
190 1 RESTART Not Started
191 1 RECOVERY Not Started
192 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
193 # In connection CON1
194 # In connection DEFAULT
195 SHOW CREATE TABLE t1;
196 Table Create Table
197 t1 CREATE TABLE `t1` (
198 `col1` int NOT NULL,
199 `col2` int DEFAULT NULL,
200 `col3` int DEFAULT NULL,
201 PRIMARY KEY (`col1`)
202 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
203 SELECT * FROM t1 ORDER BY col1;
204 col1 col2 col3
205 10 1010 NULL
206 20 1020 NULL
207 30 1030 NULL
208 UPDATE t1 SET col3 = col2 + 1000;
209 # 2D. ALTER TABLE ADD COLUMN [INPLACE] while clone in progress
210 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
211 SET GLOBAL clone_autotune_concurrency = OFF;
212 SET GLOBAL clone_max_concurrency = 8;
213 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
214 # In connection CON1
215 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
216 ALTER TABLE t1 ADD COLUMN col4 int, ALGORITHM=INPLACE;
217 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
218 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
219 # In connection DEFAULT
220 SET DEBUG_SYNC = 'RESET';
221 # 3A. Clone while ADD INDEX [COPY] in progress
222 SHOW CREATE TABLE t1;
223 Table Create Table
224 t1 CREATE TABLE `t1` (
225 `col1` int NOT NULL,
226 `col2` int DEFAULT NULL,
227 `col3` int DEFAULT NULL,
228 PRIMARY KEY (`col1`)
229 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
230 # In connection CON1
231 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
232 ALTER TABLE t1 ADD INDEX col2_idx(col2), ALGORITHM=COPY;
233 # In connection DEFAULT
234 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
235 SET GLOBAL clone_autotune_concurrency = OFF;
236 SET GLOBAL clone_max_concurrency = 8;
237 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
238 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
239 select ID, STATE, ERROR_NO from performance_schema.clone_status;
240 ID STATE ERROR_NO
241 1 Failed 1205
242 select ID, STAGE, STATE from performance_schema.clone_progress;
243 ID STAGE STATE
244 1 DROP DATA Failed
245 1 FILE COPY Not Started
246 1 PAGE COPY Not Started
247 1 REDO COPY Not Started
248 1 FILE SYNC Not Started
249 1 RESTART Not Started
250 1 RECOVERY Not Started
251 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
252 # In connection CON1
253 # In connection DEFAULT
254 SHOW CREATE TABLE t1;
255 Table Create Table
256 t1 CREATE TABLE `t1` (
257 `col1` int NOT NULL,
258 `col2` int DEFAULT NULL,
259 `col3` int DEFAULT NULL,
260 PRIMARY KEY (`col1`),
261 KEY `col2_idx` (`col2`)
262 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
263 # 3B. ADD INDEX [COPY] while clone in progress
264 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
265 SET GLOBAL clone_autotune_concurrency = OFF;
266 SET GLOBAL clone_max_concurrency = 8;
267 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
268 # In connection CON1
269 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
270 ALTER TABLE t1 ADD INDEX col3_idx(col3), ALGORITHM=COPY;
271 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
272 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
273 # In connection DEFAULT
274 SET DEBUG_SYNC = 'RESET';
275 # 3C. Clone while ADD INDEX [INPLACE] in progress
276 SHOW CREATE TABLE t1;
277 Table Create Table
278 t1 CREATE TABLE `t1` (
279 `col1` int NOT NULL,
280 `col2` int DEFAULT NULL,
281 `col3` int DEFAULT NULL,
282 PRIMARY KEY (`col1`),
283 KEY `col2_idx` (`col2`)
284 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
285 # In connection CON1
286 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
287 ALTER TABLE t1 ADD INDEX col3_idx(col3), ALGORITHM=INPLACE;
288 # In connection DEFAULT
289 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
290 SET GLOBAL clone_autotune_concurrency = OFF;
291 SET GLOBAL clone_max_concurrency = 8;
292 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
293 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
294 select ID, STATE, ERROR_NO from performance_schema.clone_status;
295 ID STATE ERROR_NO
296 1 Failed 1205
297 select ID, STAGE, STATE from performance_schema.clone_progress;
298 ID STAGE STATE
299 1 DROP DATA Failed
300 1 FILE COPY Not Started
301 1 PAGE COPY Not Started
302 1 REDO COPY Not Started
303 1 FILE SYNC Not Started
304 1 RESTART Not Started
305 1 RECOVERY Not Started
306 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
307 # In connection CON1
308 # In connection DEFAULT
309 SHOW CREATE TABLE t1;
310 Table Create Table
311 t1 CREATE TABLE `t1` (
312 `col1` int NOT NULL,
313 `col2` int DEFAULT NULL,
314 `col3` int DEFAULT NULL,
315 PRIMARY KEY (`col1`),
316 KEY `col2_idx` (`col2`),
317 KEY `col3_idx` (`col3`)
318 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
319 # 3D. ADD INDEX [INPLACE] while clone in progress
320 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
321 SET GLOBAL clone_autotune_concurrency = OFF;
322 SET GLOBAL clone_max_concurrency = 8;
323 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
324 # In connection CON1
325 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
326 ALTER TABLE t1 ADD INDEX col1_idx(col1), ALGORITHM=COPY;
327 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
328 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
329 # In connection DEFAULT
330 SET DEBUG_SYNC = 'RESET';
331 # 4A. DROP INDEX [COPY] while clone in progress
332 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
333 SET GLOBAL clone_autotune_concurrency = OFF;
334 SET GLOBAL clone_max_concurrency = 8;
335 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
336 # In connection CON1
337 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
338 ALTER TABLE t1 DROP INDEX col3_idx, ALGORITHM=COPY;
339 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
340 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
341 # In connection DEFAULT
342 SET DEBUG_SYNC = 'RESET';
343 # 4B. Clone while DROP INDEX [COPY] in progress
344 SHOW CREATE TABLE t1;
345 Table Create Table
346 t1 CREATE TABLE `t1` (
347 `col1` int NOT NULL,
348 `col2` int DEFAULT NULL,
349 `col3` int DEFAULT NULL,
350 PRIMARY KEY (`col1`),
351 KEY `col2_idx` (`col2`),
352 KEY `col3_idx` (`col3`)
353 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
354 # In connection CON1
355 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
356 ALTER TABLE t1 DROP INDEX col3_idx, ALGORITHM=COPY;
357 # In connection DEFAULT
358 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
359 SET GLOBAL clone_autotune_concurrency = OFF;
360 SET GLOBAL clone_max_concurrency = 8;
361 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
362 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
363 select ID, STATE, ERROR_NO from performance_schema.clone_status;
364 ID STATE ERROR_NO
365 1 Failed 1205
366 select ID, STAGE, STATE from performance_schema.clone_progress;
367 ID STAGE STATE
368 1 DROP DATA Failed
369 1 FILE COPY Not Started
370 1 PAGE COPY Not Started
371 1 REDO COPY Not Started
372 1 FILE SYNC Not Started
373 1 RESTART Not Started
374 1 RECOVERY Not Started
375 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
376 # In connection CON1
377 # In connection DEFAULT
378 SHOW CREATE TABLE t1;
379 Table Create Table
380 t1 CREATE TABLE `t1` (
381 `col1` int NOT NULL,
382 `col2` int DEFAULT NULL,
383 `col3` int DEFAULT NULL,
384 PRIMARY KEY (`col1`),
385 KEY `col2_idx` (`col2`)
386 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
387 # 4C. DROP INDEX [INPLACE] while clone in progress
388 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
389 SET GLOBAL clone_autotune_concurrency = OFF;
390 SET GLOBAL clone_max_concurrency = 8;
391 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
392 # In connection CON1
393 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
394 ALTER TABLE t1 DROP INDEX col2_idx, ALGORITHM=INPLACE;
395 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
396 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
397 # In connection DEFAULT
398 SET DEBUG_SYNC = 'RESET';
399 # 4D. Clone while DROP INDEX [INPLACE] in progress
400 SHOW CREATE TABLE t1;
401 Table Create Table
402 t1 CREATE TABLE `t1` (
403 `col1` int NOT NULL,
404 `col2` int DEFAULT NULL,
405 `col3` int DEFAULT NULL,
406 PRIMARY KEY (`col1`),
407 KEY `col2_idx` (`col2`)
408 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
409 # In connection CON1
410 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
411 ALTER TABLE t1 DROP INDEX col2_idx, ALGORITHM=INPLACE;
412 # In connection DEFAULT
413 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
414 SET GLOBAL clone_autotune_concurrency = OFF;
415 SET GLOBAL clone_max_concurrency = 8;
416 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
417 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
418 select ID, STATE, ERROR_NO from performance_schema.clone_status;
419 ID STATE ERROR_NO
420 1 Failed 1205
421 select ID, STAGE, STATE from performance_schema.clone_progress;
422 ID STAGE STATE
423 1 DROP DATA Failed
424 1 FILE COPY Not Started
425 1 PAGE COPY Not Started
426 1 REDO COPY Not Started
427 1 FILE SYNC Not Started
428 1 RESTART Not Started
429 1 RECOVERY Not Started
430 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
431 # In connection CON1
432 # In connection DEFAULT
433 SHOW CREATE TABLE t1;
434 Table Create Table
435 t1 CREATE TABLE `t1` (
436 `col1` int NOT NULL,
437 `col2` int DEFAULT NULL,
438 `col3` int DEFAULT NULL,
439 PRIMARY KEY (`col1`)
440 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
441 # 5A. TRUNCATE TABLE while clone in progress
442 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
443 SET GLOBAL clone_autotune_concurrency = OFF;
444 SET GLOBAL clone_max_concurrency = 8;
445 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
446 # In connection CON1
447 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
448 TRUNCATE TABLE t1;
449 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
450 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
451 # In connection DEFAULT
452 SET DEBUG_SYNC = 'RESET';
453 # 5B. Clone while TRUNCATE TABLE in progress
454 SELECT * FROM t1 ORDER BY col1;
455 col1 col2 col3
456 10 1010 2010
457 20 1020 2020
458 30 1030 2030
459 # In connection CON1
460 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
461 TRUNCATE TABLE t1;
462 # In connection DEFAULT
463 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
464 SET GLOBAL clone_autotune_concurrency = OFF;
465 SET GLOBAL clone_max_concurrency = 8;
466 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
467 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
468 select ID, STATE, ERROR_NO from performance_schema.clone_status;
469 ID STATE ERROR_NO
470 1 Failed 1205
471 select ID, STAGE, STATE from performance_schema.clone_progress;
472 ID STAGE STATE
473 1 DROP DATA Failed
474 1 FILE COPY Not Started
475 1 PAGE COPY Not Started
476 1 REDO COPY Not Started
477 1 FILE SYNC Not Started
478 1 RESTART Not Started
479 1 RECOVERY Not Started
480 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
481 # In connection CON1
482 # In connection DEFAULT
483 SELECT * FROM t1 ORDER BY col1;
484 col1 col2 col3
485 # 6A. DROP TABLE while clone in progress
486 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl WAIT_FOR resume_clone';
487 SET GLOBAL clone_autotune_concurrency = OFF;
488 SET GLOBAL clone_max_concurrency = 8;
489 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
490 # In connection CON1
491 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl';
492 DROP TABLE t1;
493 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
494 SET DEBUG_SYNC = 'now SIGNAL resume_clone';
495 # In connection DEFAULT
496 SET DEBUG_SYNC = 'RESET';
497 SHOW CREATE TABLE t1;
498 Table Create Table
499 t1 CREATE TABLE `t1` (
500 `col1` int NOT NULL,
501 `col2` int DEFAULT NULL,
502 `col3` int DEFAULT NULL,
503 PRIMARY KEY (`col1`)
504 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
505 # 6B. Clone while DROP TABLE in progress
506 # In connection CON1
507 SET DEBUG_SYNC = 'clone_notify_ddl SIGNAL resume_clone WAIT_FOR resume_ddl';
508 DROP TABLE t1;
509 # In connection DEFAULT
510 SET DEBUG_SYNC = 'now WAIT_FOR resume_clone';
511 SET GLOBAL clone_autotune_concurrency = OFF;
512 SET GLOBAL clone_max_concurrency = 8;
513 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
514 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
515 select ID, STATE, ERROR_NO from performance_schema.clone_status;
516 ID STATE ERROR_NO
517 1 Failed 1205
518 select ID, STAGE, STATE from performance_schema.clone_progress;
519 ID STAGE STATE
520 1 DROP DATA Failed
521 1 FILE COPY Not Started
522 1 PAGE COPY Not Started
523 1 REDO COPY Not Started
524 1 FILE SYNC Not Started
525 1 RESTART Not Started
526 1 RECOVERY Not Started
527 SET DEBUG_SYNC = 'now SIGNAL resume_ddl';
528 # In connection CON1
529 # In connection DEFAULT
530 #Cleanup
531 SET DEBUG_SYNC = 'RESET';
532 UNINSTALL PLUGIN clone;