Debian Codegraph @

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

raw
1 Install clone plugin on recipient server
2 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
3 CREATE TABLE t_recipient(col1 INT PRIMARY KEY, col2 int);
4 INSERT INTO t_recipient VALUES(1, 10);
5 CREATE UNDO TABLESPACE undo_005 ADD DATAFILE 'undo_005.ibu';
6 CREATE TABLESPACE tbs1_recipient ADD DATAFILE 'tbs1_data1.ibd';
7 # Install clone plugin
8 INSTALL PLUGIN clone SONAME 'CLONE_PLUGIN';
9 ## Create test schema
10 CREATE TABLE t1(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB);
11 CREATE TABLE t2(col1 INT PRIMARY KEY, col2 int, col3 varchar(64), col4 BLOB)
12 PARTITION BY KEY(col1) PARTITIONS 5;
13 CREATE PROCEDURE execute_dml(
14 p_dml_type INT,
15 p_key_min INT,
16 p_key_range INT,
17 p_loop_count INT,
18 p_frequency INT,
19 p_is_rand INT)
20 BEGIN
21 DECLARE v_idx INT DEFAULT 0;
22 DECLARE v_commit INT DEFAULT 0;
23 DECLARE v_key INT DEFAULT 0;
24 /* Loop and INSERT data at random position */
25 WHILE(v_idx < p_loop_count) DO
26 /* Generate key between 1 to p_loop_count */
27 IF p_is_rand = 1 THEN
28 SET v_key = p_key_min + FLOOR(RAND() * p_key_range);
29 ELSE
30 SET v_key = p_key_min + (v_idx % p_key_range);
31 END IF;
32 CASE p_dml_type
33 WHEN 0 THEN
34 SET @clol3_text = CONCAT('Clone Test Row - ', v_key);
35 INSERT INTO t1 (col1, col2, col3, col4) VALUES (
36 v_key, v_key * 10,
37 @clol3_text, REPEAT('Large Column Data ', 2048))
38 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
39 INSERT INTO t2 (col1, col2, col3, col4) VALUES (
40 v_key, v_key * 10,
41 @clol3_text, REPEAT('Large Column Data ', 2048))
42 ON DUPLICATE KEY UPDATE col2 = col2 + 1;
43 WHEN 1 THEN
44 UPDATE t1 SET col2 = v_idx + 1 WHERE col1 = v_key;
45 UPDATE t2 SET col2 = v_idx + 1 WHERE col1 = v_key;
46 WHEN 2 THEN
47 DELETE FROM t1 WHERE col1 = v_key;
48 DELETE FROM t2 WHERE col1 = v_key;
49 ELSE
50 DELETE FROM t1;
51 DELETE FROM t2;
52 END CASE;
53 SET v_idx = v_idx + 1;
54 /* Commit or rollback work at specified frequency. */
55 IF v_idx % p_frequency = 0 THEN
56 SET v_commit = FLOOR(RAND() * 2);
57 IF v_commit = 0 AND p_is_rand = 1 THEN
58 ROLLBACK;
59 START TRANSACTION;
60 ELSE
61 COMMIT;
62 START TRANSACTION;
63 END IF;
64 END IF;
65 END WHILE;
66 COMMIT;
67 END|
68 # Insert rows
69 call execute_dml(0, 0, 100, 100, 10, 0);
70 # Check base rows
71 SHOW CREATE TABLE t1;
72 Table Create Table
73 t1 CREATE TABLE `t1` (
74 `col1` int NOT NULL,
75 `col2` int DEFAULT NULL,
76 `col3` varchar(64) DEFAULT NULL,
77 `col4` blob,
78 PRIMARY KEY (`col1`)
79 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
80 SELECT count(*) from t1;
81 count(*)
82 100
83 SELECT col1, col2, col3 FROM t1 ORDER BY col1 LIMIT 10;
84 col1 col2 col3
85 0 0 Clone Test Row - 0
86 1 10 Clone Test Row - 1
87 2 20 Clone Test Row - 2
88 3 30 Clone Test Row - 3
89 4 40 Clone Test Row - 4
90 5 50 Clone Test Row - 5
91 6 60 Clone Test Row - 6
92 7 70 Clone Test Row - 7
93 8 80 Clone Test Row - 8
94 9 90 Clone Test Row - 9
95 SELECT col1, col2, col3 FROM t1 ORDER BY col1 DESC LIMIT 10;
96 col1 col2 col3
97 99 990 Clone Test Row - 99
98 98 980 Clone Test Row - 98
99 97 970 Clone Test Row - 97
100 96 960 Clone Test Row - 96
101 95 950 Clone Test Row - 95
102 94 940 Clone Test Row - 94
103 93 930 Clone Test Row - 93
104 92 920 Clone Test Row - 92
105 91 910 Clone Test Row - 91
106 90 900 Clone Test Row - 90
107 SHOW CREATE TABLE t2;
108 Table Create Table
109 t2 CREATE TABLE `t2` (
110 `col1` int NOT NULL,
111 `col2` int DEFAULT NULL,
112 `col3` varchar(64) DEFAULT NULL,
113 `col4` blob,
114 PRIMARY KEY (`col1`)
115 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
116 /*!50100 PARTITION BY KEY (col1)
117 PARTITIONS 5 */
118 SELECT count(*) from t2;
119 count(*)
120 100
121 SELECT col1, col2, col3 FROM t2 ORDER BY col1 LIMIT 10;
122 col1 col2 col3
123 0 0 Clone Test Row - 0
124 1 10 Clone Test Row - 1
125 2 20 Clone Test Row - 2
126 3 30 Clone Test Row - 3
127 4 40 Clone Test Row - 4
128 5 50 Clone Test Row - 5
129 6 60 Clone Test Row - 6
130 7 70 Clone Test Row - 7
131 8 80 Clone Test Row - 8
132 9 90 Clone Test Row - 9
133 SELECT col1, col2, col3 FROM t2 ORDER BY col1 DESC LIMIT 10;
134 col1 col2 col3
135 99 990 Clone Test Row - 99
136 98 980 Clone Test Row - 98
137 97 970 Clone Test Row - 97
138 96 960 Clone Test Row - 96
139 95 950 Clone Test Row - 95
140 94 940 Clone Test Row - 94
141 93 930 Clone Test Row - 93
142 92 920 Clone Test Row - 92
143 91 910 Clone Test Row - 91
144 90 900 Clone Test Row - 90
145 # In connection con1 - Running Insert Random [100 - 200 Key range]
146 call execute_dml(0, 100, 100, 100, 20, 1);
147 # In connection con2 - Running Update Random [0 - 25 Key Range]
148 call execute_dml(1, 0, 25, 100, 20, 1);
149 # In connection default - Cloning database
150 SET global debug="+d,clone_recovery_crash_point";
151 SET GLOBAL clone_autotune_concurrency = OFF;
152 SET GLOBAL clone_max_concurrency = 8;
153 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
154 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
155 select ID, STATE, ERROR_NO, ERROR_MESSAGE from performance_schema.clone_status;
156 ID STATE ERROR_NO ERROR_MESSAGE
157 1 Failed 1815 Recovery failed. Please Retry Clone. For details, look into server error log.
158 select ID, STAGE, STATE from performance_schema.clone_progress;
159 ID STAGE STATE
160 1 DROP DATA Completed
161 1 FILE COPY Completed
162 1 PAGE COPY Completed
163 1 REDO COPY Completed
164 1 FILE SYNC Completed
165 1 RESTART Completed
166 1 RECOVERY Failed
167 SET global debug="-d,clone_recovery_crash_point";
168 # In connection default - Finished Cloning
169 # In connection con1 - Waiting
170 # In connection con2 - Waiting
171 # In connection default
172 SHOW SCHEMAS;
173 Database
174 information_schema
175 mysql
176 performance_schema
177 sys
178 DROP TABLE t1;
179 DROP TABLE t2;
180 DROP PROCEDURE execute_dml;
181 # Cleanup
182 SET GLOBAL clone_autotune_concurrency = OFF;
183 SET GLOBAL clone_max_concurrency = 8;
184 SET GLOBAL clone_valid_donor_list = 'HOST:PORT';
185 CLONE INSTANCE FROM USER@HOST:PORT IDENTIFIED BY '' ;
186 select ID, STATE, ERROR_NO from performance_schema.clone_status;
187 ID STATE ERROR_NO
188 1 Completed 0
189 select ID, STAGE, STATE from performance_schema.clone_progress;
190 ID STAGE STATE
191 1 DROP DATA Completed
192 1 FILE COPY Completed
193 1 PAGE COPY Completed
194 1 REDO COPY Completed
195 1 FILE SYNC Completed
196 1 RESTART Completed
197 1 RECOVERY Completed
198 Uninstall clone plugin on recipient server
199 UNINSTALL PLUGIN clone;
200 UNINSTALL PLUGIN clone;