Debian Codegraph @

mysql-test/suite/clone/r/remote_boundary.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, 150, 150, 10, 0);
61 SHOW CREATE TABLE t1;
62 Table Create Table
63 t1 CREATE TABLE `t1` (
64 `col1` int NOT NULL,
65 `col2` int DEFAULT NULL,
66 `col3` varchar(64) DEFAULT NULL,
67 `col4` blob,
68 PRIMARY KEY (`col1`)
69 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
70 SELECT count(*) from t1;
71 count(*)
72 150
73 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
74 col1 col2 col3 SUBSTRING(col4, 1000, 32)
75 0 0 Clone Test Row - 0 umn Data Large Column Data Large
76 1 10 Clone Test Row - 1 umn Data Large Column Data Large
77 2 20 Clone Test Row - 2 umn Data Large Column Data Large
78 3 30 Clone Test Row - 3 umn Data Large Column Data Large
79 4 40 Clone Test Row - 4 umn Data Large Column Data Large
80 5 50 Clone Test Row - 5 umn Data Large Column Data Large
81 6 60 Clone Test Row - 6 umn Data Large Column Data Large
82 7 70 Clone Test Row - 7 umn Data Large Column Data Large
83 8 80 Clone Test Row - 8 umn Data Large Column Data Large
84 9 90 Clone Test Row - 9 umn Data Large Column Data Large
85 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
86 col1 col2 col3 SUBSTRING(col4, 1000, 32)
87 149 1490 Clone Test Row - 149 umn Data Large Column Data Large
88 148 1480 Clone Test Row - 148 umn Data Large Column Data Large
89 147 1470 Clone Test Row - 147 umn Data Large Column Data Large
90 146 1460 Clone Test Row - 146 umn Data Large Column Data Large
91 145 1450 Clone Test Row - 145 umn Data Large Column Data Large
92 144 1440 Clone Test Row - 144 umn Data Large Column Data Large
93 143 1430 Clone Test Row - 143 umn Data Large Column Data Large
94 142 1420 Clone Test Row - 142 umn Data Large Column Data Large
95 141 1410 Clone Test Row - 141 umn Data Large Column Data Large
96 140 1400 Clone Test Row - 140 umn Data Large Column Data Large
97 SHOW CREATE TABLE t2;
98 Table Create Table
99 t2 CREATE TABLE `t2` (
100 `col1` int NOT NULL,
101 `col2` int DEFAULT NULL,
102 `col3` varchar(64) DEFAULT NULL,
103 `col4` blob,
104 PRIMARY KEY (`col1`)
105 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
106 /*!50100 PARTITION BY KEY (col1)
107 PARTITIONS 5 */
108 SELECT count(*) from t2;
109 count(*)
110 150
111 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
112 col1 col2 col3 SUBSTRING(col4, 1000, 32)
113 0 0 Clone Test Row - 0 umn Data Large Column Data Large
114 1 10 Clone Test Row - 1 umn Data Large Column Data Large
115 2 20 Clone Test Row - 2 umn Data Large Column Data Large
116 3 30 Clone Test Row - 3 umn Data Large Column Data Large
117 4 40 Clone Test Row - 4 umn Data Large Column Data Large
118 5 50 Clone Test Row - 5 umn Data Large Column Data Large
119 6 60 Clone Test Row - 6 umn Data Large Column Data Large
120 7 70 Clone Test Row - 7 umn Data Large Column Data Large
121 8 80 Clone Test Row - 8 umn Data Large Column Data Large
122 9 90 Clone Test Row - 9 umn Data Large Column Data Large
123 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
124 col1 col2 col3 SUBSTRING(col4, 1000, 32)
125 149 1490 Clone Test Row - 149 umn Data Large Column Data Large
126 148 1480 Clone Test Row - 148 umn Data Large Column Data Large
127 147 1470 Clone Test Row - 147 umn Data Large Column Data Large
128 146 1460 Clone Test Row - 146 umn Data Large Column Data Large
129 145 1450 Clone Test Row - 145 umn Data Large Column Data Large
130 144 1440 Clone Test Row - 144 umn Data Large Column Data Large
131 143 1430 Clone Test Row - 143 umn Data Large Column Data Large
132 142 1420 Clone Test Row - 142 umn Data Large Column Data Large
133 141 1410 Clone Test Row - 141 umn Data Large Column Data Large
134 140 1400 Clone Test Row - 140 umn Data Large Column Data Large
135 # In connection default - Cloning database
136 SET GLOBAL DEBUG ="+d,clone_no_zero_copy";
137 SET DEBUG_SYNC = 'RESET';
138 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
139 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
140 SET GLOBAL clone_autotune_concurrency = OFF;
141 SET GLOBAL clone_max_concurrency = 8;
142 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
143 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
144 # In connection con1 - Running Update Random [0 - 150 Key Range]
145 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
146 START TRANSACTION;
147 CALL execute_dml(1, 0, 150, 200, 100, 1);
148 COMMIT;
149 # Flush all dirty buffers
150 SET GLOBAL innodb_buf_flush_list_now = 1;
151 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
152 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
153 START TRANSACTION;
154 CALL execute_dml(1, 0, 150, 200, 100, 1);
155 COMMIT;
156 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
157 # In connection default - Cloning database
158 SET GLOBAL DEBUG ="-d,clone_no_zero_copy";
159 # Restart cloned database
160 # restart: --datadir=CLONE_DATADIR
161 SHOW CREATE TABLE t1;
162 Table Create Table
163 t1 CREATE TABLE `t1` (
164 `col1` int NOT NULL,
165 `col2` int DEFAULT NULL,
166 `col3` varchar(64) DEFAULT NULL,
167 `col4` blob,
168 PRIMARY KEY (`col1`)
169 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
170 SELECT count(*) from t1;
171 count(*)
172 150
173 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
174 col1 col3 SUBSTRING(col4, 1000, 32)
175 0 Clone Test Row - 0 umn Data Large Column Data Large
176 1 Clone Test Row - 1 umn Data Large Column Data Large
177 2 Clone Test Row - 2 umn Data Large Column Data Large
178 3 Clone Test Row - 3 umn Data Large Column Data Large
179 4 Clone Test Row - 4 umn Data Large Column Data Large
180 5 Clone Test Row - 5 umn Data Large Column Data Large
181 6 Clone Test Row - 6 umn Data Large Column Data Large
182 7 Clone Test Row - 7 umn Data Large Column Data Large
183 8 Clone Test Row - 8 umn Data Large Column Data Large
184 9 Clone Test Row - 9 umn Data Large Column Data Large
185 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
186 col1 col3 SUBSTRING(col4, 1000, 32)
187 149 Clone Test Row - 149 umn Data Large Column Data Large
188 148 Clone Test Row - 148 umn Data Large Column Data Large
189 147 Clone Test Row - 147 umn Data Large Column Data Large
190 146 Clone Test Row - 146 umn Data Large Column Data Large
191 145 Clone Test Row - 145 umn Data Large Column Data Large
192 144 Clone Test Row - 144 umn Data Large Column Data Large
193 143 Clone Test Row - 143 umn Data Large Column Data Large
194 142 Clone Test Row - 142 umn Data Large Column Data Large
195 141 Clone Test Row - 141 umn Data Large Column Data Large
196 140 Clone Test Row - 140 umn Data Large Column Data Large
197 SHOW CREATE TABLE t2;
198 Table Create Table
199 t2 CREATE TABLE `t2` (
200 `col1` int NOT NULL,
201 `col2` int DEFAULT NULL,
202 `col3` varchar(64) DEFAULT NULL,
203 `col4` blob,
204 PRIMARY KEY (`col1`)
205 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
206 /*!50100 PARTITION BY KEY (col1)
207 PARTITIONS 5 */
208 SELECT count(*) from t2;
209 count(*)
210 150
211 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
212 col1 col3 SUBSTRING(col4, 1000, 32)
213 0 Clone Test Row - 0 umn Data Large Column Data Large
214 1 Clone Test Row - 1 umn Data Large Column Data Large
215 2 Clone Test Row - 2 umn Data Large Column Data Large
216 3 Clone Test Row - 3 umn Data Large Column Data Large
217 4 Clone Test Row - 4 umn Data Large Column Data Large
218 5 Clone Test Row - 5 umn Data Large Column Data Large
219 6 Clone Test Row - 6 umn Data Large Column Data Large
220 7 Clone Test Row - 7 umn Data Large Column Data Large
221 8 Clone Test Row - 8 umn Data Large Column Data Large
222 9 Clone Test Row - 9 umn Data Large Column Data Large
223 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
224 col1 col3 SUBSTRING(col4, 1000, 32)
225 149 Clone Test Row - 149 umn Data Large Column Data Large
226 148 Clone Test Row - 148 umn Data Large Column Data Large
227 147 Clone Test Row - 147 umn Data Large Column Data Large
228 146 Clone Test Row - 146 umn Data Large Column Data Large
229 145 Clone Test Row - 145 umn Data Large Column Data Large
230 144 Clone Test Row - 144 umn Data Large Column Data Large
231 143 Clone Test Row - 143 umn Data Large Column Data Large
232 142 Clone Test Row - 142 umn Data Large Column Data Large
233 141 Clone Test Row - 141 umn Data Large Column Data Large
234 140 Clone Test Row - 140 umn Data Large Column Data Large
235 call execute_dml(3, 0, 1, 1, 1, 0);
236 call execute_dml(0, 0, 150, 150, 100, 0);
237 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
238 col1 col2 col3 SUBSTRING(col4, 1000, 32)
239 0 0 Clone Test Row - 0 umn Data Large Column Data Large
240 1 10 Clone Test Row - 1 umn Data Large Column Data Large
241 2 20 Clone Test Row - 2 umn Data Large Column Data Large
242 3 30 Clone Test Row - 3 umn Data Large Column Data Large
243 4 40 Clone Test Row - 4 umn Data Large Column Data Large
244 5 50 Clone Test Row - 5 umn Data Large Column Data Large
245 6 60 Clone Test Row - 6 umn Data Large Column Data Large
246 7 70 Clone Test Row - 7 umn Data Large Column Data Large
247 8 80 Clone Test Row - 8 umn Data Large Column Data Large
248 9 90 Clone Test Row - 9 umn Data Large Column Data Large
249 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
250 col1 col2 col3 SUBSTRING(col4, 1000, 32)
251 149 1490 Clone Test Row - 149 umn Data Large Column Data Large
252 148 1480 Clone Test Row - 148 umn Data Large Column Data Large
253 147 1470 Clone Test Row - 147 umn Data Large Column Data Large
254 146 1460 Clone Test Row - 146 umn Data Large Column Data Large
255 145 1450 Clone Test Row - 145 umn Data Large Column Data Large
256 144 1440 Clone Test Row - 144 umn Data Large Column Data Large
257 143 1430 Clone Test Row - 143 umn Data Large Column Data Large
258 142 1420 Clone Test Row - 142 umn Data Large Column Data Large
259 141 1410 Clone Test Row - 141 umn Data Large Column Data Large
260 140 1400 Clone Test Row - 140 umn Data Large Column Data Large
261 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
262 col1 col2 col3 SUBSTRING(col4, 1000, 32)
263 0 0 Clone Test Row - 0 umn Data Large Column Data Large
264 1 10 Clone Test Row - 1 umn Data Large Column Data Large
265 2 20 Clone Test Row - 2 umn Data Large Column Data Large
266 3 30 Clone Test Row - 3 umn Data Large Column Data Large
267 4 40 Clone Test Row - 4 umn Data Large Column Data Large
268 5 50 Clone Test Row - 5 umn Data Large Column Data Large
269 6 60 Clone Test Row - 6 umn Data Large Column Data Large
270 7 70 Clone Test Row - 7 umn Data Large Column Data Large
271 8 80 Clone Test Row - 8 umn Data Large Column Data Large
272 9 90 Clone Test Row - 9 umn Data Large Column Data Large
273 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
274 col1 col2 col3 SUBSTRING(col4, 1000, 32)
275 149 1490 Clone Test Row - 149 umn Data Large Column Data Large
276 148 1480 Clone Test Row - 148 umn Data Large Column Data Large
277 147 1470 Clone Test Row - 147 umn Data Large Column Data Large
278 146 1460 Clone Test Row - 146 umn Data Large Column Data Large
279 145 1450 Clone Test Row - 145 umn Data Large Column Data Large
280 144 1440 Clone Test Row - 144 umn Data Large Column Data Large
281 143 1430 Clone Test Row - 143 umn Data Large Column Data Large
282 142 1420 Clone Test Row - 142 umn Data Large Column Data Large
283 141 1410 Clone Test Row - 141 umn Data Large Column Data Large
284 140 1400 Clone Test Row - 140 umn Data Large Column Data Large
285 # restart:
286 SET GLOBAL innodb_redo_log_capacity = 100*1024*1024;
287 SET GLOBAL DEBUG ="+d,clone_arch_log_stop_file_end";
288 SET DEBUG_SYNC = 'RESET';
289 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
290 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
291 SET GLOBAL clone_autotune_concurrency = OFF;
292 SET GLOBAL clone_max_concurrency = 8;
293 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
294 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
295 # In connection con1 - Running Update Random [0 - 10 Key Range]
296 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
297 START TRANSACTION;
298 CALL execute_dml(1, 0, 10, 10, 10, 1);
299 COMMIT;
300 # Flush all dirty buffers
301 SET GLOBAL innodb_buf_flush_list_now = 1;
302 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
303 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
304 START TRANSACTION;
305 call execute_dml(3, 0, 1, 1, 1, 0);
306 call execute_dml(0, 0, 150, 150, 10, 0);
307 COMMIT;
308 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
309 # In connection default - Cloning database
310 SET GLOBAL DEBUG ="-d,clone_arch_log_stop_file_end";
311 SET GLOBAL innodb_redo_log_capacity = 100*1024*1024;
312 SET GLOBAL DEBUG ="+d,clone_arch_log_stop_file_end";
313 SET GLOBAL DEBUG ="+d,clone_arch_log_extra_bytes";
314 SET DEBUG_SYNC = 'RESET';
315 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
316 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
317 SET GLOBAL clone_autotune_concurrency = OFF;
318 SET GLOBAL clone_max_concurrency = 8;
319 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
320 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
321 # In connection con1 - Running Update Random [0 - 10 Key Range]
322 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
323 START TRANSACTION;
324 CALL execute_dml(1, 0, 10, 10, 10, 1);
325 COMMIT;
326 # Flush all dirty buffers
327 SET GLOBAL innodb_buf_flush_list_now = 1;
328 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
329 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
330 START TRANSACTION;
331 call execute_dml(3, 0, 1, 1, 1, 0);
332 call execute_dml(0, 0, 150, 150, 10, 0);
333 COMMIT;
334 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
335 # In connection default - Cloning database
336 SET GLOBAL DEBUG ="-d,clone_arch_log_stop_file_end";
337 SET GLOBAL DEBUG ="-d,clone_arch_log_extra_bytes";
338 SET DEBUG_SYNC = 'RESET';
339 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
340 SET GLOBAL clone_autotune_concurrency = OFF;
341 SET GLOBAL clone_max_concurrency = 8;
342 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
343 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
344 # In connection con1 - Running Update Random [0 - 10 Key Range]
345 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
346 START TRANSACTION;
347 CALL execute_dml(1, 0, 10, 10, 10, 1);
348 COMMIT;
349 # In connection default - Cloning database
350 Got one of the listed errors
351 # restart:
352 SET DEBUG_SYNC = 'RESET';
353 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
354 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
355 SET GLOBAL clone_autotune_concurrency = OFF;
356 SET GLOBAL clone_max_concurrency = 8;
357 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
358 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
359 # In connection con1 - Running Update Random [0 - 10 Key Range]
360 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
361 START TRANSACTION;
362 CALL execute_dml(1, 0, 10, 10, 10, 1);
363 COMMIT;
364 # Flush all dirty buffers
365 SET GLOBAL innodb_buf_flush_list_now = 1;
366 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
367 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
368 START TRANSACTION;
369 call execute_dml(3, 0, 1, 1, 1, 0);
370 call execute_dml(0, 0, 50, 50, 10, 0);
371 COMMIT;
372 # In connection default - Cloning database
373 Got one of the listed errors
374 # restart:
375 SET DEBUG_SYNC = 'RESET';
376 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
377 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
378 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL start_dml3 WAIT_FOR resume_clone3';
379 SET GLOBAL clone_autotune_concurrency = OFF;
380 SET GLOBAL clone_max_concurrency = 8;
381 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
382 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' DATA DIRECTORY = 'CLONE_DATADIR';
383 # In connection con1 - Running Update Random [0 - 10 Key Range]
384 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
385 START TRANSACTION;
386 CALL execute_dml(1, 0, 10, 10, 10, 1);
387 COMMIT;
388 # Flush all dirty buffers
389 SET GLOBAL innodb_buf_flush_list_now = 1;
390 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
391 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
392 START TRANSACTION;
393 call execute_dml(3, 0, 1, 1, 1, 0);
394 call execute_dml(0, 0, 50, 50, 10, 0);
395 COMMIT;
396 # Flush all dirty buffers
397 SET GLOBAL innodb_buf_flush_list_now = 1;
398 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
399 SET DEBUG_SYNC = 'now WAIT_FOR start_dml3';
400 START TRANSACTION;
401 call execute_dml(3, 0, 1, 1, 1, 0);
402 call execute_dml(0, 0, 50, 50, 10, 0);
403 COMMIT;
404 # In connection default - Cloning database
405 Got one of the listed errors
406 # restart:
407 DROP TABLE t1;
408 DROP TABLE t2;
409 DROP PROCEDURE execute_dml;
410 UNINSTALL PLUGIN clone;
411 SET DEBUG_SYNC = 'RESET';