Debian Codegraph @

mysql-test/suite/clone/r/ddl_rename.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. ALTER TABLE RENAME while clone in progress
76 RESET MASTER;
77 SET GLOBAL DEBUG = '+d,local_release_clone_file_pin';
78 ALTER TABLE t0 RENAME t0_new;
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 ALTER TABLE t01 RENAME t01_new;
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 ALTER TABLE t1 RENAME t1_new;
99 INSERT INTO t1_new SELECT * FROM t ON DUPLICATE KEY UPDATE col2 = t1_new.col2 + 1;;
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 ALTER TABLE t11 RENAME t11_new;
109 INSERT INTO t11_new SELECT * FROM t ON DUPLICATE KEY UPDATE col2 = t11_new.col2 + 1;;
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 ALTER TABLE t2 RENAME t2_new;
115 INSERT INTO t2_new SELECT * FROM t ON DUPLICATE KEY UPDATE col2 = t2_new.col2 + 1;;
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 ALTER TABLE t21 RENAME t21_new;
121 INSERT INTO t21_new SELECT * FROM t ON DUPLICATE KEY UPDATE col2 = t21_new.col2 + 1;;
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 ALTER TABLE t3 RENAME t3_new;
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 t01_new
139 t0_new
140 t11_new
141 t1_new
142 t21
143 t2_new
144 t3
145 SHOW CREATE TABLE t1_new;
146 Table Create Table
147 t1_new CREATE TABLE `t1_new` (
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_new EXTENDED;
155 Table Op Msg_type Msg_text
156 test.t1_new check status OK
157 SELECT count(*) from t1_new;
158 count(*)
159 100
160 SELECT col1, col2, col3 FROM t1_new ORDER BY col1 LIMIT 10;;
161 col1 col2 col3
162 0 1 Clone Test Row - 0
163 1 11 Clone Test Row - 1
164 2 21 Clone Test Row - 2
165 3 31 Clone Test Row - 3
166 4 41 Clone Test Row - 4
167 5 51 Clone Test Row - 5
168 6 61 Clone Test Row - 6
169 7 71 Clone Test Row - 7
170 8 81 Clone Test Row - 8
171 9 91 Clone Test Row - 9
172 SELECT col1, col2, col3 FROM t1_new ORDER BY col1 DESC LIMIT 10;;
173 col1 col2 col3
174 99 991 Clone Test Row - 99
175 98 981 Clone Test Row - 98
176 97 971 Clone Test Row - 97
177 96 961 Clone Test Row - 96
178 95 951 Clone Test Row - 95
179 94 941 Clone Test Row - 94
180 93 931 Clone Test Row - 93
181 92 921 Clone Test Row - 92
182 91 911 Clone Test Row - 91
183 90 901 Clone Test Row - 90
184 SHOW CREATE TABLE t11_new;
185 Table Create Table
186 t11_new CREATE TABLE `t11_new` (
187 `col1` int NOT NULL,
188 `col2` int DEFAULT NULL,
189 `col3` varchar(64) DEFAULT NULL,
190 `col4` blob,
191 PRIMARY KEY (`col1`)
192 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
193 CHECK TABLE t11_new EXTENDED;
194 Table Op Msg_type Msg_text
195 test.t11_new check status OK
196 SELECT count(*) from t11_new;
197 count(*)
198 100
199 SELECT col1, col2, col3 FROM t11_new ORDER BY col1 LIMIT 10;;
200 col1 col2 col3
201 0 1 Clone Test Row - 0
202 1 11 Clone Test Row - 1
203 2 21 Clone Test Row - 2
204 3 31 Clone Test Row - 3
205 4 41 Clone Test Row - 4
206 5 51 Clone Test Row - 5
207 6 61 Clone Test Row - 6
208 7 71 Clone Test Row - 7
209 8 81 Clone Test Row - 8
210 9 91 Clone Test Row - 9
211 SELECT col1, col2, col3 FROM t11_new ORDER BY col1 DESC LIMIT 10;;
212 col1 col2 col3
213 99 991 Clone Test Row - 99
214 98 981 Clone Test Row - 98
215 97 971 Clone Test Row - 97
216 96 961 Clone Test Row - 96
217 95 951 Clone Test Row - 95
218 94 941 Clone Test Row - 94
219 93 931 Clone Test Row - 93
220 92 921 Clone Test Row - 92
221 91 911 Clone Test Row - 91
222 90 901 Clone Test Row - 90
223 SHOW CREATE TABLE t2_new;
224 Table Create Table
225 t2_new CREATE TABLE `t2_new` (
226 `col1` int NOT NULL,
227 `col2` int DEFAULT NULL,
228 `col3` varchar(64) DEFAULT NULL,
229 `col4` blob,
230 PRIMARY KEY (`col1`)
231 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
232 /*!50100 PARTITION BY KEY (col1)
233 PARTITIONS 5 */
234 CHECK TABLE t2_new EXTENDED;
235 Table Op Msg_type Msg_text
236 test.t2_new check status OK
237 SELECT count(*) from t2_new;
238 count(*)
239 100
240 SELECT col1, col2, col3 FROM t2_new ORDER BY col1 LIMIT 10;;
241 col1 col2 col3
242 0 1 Clone Test Row - 0
243 1 11 Clone Test Row - 1
244 2 21 Clone Test Row - 2
245 3 31 Clone Test Row - 3
246 4 41 Clone Test Row - 4
247 5 51 Clone Test Row - 5
248 6 61 Clone Test Row - 6
249 7 71 Clone Test Row - 7
250 8 81 Clone Test Row - 8
251 9 91 Clone Test Row - 9
252 SELECT col1, col2, col3 FROM t2_new ORDER BY col1 DESC LIMIT 10;;
253 col1 col2 col3
254 99 991 Clone Test Row - 99
255 98 981 Clone Test Row - 98
256 97 971 Clone Test Row - 97
257 96 961 Clone Test Row - 96
258 95 951 Clone Test Row - 95
259 94 941 Clone Test Row - 94
260 93 931 Clone Test Row - 93
261 92 921 Clone Test Row - 92
262 91 911 Clone Test Row - 91
263 90 901 Clone Test Row - 90
264 # Restart server back on base data directory
265 # restart:
266 SET DEBUG_SYNC = 'RESET';
267 # Cleanup
268 DROP TABLE t;
269 CREATE TABLE t1 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
270 CREATE TABLE t2 (col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
271 DROP TABLE t1;
272 DROP TABLE t2;
273 DROP PROCEDURE execute_dml;
274 DROP TABLE t0_new;
275 DROP TABLE t01_new;
276 DROP TABLE t1_new;
277 DROP TABLE t2_new;
278 DROP TABLE t3_new;
279 DROP TABLE t11_new;
280 DROP TABLE t21_new;
281 # Uninstall clone
282 UNINSTALL PLUGIN clone;