Debian Codegraph @

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

raw
1 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
2 # Create test schema
3 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
4 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
5 PARTITION BY KEY(col1) PARTITIONS 5;
6 CREATE PROCEDURE execute_dml(
7 p_dml_type INT,
8 p_key_min INT,
9 p_key_range INT,
10 p_loop_count INT,
11 p_frequency INT,
12 p_is_rand INT)
13 BEGIN
14 DECLARE v_idx INT DEFAULT 0;
15 DECLARE v_commit INT DEFAULT 0;
16 DECLARE v_key INT DEFAULT 0;
17 /* Loop and INSERT data at random position */
18 WHILE(v_idx < p_loop_count) DO
19 /* Generate key between 1 to p_loop_count */
20 IF p_is_rand = 1 THEN
21 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
22 ELSE
23 SET v_key = p_key_min + (v_idx % p_key_range);
24 END IF;
25 CASE p_dml_type
26 WHEN 0 THEN
27 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
28 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
29 v_key, v_key * 10,
30 @clol3_text, REPEAT('Large Column Data ', 2048))
31 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
32 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
33 v_key, v_key * 10,
34 @clol3_text, REPEAT('Large Column Data ', 2048))
35 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
36 WHEN 1 THEN
37 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
38 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
39 WHEN 2 THEN
40 DELETE FROM t1 WHERE col1 = v_key;
41 DELETE FROM t2 WHERE col1 = v_key;
42 ELSE
43 DELETE FROM t1;
44 DELETE FROM t2;
45 END CASE;
46 SET v_idx = v_idx + 1;
47 /* Commit or rollback work at specified frequency. */
48 IF v_idx % p_frequency = 0 THEN
49 SET v_commit = FLOOR(RAND() * 2);
50 IF v_commit = 0 AND p_is_rand = 1 THEN
51 ROLLBACK;
52 START TRANSACTION;
53 ELSE
54 COMMIT;
55 START TRANSACTION;
56 END IF;
57 END IF;
58 END WHILE;
59 COMMIT;
60 END|
61 CALL execute_dml(0, 0, 10, 10, 10, 0);
62 SET GLOBAL DEBUG = '+d,local_release_clone_file_pin';
63 # 1. Truncate same table in various stages of CLONE
64 # In connection DEFAULT
65 SET DEBUG_SYNC = 'clone_before_init_meta SIGNAL start_ddl_0 WAIT_FOR resume_clone_0';
66 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_ddl_1 WAIT_FOR resume_clone_1';
67 SET DEBUG_SYNC = 'clone_file_copy_end_before_ack SIGNAL start_ddl_2 WAIT_FOR resume_clone_2';
68 SET DEBUG_SYNC = 'clone_before_file_ddl_meta SIGNAL start_ddl_3 WAIT_FOR resume_clone_3';
69 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_ddl_4 WAIT_FOR resume_clone_4';
70 SET DEBUG_SYNC = 'clone_before_page_ddl_meta SIGNAL start_ddl_5 WAIT_FOR resume_clone_5';
71 SET DEBUG_SYNC = 'clone_redo_copy SIGNAL start_ddl_6 WAIT_FOR resume_clone_6';
72 SET GLOBAL clone_autotune_concurrency = OFF;
73 SET GLOBAL clone_max_concurrency = 8;
74 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
75 # In connection CON1
76 # Waiting for clone
77 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_0';
78 # Wait finished
79 TRUNCATE TABLE t1;
80 TRUNCATE TABLE t2;
81 CALL execute_dml(0, 0, 10, 10, 10, 0);
82 SET DEBUG_SYNC = 'now SIGNAL resume_clone_0';
83 # Waiting for clone
84 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_1';
85 # Wait finished
86 TRUNCATE TABLE t1;
87 TRUNCATE TABLE t2;
88 CALL execute_dml(0, 0, 10, 10, 10, 0);
89 SET DEBUG_SYNC = 'now SIGNAL resume_clone_1';
90 # Waiting for clone
91 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_2';
92 # Wait finished
93 TRUNCATE TABLE t1;
94 TRUNCATE TABLE t2;
95 CALL execute_dml(0, 0, 10, 10, 10, 0);
96 SET DEBUG_SYNC = 'now SIGNAL resume_clone_2';
97 # Waiting for clone
98 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_3';
99 # Wait finished
100 TRUNCATE TABLE t1;
101 TRUNCATE TABLE t2;
102 CALL execute_dml(0, 0, 10, 10, 10, 0);
103 SET DEBUG_SYNC = 'now SIGNAL resume_clone_3';
104 # Waiting for clone
105 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_4';
106 # Wait finished
107 TRUNCATE TABLE t1;
108 TRUNCATE TABLE t2;
109 CALL execute_dml(0, 0, 10, 10, 10, 0);
110 SET DEBUG_SYNC = 'now SIGNAL resume_clone_4';
111 # Waiting for clone
112 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_5';
113 # Wait finished
114 TRUNCATE TABLE t1;
115 TRUNCATE TABLE t2;
116 CALL execute_dml(0, 0, 10, 10, 10, 0);
117 SET DEBUG_SYNC = 'now SIGNAL resume_clone_5';
118 # Waiting for clone
119 SET DEBUG_SYNC = 'now WAIT_FOR start_ddl_6';
120 # Wait finished
121 TRUNCATE TABLE t1;
122 TRUNCATE TABLE t2;
123 CALL execute_dml(0, 0, 10, 10, 10, 0);
124 SET DEBUG_SYNC = 'now SIGNAL resume_clone_6';
125 # In connection DEFAULT
126 # Waiting for clone to complete
127 # Wait finished
128 SET GLOBAL DEBUG = '-d,local_release_clone_file_pin';
129 SET DEBUG_SYNC = 'RESET';
130 # Restart cloned database
131 # restart: --datadir=CLONE_DATADIR
132 select STATE, ERROR_NO, length(BINLOG_FILE) > 0, length(GTID_EXECUTED) > 0,
133 (BINLOG_POSITION > 0) from performance_schema.clone_status;
134 STATE ERROR_NO length(BINLOG_FILE) > 0 length(GTID_EXECUTED) > 0 (BINLOG_POSITION > 0)
135 Completed 0 1 0 1
136 CALL execute_dml(3, 0, 1, 1, 1, 0);
137 CALL execute_dml(0, 0, 10, 10, 10, 0);
138 SHOW CREATE TABLE t1;
139 Table Create Table
140 t1 CREATE TABLE `t1` (
141 `col1` int NOT NULL,
142 `col2` int DEFAULT NULL,
143 `col3` varchar(64) DEFAULT NULL,
144 `col4` blob,
145 PRIMARY KEY (`col1`)
146 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
147 SELECT count(*) from t1;
148 count(*)
149 10
150 SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;
151 col1 col2 col3
152 0 0 Clone Test Row - 0
153 1 10 Clone Test Row - 1
154 2 20 Clone Test Row - 2
155 3 30 Clone Test Row - 3
156 4 40 Clone Test Row - 4
157 5 50 Clone Test Row - 5
158 6 60 Clone Test Row - 6
159 7 70 Clone Test Row - 7
160 8 80 Clone Test Row - 8
161 9 90 Clone Test Row - 9
162 SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;
163 col1 col2 col3
164 9 90 Clone Test Row - 9
165 8 80 Clone Test Row - 8
166 7 70 Clone Test Row - 7
167 6 60 Clone Test Row - 6
168 5 50 Clone Test Row - 5
169 4 40 Clone Test Row - 4
170 3 30 Clone Test Row - 3
171 2 20 Clone Test Row - 2
172 1 10 Clone Test Row - 1
173 0 0 Clone Test Row - 0
174 SHOW CREATE TABLE t2;
175 Table Create Table
176 t2 CREATE TABLE `t2` (
177 `col1` int NOT NULL,
178 `col2` int DEFAULT NULL,
179 `col3` varchar(64) DEFAULT NULL,
180 `col4` blob,
181 PRIMARY KEY (`col1`)
182 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
183 /*!50100 PARTITION BY KEY (col1)
184 PARTITIONS 5 */
185 SELECT count(*) from t2;
186 count(*)
187 10
188 SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;
189 col1 col2 col3
190 0 0 Clone Test Row - 0
191 1 10 Clone Test Row - 1
192 2 20 Clone Test Row - 2
193 3 30 Clone Test Row - 3
194 4 40 Clone Test Row - 4
195 5 50 Clone Test Row - 5
196 6 60 Clone Test Row - 6
197 7 70 Clone Test Row - 7
198 8 80 Clone Test Row - 8
199 9 90 Clone Test Row - 9
200 SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;
201 col1 col2 col3
202 9 90 Clone Test Row - 9
203 8 80 Clone Test Row - 8
204 7 70 Clone Test Row - 7
205 6 60 Clone Test Row - 6
206 5 50 Clone Test Row - 5
207 4 40 Clone Test Row - 4
208 3 30 Clone Test Row - 3
209 2 20 Clone Test Row - 2
210 1 10 Clone Test Row - 1
211 0 0 Clone Test Row - 0
212 # Cleanup
213 # restart:
214 DROP TABLE t1;
215 DROP TABLE t2;
216 DROP PROCEDURE execute_dml;
217 # Uninstall clone
218 UNINSTALL PLUGIN clone;