Debian Codegraph @

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

raw
1 set sort_buffer_size=1048576;
2 call mtr.add_suppression("\\[ERROR\\] .*MY-\\d+.* The redo log archiver is aborted as it was lagging behind at LSN = .*");
3 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
4 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
5 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
6 PARTITION BY KEY(col1) PARTITIONS 5;
7 CREATE PROCEDURE execute_dml(
8 p_dml_type INT,
9 p_key_min INT,
10 p_key_range INT,
11 p_loop_count INT,
12 p_frequency INT,
13 p_is_rand INT)
14 BEGIN
15 DECLARE v_idx INT DEFAULT 0;
16 DECLARE v_commit INT DEFAULT 0;
17 DECLARE v_key INT DEFAULT 0;
18 /* Loop and INSERT data at random position */
19 WHILE(v_idx < p_loop_count) DO
20 /* Generate key between 1 to p_loop_count */
21 IF p_is_rand = 1 THEN
22 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
23 ELSE
24 SET v_key = p_key_min + (v_idx % p_key_range);
25 END IF;
26 CASE p_dml_type
27 WHEN 0 THEN
28 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
29 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
30 v_key, v_key * 10,
31 @clol3_text, REPEAT('Large Column Data ', 2048))
32 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
33 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
34 v_key, v_key * 10,
35 @clol3_text, REPEAT('Large Column Data ', 2048))
36 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
37 WHEN 1 THEN
38 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
39 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
40 WHEN 2 THEN
41 DELETE FROM t1 WHERE col1 = v_key;
42 DELETE FROM t2 WHERE col1 = v_key;
43 ELSE
44 DELETE FROM t1;
45 DELETE FROM t2;
46 END CASE;
47 SET v_idx = v_idx + 1;
48 /* Commit or rollback work at specified frequency. */
49 IF v_idx % p_frequency = 0 THEN
50 SET v_commit = FLOOR(RAND() * 2);
51 IF v_commit = 0 AND p_is_rand = 1 THEN
52 ROLLBACK;
53 START TRANSACTION;
54 ELSE
55 COMMIT;
56 START TRANSACTION;
57 END IF;
58 END IF;
59 END WHILE;
60 COMMIT;
61 END|
62 call execute_dml(0, 0, 100, 100, 10, 0);
63 SHOW CREATE TABLE t1;
64 Table Create Table
65 t1 CREATE TABLE `t1` (
66 `col1` int NOT NULL,
67 `col2` int DEFAULT NULL,
68 `col3` varchar(64) DEFAULT NULL,
69 `col4` blob,
70 PRIMARY KEY (`col1`)
71 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
72 SELECT count(*) from t1;
73 count(*)
74 100
75 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
76 col1 col2 col3 SUBSTRING(col4, 1000, 32)
77 0 0 Clone Test Row - 0 umn Data Large Column Data Large
78 1 10 Clone Test Row - 1 umn Data Large Column Data Large
79 2 20 Clone Test Row - 2 umn Data Large Column Data Large
80 3 30 Clone Test Row - 3 umn Data Large Column Data Large
81 4 40 Clone Test Row - 4 umn Data Large Column Data Large
82 5 50 Clone Test Row - 5 umn Data Large Column Data Large
83 6 60 Clone Test Row - 6 umn Data Large Column Data Large
84 7 70 Clone Test Row - 7 umn Data Large Column Data Large
85 8 80 Clone Test Row - 8 umn Data Large Column Data Large
86 9 90 Clone Test Row - 9 umn Data Large Column Data Large
87 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
88 col1 col2 col3 SUBSTRING(col4, 1000, 32)
89 99 990 Clone Test Row - 99 umn Data Large Column Data Large
90 98 980 Clone Test Row - 98 umn Data Large Column Data Large
91 97 970 Clone Test Row - 97 umn Data Large Column Data Large
92 96 960 Clone Test Row - 96 umn Data Large Column Data Large
93 95 950 Clone Test Row - 95 umn Data Large Column Data Large
94 94 940 Clone Test Row - 94 umn Data Large Column Data Large
95 93 930 Clone Test Row - 93 umn Data Large Column Data Large
96 92 920 Clone Test Row - 92 umn Data Large Column Data Large
97 91 910 Clone Test Row - 91 umn Data Large Column Data Large
98 90 900 Clone Test Row - 90 umn Data Large Column Data Large
99 SHOW CREATE TABLE t2;
100 Table Create Table
101 t2 CREATE TABLE `t2` (
102 `col1` int NOT NULL,
103 `col2` int DEFAULT NULL,
104 `col3` varchar(64) DEFAULT NULL,
105 `col4` blob,
106 PRIMARY KEY (`col1`)
107 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
108 /*!50100 PARTITION BY KEY (col1)
109 PARTITIONS 5 */
110 SELECT count(*) from t2;
111 count(*)
112 100
113 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
114 col1 col2 col3 SUBSTRING(col4, 1000, 32)
115 0 0 Clone Test Row - 0 umn Data Large Column Data Large
116 1 10 Clone Test Row - 1 umn Data Large Column Data Large
117 2 20 Clone Test Row - 2 umn Data Large Column Data Large
118 3 30 Clone Test Row - 3 umn Data Large Column Data Large
119 4 40 Clone Test Row - 4 umn Data Large Column Data Large
120 5 50 Clone Test Row - 5 umn Data Large Column Data Large
121 6 60 Clone Test Row - 6 umn Data Large Column Data Large
122 7 70 Clone Test Row - 7 umn Data Large Column Data Large
123 8 80 Clone Test Row - 8 umn Data Large Column Data Large
124 9 90 Clone Test Row - 9 umn Data Large Column Data Large
125 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
126 col1 col2 col3 SUBSTRING(col4, 1000, 32)
127 99 990 Clone Test Row - 99 umn Data Large Column Data Large
128 98 980 Clone Test Row - 98 umn Data Large Column Data Large
129 97 970 Clone Test Row - 97 umn Data Large Column Data Large
130 96 960 Clone Test Row - 96 umn Data Large Column Data Large
131 95 950 Clone Test Row - 95 umn Data Large Column Data Large
132 94 940 Clone Test Row - 94 umn Data Large Column Data Large
133 93 930 Clone Test Row - 93 umn Data Large Column Data Large
134 92 920 Clone Test Row - 92 umn Data Large Column Data Large
135 91 910 Clone Test Row - 91 umn Data Large Column Data Large
136 90 900 Clone Test Row - 90 umn Data Large Column Data Large
137 # Test-1: Error during redo archival
138 # In connection default - Cloning database
139 SET GLOBAL DEBUG = '+d,clone_redo_archive_error';
140 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
141 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
142 SET GLOBAL clone_autotune_concurrency = OFF;
143 SET GLOBAL clone_max_concurrency = 8;
144 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
145 # In connection con1 - Running Update Random [0 - 100 Key Range]
146 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
147 START TRANSACTION;
148 CALL execute_dml(1, 0, 100, 500, 50, 1);
149 COMMIT;
150 # Flush all dirty buffers
151 SET GLOBAL innodb_buf_flush_list_now = 1;
152 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
153 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
154 START TRANSACTION;
155 CALL execute_dml(1, 0, 100, 300, 50, 1);
156 COMMIT;
157 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
158 # In connection default - Cloning database
159 ERROR HY000: Internal error: Clone: Log Archiver failed
160 SET GLOBAL DEBUG = '-d,clone_redo_archive_error';
161 SET DEBUG_SYNC = 'RESET';
162 # Test-2: Error overwrite redo archival data
163 # In connection default - Cloning database
164 SET GLOBAL DEBUG = '+d,clone_redo_no_archive';
165 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
166 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
167 SET GLOBAL clone_autotune_concurrency = OFF;
168 SET GLOBAL clone_max_concurrency = 8;
169 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
170 # In connection con1 - Delete all rows
171 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
172 START TRANSACTION;
173 call execute_dml(3, 0, 1, 1, 1, 0);
174 COMMIT;
175 # Flush all dirty buffers
176 SET GLOBAL innodb_buf_flush_list_now = 1;
177 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
178 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
179 # In connection con1 - Insert 200 rows
180 call execute_dml(0, 0, 200, 200, 10, 0);
181 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
182 # In connection default - Cloning database
183 ERROR HY000: Internal error: Clone: Log Archiver failed
184 SET GLOBAL DEBUG = '-d,clone_redo_no_archive';
185 SET DEBUG_SYNC = 'RESET';
186 # Test-3: Successful clone after archival error
187 # In connection default - Cloning database
188 SET DEBUG_SYNC = 'clone_file_copy SIGNAL start_dml1 WAIT_FOR resume_clone1';
189 SET DEBUG_SYNC = 'clone_page_copy SIGNAL start_dml2 WAIT_FOR resume_clone2';
190 SET GLOBAL clone_autotune_concurrency = OFF;
191 SET GLOBAL clone_max_concurrency = 8;
192 CLONE LOCAL DATA DIRECTORY = 'CLONE_DATADIR';
193 # In connection con1 - Running Update Random [0 - 100 Key Range]
194 SET DEBUG_SYNC = 'now WAIT_FOR start_dml1';
195 START TRANSACTION;
196 CALL execute_dml(1, 0, 100, 500, 50, 1);
197 COMMIT;
198 # Flush all dirty buffers
199 SET GLOBAL innodb_buf_flush_list_now = 1;
200 SET DEBUG_SYNC = 'now SIGNAL resume_clone1';
201 SET DEBUG_SYNC = 'now WAIT_FOR start_dml2';
202 START TRANSACTION;
203 CALL execute_dml(1, 0, 100, 300, 50, 1);
204 COMMIT;
205 SET DEBUG_SYNC = 'now SIGNAL resume_clone2';
206 # In connection default - Cloning database
207 SET DEBUG_SYNC = 'RESET';
208 # Restart cloned database
209 # restart: --datadir=CLONE_DATADIR
210 SHOW CREATE TABLE t1;
211 Table Create Table
212 t1 CREATE TABLE `t1` (
213 `col1` int NOT NULL,
214 `col2` int DEFAULT NULL,
215 `col3` varchar(64) DEFAULT NULL,
216 `col4` blob,
217 PRIMARY KEY (`col1`)
218 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
219 SELECT count(*) from t1;
220 count(*)
221 200
222 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
223 col1 col3 SUBSTRING(col4, 1000, 32)
224 0 Clone Test Row - 0 umn Data Large Column Data Large
225 1 Clone Test Row - 1 umn Data Large Column Data Large
226 2 Clone Test Row - 2 umn Data Large Column Data Large
227 3 Clone Test Row - 3 umn Data Large Column Data Large
228 4 Clone Test Row - 4 umn Data Large Column Data Large
229 5 Clone Test Row - 5 umn Data Large Column Data Large
230 6 Clone Test Row - 6 umn Data Large Column Data Large
231 7 Clone Test Row - 7 umn Data Large Column Data Large
232 8 Clone Test Row - 8 umn Data Large Column Data Large
233 9 Clone Test Row - 9 umn Data Large Column Data Large
234 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
235 col1 col3 SUBSTRING(col4, 1000, 32)
236 199 Clone Test Row - 199 umn Data Large Column Data Large
237 198 Clone Test Row - 198 umn Data Large Column Data Large
238 197 Clone Test Row - 197 umn Data Large Column Data Large
239 196 Clone Test Row - 196 umn Data Large Column Data Large
240 195 Clone Test Row - 195 umn Data Large Column Data Large
241 194 Clone Test Row - 194 umn Data Large Column Data Large
242 193 Clone Test Row - 193 umn Data Large Column Data Large
243 192 Clone Test Row - 192 umn Data Large Column Data Large
244 191 Clone Test Row - 191 umn Data Large Column Data Large
245 190 Clone Test Row - 190 umn Data Large Column Data Large
246 SHOW CREATE TABLE t2;
247 Table Create Table
248 t2 CREATE TABLE `t2` (
249 `col1` int NOT NULL,
250 `col2` int DEFAULT NULL,
251 `col3` varchar(64) DEFAULT NULL,
252 `col4` blob,
253 PRIMARY KEY (`col1`)
254 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
255 /*!50100 PARTITION BY KEY (col1)
256 PARTITIONS 5 */
257 SELECT count(*) from t2;
258 count(*)
259 200
260 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
261 col1 col3 SUBSTRING(col4, 1000, 32)
262 0 Clone Test Row - 0 umn Data Large Column Data Large
263 1 Clone Test Row - 1 umn Data Large Column Data Large
264 2 Clone Test Row - 2 umn Data Large Column Data Large
265 3 Clone Test Row - 3 umn Data Large Column Data Large
266 4 Clone Test Row - 4 umn Data Large Column Data Large
267 5 Clone Test Row - 5 umn Data Large Column Data Large
268 6 Clone Test Row - 6 umn Data Large Column Data Large
269 7 Clone Test Row - 7 umn Data Large Column Data Large
270 8 Clone Test Row - 8 umn Data Large Column Data Large
271 9 Clone Test Row - 9 umn Data Large Column Data Large
272 SELECT col1, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
273 col1 col3 SUBSTRING(col4, 1000, 32)
274 199 Clone Test Row - 199 umn Data Large Column Data Large
275 198 Clone Test Row - 198 umn Data Large Column Data Large
276 197 Clone Test Row - 197 umn Data Large Column Data Large
277 196 Clone Test Row - 196 umn Data Large Column Data Large
278 195 Clone Test Row - 195 umn Data Large Column Data Large
279 194 Clone Test Row - 194 umn Data Large Column Data Large
280 193 Clone Test Row - 193 umn Data Large Column Data Large
281 192 Clone Test Row - 192 umn Data Large Column Data Large
282 191 Clone Test Row - 191 umn Data Large Column Data Large
283 190 Clone Test Row - 190 umn Data Large Column Data Large
284 call execute_dml(3, 0, 1, 1, 1, 0);
285 call execute_dml(0, 0, 100, 100, 10, 0);
286 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 LIMIT 10;
287 col1 col2 col3 SUBSTRING(col4, 1000, 32)
288 0 0 Clone Test Row - 0 umn Data Large Column Data Large
289 1 10 Clone Test Row - 1 umn Data Large Column Data Large
290 2 20 Clone Test Row - 2 umn Data Large Column Data Large
291 3 30 Clone Test Row - 3 umn Data Large Column Data Large
292 4 40 Clone Test Row - 4 umn Data Large Column Data Large
293 5 50 Clone Test Row - 5 umn Data Large Column Data Large
294 6 60 Clone Test Row - 6 umn Data Large Column Data Large
295 7 70 Clone Test Row - 7 umn Data Large Column Data Large
296 8 80 Clone Test Row - 8 umn Data Large Column Data Large
297 9 90 Clone Test Row - 9 umn Data Large Column Data Large
298 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t1 ORDER BY col1 DESC LIMIT 10;
299 col1 col2 col3 SUBSTRING(col4, 1000, 32)
300 99 990 Clone Test Row - 99 umn Data Large Column Data Large
301 98 980 Clone Test Row - 98 umn Data Large Column Data Large
302 97 970 Clone Test Row - 97 umn Data Large Column Data Large
303 96 960 Clone Test Row - 96 umn Data Large Column Data Large
304 95 950 Clone Test Row - 95 umn Data Large Column Data Large
305 94 940 Clone Test Row - 94 umn Data Large Column Data Large
306 93 930 Clone Test Row - 93 umn Data Large Column Data Large
307 92 920 Clone Test Row - 92 umn Data Large Column Data Large
308 91 910 Clone Test Row - 91 umn Data Large Column Data Large
309 90 900 Clone Test Row - 90 umn Data Large Column Data Large
310 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 LIMIT 10;
311 col1 col2 col3 SUBSTRING(col4, 1000, 32)
312 0 0 Clone Test Row - 0 umn Data Large Column Data Large
313 1 10 Clone Test Row - 1 umn Data Large Column Data Large
314 2 20 Clone Test Row - 2 umn Data Large Column Data Large
315 3 30 Clone Test Row - 3 umn Data Large Column Data Large
316 4 40 Clone Test Row - 4 umn Data Large Column Data Large
317 5 50 Clone Test Row - 5 umn Data Large Column Data Large
318 6 60 Clone Test Row - 6 umn Data Large Column Data Large
319 7 70 Clone Test Row - 7 umn Data Large Column Data Large
320 8 80 Clone Test Row - 8 umn Data Large Column Data Large
321 9 90 Clone Test Row - 9 umn Data Large Column Data Large
322 SELECT col1, col2, col3, SUBSTRING(col4, 1000, 32) FROM t2 ORDER BY col1 DESC LIMIT 10;
323 col1 col2 col3 SUBSTRING(col4, 1000, 32)
324 99 990 Clone Test Row - 99 umn Data Large Column Data Large
325 98 980 Clone Test Row - 98 umn Data Large Column Data Large
326 97 970 Clone Test Row - 97 umn Data Large Column Data Large
327 96 960 Clone Test Row - 96 umn Data Large Column Data Large
328 95 950 Clone Test Row - 95 umn Data Large Column Data Large
329 94 940 Clone Test Row - 94 umn Data Large Column Data Large
330 93 930 Clone Test Row - 93 umn Data Large Column Data Large
331 92 920 Clone Test Row - 92 umn Data Large Column Data Large
332 91 910 Clone Test Row - 91 umn Data Large Column Data Large
333 90 900 Clone Test Row - 90 umn Data Large Column Data Large
334 # restart:
335 DROP TABLE t1;
336 DROP TABLE t2;
337 DROP PROCEDURE execute_dml;
338 UNINSTALL PLUGIN clone;
339 SET DEBUG_SYNC = 'RESET';
340 set sort_buffer_size=DEFAULT;