Debian Codegraph @

mysql-test/suite/rpl/r/rpl_stm_mixed_mts_rec_crash_safe_small.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 call mtr.add_suppression('Attempting backtrace');
7 call mtr.add_suppression("Recovery from source pos .*");
8 call mtr.add_suppression(".* Warning: allocated tablespace .*, old maximum was .*");
9 ########################################################################
10 # SET UP
11 ########################################################################
12 'Small rpl_mts_crash_safe'
13 ==== begin rpl_mts_crash_safe.inc:configure ====
14 ---- begin configure database test_1 ----
15 rpl_mixing_engines.inc [commands=configure]
16 CREATE TABLE nt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
17 CREATE TABLE nt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
18 CREATE TABLE nt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
19 CREATE TABLE nt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
20 CREATE TABLE nt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
21 CREATE TABLE nt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
22 CREATE TABLE tt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
23 CREATE TABLE tt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
24 CREATE TABLE tt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
25 CREATE TABLE tt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
26 CREATE TABLE tt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
27 CREATE TABLE tt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
28 INSERT INTO nt_1(trans_id, stmt_id) VALUES(1,1);
29 INSERT INTO nt_2(trans_id, stmt_id) VALUES(1,1);
30 INSERT INTO nt_3(trans_id, stmt_id) VALUES(1,1);
31 INSERT INTO nt_4(trans_id, stmt_id) VALUES(1,1);
32 INSERT INTO nt_5(trans_id, stmt_id) VALUES(1,1);
33 INSERT INTO nt_6(trans_id, stmt_id) VALUES(1,1);
34 INSERT INTO tt_1(trans_id, stmt_id) VALUES(1,1);
35 INSERT INTO tt_2(trans_id, stmt_id) VALUES(1,1);
36 INSERT INTO tt_3(trans_id, stmt_id) VALUES(1,1);
37 INSERT INTO tt_4(trans_id, stmt_id) VALUES(1,1);
38 INSERT INTO tt_5(trans_id, stmt_id) VALUES(1,1);
39 INSERT INTO tt_6(trans_id, stmt_id) VALUES(1,1);
40 CREATE PROCEDURE pc_i_tt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
41 BEGIN
42 DECLARE in_stmt_id INTEGER;
43 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
44 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
45 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
46 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
47 END|
48 CREATE PROCEDURE pc_i_nt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
49 BEGIN
50 DECLARE in_stmt_id INTEGER;
51 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
52 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
53 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
54 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
55 END|
56 CREATE FUNCTION fc_i_tt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
57 BEGIN
58 DECLARE in_stmt_id INTEGER;
59 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
60 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
61 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
62 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
63 RETURN "fc_i_tt_5_suc";
64 END|
65 CREATE FUNCTION fc_i_nt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
66 BEGIN
67 DECLARE in_stmt_id INTEGER;
68 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
69 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
70 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
71 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
72 RETURN "fc_i_nt_5_suc";
73 END|
74 CREATE FUNCTION fc_i_nt_3_tt_3_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
75 BEGIN
76 DECLARE in_stmt_id INTEGER;
77 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= p_trans_id;
78 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
79 INSERT INTO nt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
80 SELECT max(stmt_id) INTO in_stmt_id FROM tt_3 WHERE trans_id= p_trans_id;
81 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
82 INSERT INTO tt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
83 RETURN "fc_i_nt_3_tt_3_suc";
84 END|
85 CREATE TRIGGER tr_i_tt_3_to_nt_3 AFTER INSERT ON tt_3 FOR EACH ROW
86 BEGIN
87 DECLARE in_stmt_id INTEGER;
88 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= NEW.trans_id;
89 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
90 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
91 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
92 END|
93 CREATE TRIGGER tr_i_nt_4_to_tt_4 AFTER INSERT ON nt_4 FOR EACH ROW
94 BEGIN
95 DECLARE in_stmt_id INTEGER;
96 SELECT max(stmt_id) INTO in_stmt_id FROM tt_4 WHERE trans_id= NEW.trans_id;
97 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
98 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
99 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
100 END|
101 CREATE TRIGGER tr_i_tt_5_to_tt_6 AFTER INSERT ON tt_5 FOR EACH ROW
102 BEGIN
103 DECLARE in_stmt_id INTEGER;
104 SELECT max(stmt_id) INTO in_stmt_id FROM tt_6 WHERE trans_id= NEW.trans_id;
105 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id, 1), 1) INTO in_stmt_id;
106 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
107 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
108 END|
109 CREATE TRIGGER tr_i_nt_5_to_nt_6 AFTER INSERT ON nt_5 FOR EACH ROW
110 BEGIN
111 DECLARE in_stmt_id INTEGER;
112 SELECT max(stmt_id) INTO in_stmt_id FROM nt_6 WHERE trans_id= NEW.trans_id;
113 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
114 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
115 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
116 END|
117 ---- end configure database test_1 ----
118 ---- begin configure database test_2 ----
119 rpl_mixing_engines.inc [commands=configure]
120 CREATE TABLE nt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
121 CREATE TABLE nt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
122 CREATE TABLE nt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
123 CREATE TABLE nt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
124 CREATE TABLE nt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
125 CREATE TABLE nt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
126 CREATE TABLE tt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
127 CREATE TABLE tt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
128 CREATE TABLE tt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
129 CREATE TABLE tt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
130 CREATE TABLE tt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
131 CREATE TABLE tt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
132 INSERT INTO nt_1(trans_id, stmt_id) VALUES(1,1);
133 INSERT INTO nt_2(trans_id, stmt_id) VALUES(1,1);
134 INSERT INTO nt_3(trans_id, stmt_id) VALUES(1,1);
135 INSERT INTO nt_4(trans_id, stmt_id) VALUES(1,1);
136 INSERT INTO nt_5(trans_id, stmt_id) VALUES(1,1);
137 INSERT INTO nt_6(trans_id, stmt_id) VALUES(1,1);
138 INSERT INTO tt_1(trans_id, stmt_id) VALUES(1,1);
139 INSERT INTO tt_2(trans_id, stmt_id) VALUES(1,1);
140 INSERT INTO tt_3(trans_id, stmt_id) VALUES(1,1);
141 INSERT INTO tt_4(trans_id, stmt_id) VALUES(1,1);
142 INSERT INTO tt_5(trans_id, stmt_id) VALUES(1,1);
143 INSERT INTO tt_6(trans_id, stmt_id) VALUES(1,1);
144 CREATE PROCEDURE pc_i_tt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
145 BEGIN
146 DECLARE in_stmt_id INTEGER;
147 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
148 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
149 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
150 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
151 END|
152 CREATE PROCEDURE pc_i_nt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
153 BEGIN
154 DECLARE in_stmt_id INTEGER;
155 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
156 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
157 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
158 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
159 END|
160 CREATE FUNCTION fc_i_tt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
161 BEGIN
162 DECLARE in_stmt_id INTEGER;
163 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
164 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
165 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
166 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
167 RETURN "fc_i_tt_5_suc";
168 END|
169 CREATE FUNCTION fc_i_nt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
170 BEGIN
171 DECLARE in_stmt_id INTEGER;
172 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
173 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
174 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
175 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
176 RETURN "fc_i_nt_5_suc";
177 END|
178 CREATE FUNCTION fc_i_nt_3_tt_3_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
179 BEGIN
180 DECLARE in_stmt_id INTEGER;
181 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= p_trans_id;
182 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
183 INSERT INTO nt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
184 SELECT max(stmt_id) INTO in_stmt_id FROM tt_3 WHERE trans_id= p_trans_id;
185 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
186 INSERT INTO tt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
187 RETURN "fc_i_nt_3_tt_3_suc";
188 END|
189 CREATE TRIGGER tr_i_tt_3_to_nt_3 AFTER INSERT ON tt_3 FOR EACH ROW
190 BEGIN
191 DECLARE in_stmt_id INTEGER;
192 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= NEW.trans_id;
193 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
194 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
195 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
196 END|
197 CREATE TRIGGER tr_i_nt_4_to_tt_4 AFTER INSERT ON nt_4 FOR EACH ROW
198 BEGIN
199 DECLARE in_stmt_id INTEGER;
200 SELECT max(stmt_id) INTO in_stmt_id FROM tt_4 WHERE trans_id= NEW.trans_id;
201 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
202 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
203 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
204 END|
205 CREATE TRIGGER tr_i_tt_5_to_tt_6 AFTER INSERT ON tt_5 FOR EACH ROW
206 BEGIN
207 DECLARE in_stmt_id INTEGER;
208 SELECT max(stmt_id) INTO in_stmt_id FROM tt_6 WHERE trans_id= NEW.trans_id;
209 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id, 1), 1) INTO in_stmt_id;
210 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
211 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
212 END|
213 CREATE TRIGGER tr_i_nt_5_to_nt_6 AFTER INSERT ON nt_5 FOR EACH ROW
214 BEGIN
215 DECLARE in_stmt_id INTEGER;
216 SELECT max(stmt_id) INTO in_stmt_id FROM nt_6 WHERE trans_id= NEW.trans_id;
217 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
218 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
219 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
220 END|
221 ---- end configure database test_2 ----
222 ---- begin configure database test_3 ----
223 rpl_mixing_engines.inc [commands=configure]
224 CREATE TABLE nt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
225 CREATE TABLE nt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
226 CREATE TABLE nt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
227 CREATE TABLE nt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
228 CREATE TABLE nt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
229 CREATE TABLE nt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
230 CREATE TABLE tt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
231 CREATE TABLE tt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
232 CREATE TABLE tt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
233 CREATE TABLE tt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
234 CREATE TABLE tt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
235 CREATE TABLE tt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
236 INSERT INTO nt_1(trans_id, stmt_id) VALUES(1,1);
237 INSERT INTO nt_2(trans_id, stmt_id) VALUES(1,1);
238 INSERT INTO nt_3(trans_id, stmt_id) VALUES(1,1);
239 INSERT INTO nt_4(trans_id, stmt_id) VALUES(1,1);
240 INSERT INTO nt_5(trans_id, stmt_id) VALUES(1,1);
241 INSERT INTO nt_6(trans_id, stmt_id) VALUES(1,1);
242 INSERT INTO tt_1(trans_id, stmt_id) VALUES(1,1);
243 INSERT INTO tt_2(trans_id, stmt_id) VALUES(1,1);
244 INSERT INTO tt_3(trans_id, stmt_id) VALUES(1,1);
245 INSERT INTO tt_4(trans_id, stmt_id) VALUES(1,1);
246 INSERT INTO tt_5(trans_id, stmt_id) VALUES(1,1);
247 INSERT INTO tt_6(trans_id, stmt_id) VALUES(1,1);
248 CREATE PROCEDURE pc_i_tt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
249 BEGIN
250 DECLARE in_stmt_id INTEGER;
251 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
252 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
253 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
254 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
255 END|
256 CREATE PROCEDURE pc_i_nt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
257 BEGIN
258 DECLARE in_stmt_id INTEGER;
259 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
260 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
261 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
262 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
263 END|
264 CREATE FUNCTION fc_i_tt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
265 BEGIN
266 DECLARE in_stmt_id INTEGER;
267 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
268 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
269 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
270 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
271 RETURN "fc_i_tt_5_suc";
272 END|
273 CREATE FUNCTION fc_i_nt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
274 BEGIN
275 DECLARE in_stmt_id INTEGER;
276 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
277 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
278 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
279 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
280 RETURN "fc_i_nt_5_suc";
281 END|
282 CREATE FUNCTION fc_i_nt_3_tt_3_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
283 BEGIN
284 DECLARE in_stmt_id INTEGER;
285 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= p_trans_id;
286 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
287 INSERT INTO nt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
288 SELECT max(stmt_id) INTO in_stmt_id FROM tt_3 WHERE trans_id= p_trans_id;
289 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
290 INSERT INTO tt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
291 RETURN "fc_i_nt_3_tt_3_suc";
292 END|
293 CREATE TRIGGER tr_i_tt_3_to_nt_3 AFTER INSERT ON tt_3 FOR EACH ROW
294 BEGIN
295 DECLARE in_stmt_id INTEGER;
296 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= NEW.trans_id;
297 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
298 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
299 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
300 END|
301 CREATE TRIGGER tr_i_nt_4_to_tt_4 AFTER INSERT ON nt_4 FOR EACH ROW
302 BEGIN
303 DECLARE in_stmt_id INTEGER;
304 SELECT max(stmt_id) INTO in_stmt_id FROM tt_4 WHERE trans_id= NEW.trans_id;
305 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
306 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
307 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
308 END|
309 CREATE TRIGGER tr_i_tt_5_to_tt_6 AFTER INSERT ON tt_5 FOR EACH ROW
310 BEGIN
311 DECLARE in_stmt_id INTEGER;
312 SELECT max(stmt_id) INTO in_stmt_id FROM tt_6 WHERE trans_id= NEW.trans_id;
313 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id, 1), 1) INTO in_stmt_id;
314 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
315 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
316 END|
317 CREATE TRIGGER tr_i_nt_5_to_nt_6 AFTER INSERT ON nt_5 FOR EACH ROW
318 BEGIN
319 DECLARE in_stmt_id INTEGER;
320 SELECT max(stmt_id) INTO in_stmt_id FROM nt_6 WHERE trans_id= NEW.trans_id;
321 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
322 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
323 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
324 END|
325 ---- end configure database test_3 ----
326 ---- begin configure database test_4 ----
327 rpl_mixing_engines.inc [commands=configure]
328 CREATE TABLE nt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
329 CREATE TABLE nt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
330 CREATE TABLE nt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
331 CREATE TABLE nt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
332 CREATE TABLE nt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
333 CREATE TABLE nt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = MyISAM;
334 CREATE TABLE tt_1 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
335 CREATE TABLE tt_2 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
336 CREATE TABLE tt_3 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
337 CREATE TABLE tt_4 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
338 CREATE TABLE tt_5 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
339 CREATE TABLE tt_6 (trans_id INT, stmt_id INT, info VARCHAR(64), PRIMARY KEY(trans_id, stmt_id)) ENGINE = "Innodb";
340 INSERT INTO nt_1(trans_id, stmt_id) VALUES(1,1);
341 INSERT INTO nt_2(trans_id, stmt_id) VALUES(1,1);
342 INSERT INTO nt_3(trans_id, stmt_id) VALUES(1,1);
343 INSERT INTO nt_4(trans_id, stmt_id) VALUES(1,1);
344 INSERT INTO nt_5(trans_id, stmt_id) VALUES(1,1);
345 INSERT INTO nt_6(trans_id, stmt_id) VALUES(1,1);
346 INSERT INTO tt_1(trans_id, stmt_id) VALUES(1,1);
347 INSERT INTO tt_2(trans_id, stmt_id) VALUES(1,1);
348 INSERT INTO tt_3(trans_id, stmt_id) VALUES(1,1);
349 INSERT INTO tt_4(trans_id, stmt_id) VALUES(1,1);
350 INSERT INTO tt_5(trans_id, stmt_id) VALUES(1,1);
351 INSERT INTO tt_6(trans_id, stmt_id) VALUES(1,1);
352 CREATE PROCEDURE pc_i_tt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
353 BEGIN
354 DECLARE in_stmt_id INTEGER;
355 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
356 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
357 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
358 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
359 END|
360 CREATE PROCEDURE pc_i_nt_5_suc (IN p_trans_id INTEGER, IN p_stmt_id INTEGER)
361 BEGIN
362 DECLARE in_stmt_id INTEGER;
363 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
364 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
365 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
366 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
367 END|
368 CREATE FUNCTION fc_i_tt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
369 BEGIN
370 DECLARE in_stmt_id INTEGER;
371 SELECT max(stmt_id) INTO in_stmt_id FROM tt_5 WHERE trans_id= p_trans_id;
372 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
373 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
374 INSERT INTO tt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
375 RETURN "fc_i_tt_5_suc";
376 END|
377 CREATE FUNCTION fc_i_nt_5_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
378 BEGIN
379 DECLARE in_stmt_id INTEGER;
380 SELECT max(stmt_id) INTO in_stmt_id FROM nt_5 WHERE trans_id= p_trans_id;
381 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
382 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
383 INSERT INTO nt_5(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id + 1);
384 RETURN "fc_i_nt_5_suc";
385 END|
386 CREATE FUNCTION fc_i_nt_3_tt_3_suc (p_trans_id INTEGER, p_stmt_id INTEGER) RETURNS VARCHAR(64)
387 BEGIN
388 DECLARE in_stmt_id INTEGER;
389 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= p_trans_id;
390 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
391 INSERT INTO nt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
392 SELECT max(stmt_id) INTO in_stmt_id FROM tt_3 WHERE trans_id= p_trans_id;
393 SELECT COALESCE(greatest(in_stmt_id + 1, p_stmt_id), 1) INTO in_stmt_id;
394 INSERT INTO tt_3(trans_id, stmt_id) VALUES (p_trans_id, in_stmt_id);
395 RETURN "fc_i_nt_3_tt_3_suc";
396 END|
397 CREATE TRIGGER tr_i_tt_3_to_nt_3 AFTER INSERT ON tt_3 FOR EACH ROW
398 BEGIN
399 DECLARE in_stmt_id INTEGER;
400 SELECT max(stmt_id) INTO in_stmt_id FROM nt_3 WHERE trans_id= NEW.trans_id;
401 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
402 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
403 INSERT INTO nt_3(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
404 END|
405 CREATE TRIGGER tr_i_nt_4_to_tt_4 AFTER INSERT ON nt_4 FOR EACH ROW
406 BEGIN
407 DECLARE in_stmt_id INTEGER;
408 SELECT max(stmt_id) INTO in_stmt_id FROM tt_4 WHERE trans_id= NEW.trans_id;
409 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
410 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
411 INSERT INTO tt_4(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
412 END|
413 CREATE TRIGGER tr_i_tt_5_to_tt_6 AFTER INSERT ON tt_5 FOR EACH ROW
414 BEGIN
415 DECLARE in_stmt_id INTEGER;
416 SELECT max(stmt_id) INTO in_stmt_id FROM tt_6 WHERE trans_id= NEW.trans_id;
417 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id, 1), 1) INTO in_stmt_id;
418 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
419 INSERT INTO tt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
420 END|
421 CREATE TRIGGER tr_i_nt_5_to_nt_6 AFTER INSERT ON nt_5 FOR EACH ROW
422 BEGIN
423 DECLARE in_stmt_id INTEGER;
424 SELECT max(stmt_id) INTO in_stmt_id FROM nt_6 WHERE trans_id= NEW.trans_id;
425 SELECT COALESCE(greatest(in_stmt_id + 1, NEW.stmt_id), 1) INTO in_stmt_id;
426 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id);
427 INSERT INTO nt_6(trans_id, stmt_id) VALUES (NEW.trans_id, in_stmt_id + 1);
428 END|
429 ---- end configure database test_4 ----
430 include/stop_slave.inc
431 SHOW CREATE TABLE mysql.slave_master_info;
432 Table Create Table
433 slave_master_info CREATE TABLE `slave_master_info` (
434 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file.',
435 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
436 `Master_log_pos` bigint unsigned NOT NULL COMMENT 'The master log position of the last read event.',
437 `Host` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'The host name of the source.',
438 `User_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The user name used to connect to the master.',
439 `User_password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The password used to connect to the master.',
440 `Port` int unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
441 `Connect_retry` int unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
442 `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
443 `Ssl_ca` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
444 `Ssl_capath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
445 `Ssl_cert` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL certificate file.',
446 `Ssl_cipher` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the cipher in use for the SSL connection.',
447 `Ssl_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL key file.',
448 `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
449 `Heartbeat` float NOT NULL,
450 `Bind` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
451 `Ignored_server_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
452 `Uuid` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The master server uuid.',
453 `Retry_count` bigint unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
454 `Ssl_crl` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
455 `Ssl_crlpath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
456 `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
457 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
458 `Tls_version` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Tls version',
459 `Public_key_path` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file containing public key of master server.',
460 `Get_public_key` tinyint(1) NOT NULL COMMENT 'Preference to get public key from master.',
461 `Network_namespace` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Network namespace used for communication with the master server.',
462 `Master_compression_algorithm` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'Compression algorithm supported for data transfer between source and replica.',
463 `Master_zstd_compression_level` int unsigned NOT NULL COMMENT 'Compression level associated with zstd compression algorithm.',
464 `Tls_ciphersuites` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Ciphersuites used for TLS 1.3 communication with the master server.',
465 `Source_connection_auto_failover` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates whether the channel connection failover is enabled.',
466 `Gtid_only` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if this channel only uses GTIDs and does not persist positions.',
467 PRIMARY KEY (`Channel_name`)
468 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Master Information'
469 SHOW CREATE TABLE mysql.slave_relay_log_info;
470 Table Create Table
471 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
472 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
473 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
474 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
475 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
476 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
477 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
478 `Number_of_workers` int unsigned DEFAULT NULL,
479 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
480 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
481 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
482 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
483 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
484 `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
485 `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
486 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
487 PRIMARY KEY (`Channel_name`)
488 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
489 SHOW CREATE TABLE mysql.slave_worker_info;
490 Table Create Table
491 slave_worker_info CREATE TABLE `slave_worker_info` (
492 `Id` int unsigned NOT NULL,
493 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
494 `Relay_log_pos` bigint unsigned NOT NULL,
495 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
496 `Master_log_pos` bigint unsigned NOT NULL,
497 `Checkpoint_relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
498 `Checkpoint_relay_log_pos` bigint unsigned NOT NULL,
499 `Checkpoint_master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
500 `Checkpoint_master_log_pos` bigint unsigned NOT NULL,
501 `Checkpoint_seqno` int unsigned NOT NULL,
502 `Checkpoint_group_size` int unsigned NOT NULL,
503 `Checkpoint_group_bitmap` blob NOT NULL,
504 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
505 PRIMARY KEY (`Channel_name`,`Id`)
506 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information'
507 ALTER TABLE mysql.slave_master_info ENGINE= Innodb;
508 ALTER TABLE mysql.slave_relay_log_info ENGINE= Innodb;
509 ALTER TABLE mysql.slave_worker_info ENGINE= Innodb;
510 SHOW CREATE TABLE mysql.slave_master_info;
511 Table Create Table
512 slave_master_info CREATE TABLE `slave_master_info` (
513 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file.',
514 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'The name of the master binary log currently being read from the master.',
515 `Master_log_pos` bigint unsigned NOT NULL COMMENT 'The master log position of the last read event.',
516 `Host` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'The host name of the source.',
517 `User_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The user name used to connect to the master.',
518 `User_password` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The password used to connect to the master.',
519 `Port` int unsigned NOT NULL COMMENT 'The network port used to connect to the master.',
520 `Connect_retry` int unsigned NOT NULL COMMENT 'The period (in seconds) that the slave will wait before trying to reconnect to the master.',
521 `Enabled_ssl` tinyint(1) NOT NULL COMMENT 'Indicates whether the server supports SSL connections.',
522 `Ssl_ca` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Authority (CA) certificate.',
523 `Ssl_capath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path to the Certificate Authority (CA) certificates.',
524 `Ssl_cert` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL certificate file.',
525 `Ssl_cipher` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the cipher in use for the SSL connection.',
526 `Ssl_key` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the SSL key file.',
527 `Ssl_verify_server_cert` tinyint(1) NOT NULL COMMENT 'Whether to verify the server certificate.',
528 `Heartbeat` float NOT NULL,
529 `Bind` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Displays which interface is employed when connecting to the MySQL server',
530 `Ignored_server_ids` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The number of server IDs to be ignored, followed by the actual server IDs',
531 `Uuid` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The master server uuid.',
532 `Retry_count` bigint unsigned NOT NULL COMMENT 'Number of reconnect attempts, to the master, before giving up.',
533 `Ssl_crl` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file used for the Certificate Revocation List (CRL)',
534 `Ssl_crlpath` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The path used for Certificate Revocation List (CRL) files',
535 `Enabled_auto_position` tinyint(1) NOT NULL COMMENT 'Indicates whether GTIDs will be used to retrieve events from the master.',
536 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
537 `Tls_version` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Tls version',
538 `Public_key_path` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The file containing public key of master server.',
539 `Get_public_key` tinyint(1) NOT NULL COMMENT 'Preference to get public key from master.',
540 `Network_namespace` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Network namespace used for communication with the master server.',
541 `Master_compression_algorithm` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL COMMENT 'Compression algorithm supported for data transfer between source and replica.',
542 `Master_zstd_compression_level` int unsigned NOT NULL COMMENT 'Compression level associated with zstd compression algorithm.',
543 `Tls_ciphersuites` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Ciphersuites used for TLS 1.3 communication with the master server.',
544 `Source_connection_auto_failover` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates whether the channel connection failover is enabled.',
545 `Gtid_only` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if this channel only uses GTIDs and does not persist positions.',
546 PRIMARY KEY (`Channel_name`)
547 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Master Information'
548 SHOW CREATE TABLE mysql.slave_relay_log_info;
549 Table Create Table
550 slave_relay_log_info CREATE TABLE `slave_relay_log_info` (
551 `Number_of_lines` int unsigned NOT NULL COMMENT 'Number of lines in the file or rows in the table. Used to version table definitions.',
552 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the current relay log file.',
553 `Relay_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The relay log position of the last executed event.',
554 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'The name of the master binary log file from which the events in the relay log file were read.',
555 `Master_log_pos` bigint unsigned DEFAULT NULL COMMENT 'The master log position of the last executed event.',
556 `Sql_delay` int DEFAULT NULL COMMENT 'The number of seconds that the slave must lag behind the master.',
557 `Number_of_workers` int unsigned DEFAULT NULL,
558 `Id` int unsigned DEFAULT NULL COMMENT 'Internal Id that uniquely identifies this record.',
559 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
560 `Privilege_checks_username` varchar(32) CHARACTER SET utf8mb3 COLLATE utf8mb3_bin DEFAULT NULL COMMENT 'Username part of PRIVILEGE_CHECKS_USER.',
561 `Privilege_checks_hostname` varchar(255) CHARACTER SET ascii COLLATE ascii_general_ci DEFAULT NULL COMMENT 'Hostname part of PRIVILEGE_CHECKS_USER.',
562 `Require_row_format` tinyint(1) NOT NULL COMMENT 'Indicates whether the channel shall only accept row based events.',
563 `Require_table_primary_key_check` enum('STREAM','ON','OFF','GENERATE') NOT NULL DEFAULT 'STREAM' COMMENT 'Indicates what is the channel policy regarding tables without primary keys on create and alter table queries',
564 `Assign_gtids_to_anonymous_transactions_type` enum('OFF','LOCAL','UUID') NOT NULL DEFAULT 'OFF' COMMENT 'Indicates whether the channel will generate a new GTID for anonymous transactions. OFF means that anonymous transactions will remain anonymous. LOCAL means that anonymous transactions will be assigned a newly generated GTID based on server_uuid. UUID indicates that anonymous transactions will be assigned a newly generated GTID based on Assign_gtids_to_anonymous_transactions_value',
565 `Assign_gtids_to_anonymous_transactions_value` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin COMMENT 'Indicates the UUID used while generating GTIDs for anonymous transactions',
566 PRIMARY KEY (`Channel_name`)
567 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Relay Log Information'
568 SHOW CREATE TABLE mysql.slave_worker_info;
569 Table Create Table
570 slave_worker_info CREATE TABLE `slave_worker_info` (
571 `Id` int unsigned NOT NULL,
572 `Relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
573 `Relay_log_pos` bigint unsigned NOT NULL,
574 `Master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
575 `Master_log_pos` bigint unsigned NOT NULL,
576 `Checkpoint_relay_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
577 `Checkpoint_relay_log_pos` bigint unsigned NOT NULL,
578 `Checkpoint_master_log_name` text CHARACTER SET utf8mb3 COLLATE utf8mb3_bin NOT NULL,
579 `Checkpoint_master_log_pos` bigint unsigned NOT NULL,
580 `Checkpoint_seqno` int unsigned NOT NULL,
581 `Checkpoint_group_size` int unsigned NOT NULL,
582 `Checkpoint_group_bitmap` blob NOT NULL,
583 `Channel_name` varchar(64) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NOT NULL COMMENT 'The channel on which the replica is connected to a source. Used in Multisource Replication',
584 PRIMARY KEY (`Channel_name`,`Id`)
585 ) /*!50100 TABLESPACE `mysql` */ ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 STATS_PERSISTENT=0 ROW_FORMAT=DYNAMIC COMMENT='Worker Information'
586 ==== end rpl_mts_crash_safe.inc:configure ====
587 ########################################################################
588 # TEST
589 ########################################################################
590 SET @@global.replica_parallel_workers= 4;
591 SET @@global.replica_checkpoint_period= 2;
592 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_1
593 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
594 rpl_mixing_engines.inc [commands=B T T C]
595 BEGIN;
596 INSERT INTO tt_1(trans_id, stmt_id) VALUES (7, 2);
597 INSERT INTO tt_1(trans_id, stmt_id) VALUES (7, 4);
598 COMMIT;
599 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
600 include/show_binlog_events.inc
601 Log_name Pos Event_type Server_id End_log_pos Info
602 master-bin.000001 # Query # # BEGIN
603 master-bin.000001 # Query # # use `test_1`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (7, 2)
604 master-bin.000001 # Query # # use `test_1`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (7, 4)
605 master-bin.000001 # Xid # # COMMIT /* XID */
606 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
607
608 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
609 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_2
610 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
611 rpl_mixing_engines.inc [commands=B T T C]
612 BEGIN;
613 INSERT INTO tt_1(trans_id, stmt_id) VALUES (8, 2);
614 INSERT INTO tt_1(trans_id, stmt_id) VALUES (8, 4);
615 COMMIT;
616 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
617 include/show_binlog_events.inc
618 Log_name Pos Event_type Server_id End_log_pos Info
619 master-bin.000001 # Query # # BEGIN
620 master-bin.000001 # Query # # use `test_2`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (8, 2)
621 master-bin.000001 # Query # # use `test_2`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (8, 4)
622 master-bin.000001 # Xid # # COMMIT /* XID */
623 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
624
625 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
626 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_3
627 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
628 rpl_mixing_engines.inc [commands=B T T C]
629 BEGIN;
630 INSERT INTO tt_1(trans_id, stmt_id) VALUES (9, 2);
631 INSERT INTO tt_1(trans_id, stmt_id) VALUES (9, 4);
632 COMMIT;
633 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
634 include/show_binlog_events.inc
635 Log_name Pos Event_type Server_id End_log_pos Info
636 master-bin.000001 # Query # # BEGIN
637 master-bin.000001 # Query # # use `test_3`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (9, 2)
638 master-bin.000001 # Query # # use `test_3`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (9, 4)
639 master-bin.000001 # Xid # # COMMIT /* XID */
640 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
641
642 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
643 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_4
644 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
645 rpl_mixing_engines.inc [commands=B T T C]
646 BEGIN;
647 INSERT INTO tt_1(trans_id, stmt_id) VALUES (10, 2);
648 INSERT INTO tt_1(trans_id, stmt_id) VALUES (10, 4);
649 COMMIT;
650 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
651 include/show_binlog_events.inc
652 Log_name Pos Event_type Server_id End_log_pos Info
653 master-bin.000001 # Query # # BEGIN
654 master-bin.000001 # Query # # use `test_4`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (10, 2)
655 master-bin.000001 # Query # # use `test_4`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (10, 4)
656 master-bin.000001 # Xid # # COMMIT /* XID */
657 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
658
659 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
660 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_1
661 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
662 rpl_mixing_engines.inc [commands=B T T C]
663 BEGIN;
664 INSERT INTO tt_1(trans_id, stmt_id) VALUES (11, 2);
665 INSERT INTO tt_1(trans_id, stmt_id) VALUES (11, 4);
666 COMMIT;
667 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
668 include/show_binlog_events.inc
669 Log_name Pos Event_type Server_id End_log_pos Info
670 master-bin.000001 # Query # # BEGIN
671 master-bin.000001 # Query # # use `test_1`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (11, 2)
672 master-bin.000001 # Query # # use `test_1`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (11, 4)
673 master-bin.000001 # Xid # # COMMIT /* XID */
674 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
675
676 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
677 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_2
678 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
679 rpl_mixing_engines.inc [commands=B T T C]
680 BEGIN;
681 INSERT INTO tt_1(trans_id, stmt_id) VALUES (12, 2);
682 INSERT INTO tt_1(trans_id, stmt_id) VALUES (12, 4);
683 COMMIT;
684 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
685 include/show_binlog_events.inc
686 Log_name Pos Event_type Server_id End_log_pos Info
687 master-bin.000001 # Query # # BEGIN
688 master-bin.000001 # Query # # use `test_2`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (12, 2)
689 master-bin.000001 # Query # # use `test_2`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (12, 4)
690 master-bin.000001 # Xid # # COMMIT /* XID */
691 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
692
693 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
694 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_3
695 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
696 rpl_mixing_engines.inc [commands=B T T C]
697 BEGIN;
698 INSERT INTO tt_1(trans_id, stmt_id) VALUES (13, 2);
699 INSERT INTO tt_1(trans_id, stmt_id) VALUES (13, 4);
700 COMMIT;
701 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
702 include/show_binlog_events.inc
703 Log_name Pos Event_type Server_id End_log_pos Info
704 master-bin.000001 # Query # # BEGIN
705 master-bin.000001 # Query # # use `test_3`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (13, 2)
706 master-bin.000001 # Query # # use `test_3`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (13, 4)
707 master-bin.000001 # Xid # # COMMIT /* XID */
708 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
709
710 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
711 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_4
712 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
713 rpl_mixing_engines.inc [commands=B T T C]
714 BEGIN;
715 INSERT INTO tt_1(trans_id, stmt_id) VALUES (14, 2);
716 INSERT INTO tt_1(trans_id, stmt_id) VALUES (14, 4);
717 COMMIT;
718 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
719 include/show_binlog_events.inc
720 Log_name Pos Event_type Server_id End_log_pos Info
721 master-bin.000001 # Query # # BEGIN
722 master-bin.000001 # Query # # use `test_4`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (14, 2)
723 master-bin.000001 # Query # # use `test_4`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (14, 4)
724 master-bin.000001 # Xid # # COMMIT /* XID */
725 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
726
727 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
728 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_1
729 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
730 rpl_mixing_engines.inc [commands=B T T C]
731 BEGIN;
732 INSERT INTO tt_1(trans_id, stmt_id) VALUES (15, 2);
733 INSERT INTO tt_1(trans_id, stmt_id) VALUES (15, 4);
734 COMMIT;
735 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
736 include/show_binlog_events.inc
737 Log_name Pos Event_type Server_id End_log_pos Info
738 master-bin.000001 # Query # # BEGIN
739 master-bin.000001 # Query # # use `test_1`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (15, 2)
740 master-bin.000001 # Query # # use `test_1`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (15, 4)
741 master-bin.000001 # Xid # # COMMIT /* XID */
742 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
743
744 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
745 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_2
746 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
747 rpl_mixing_engines.inc [commands=B T T C]
748 BEGIN;
749 INSERT INTO tt_1(trans_id, stmt_id) VALUES (16, 2);
750 INSERT INTO tt_1(trans_id, stmt_id) VALUES (16, 4);
751 COMMIT;
752 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
753 include/show_binlog_events.inc
754 Log_name Pos Event_type Server_id End_log_pos Info
755 master-bin.000001 # Query # # BEGIN
756 master-bin.000001 # Query # # use `test_2`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (16, 2)
757 master-bin.000001 # Query # # use `test_2`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (16, 4)
758 master-bin.000001 # Xid # # COMMIT /* XID */
759 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
760
761 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
762 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_3
763 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
764 rpl_mixing_engines.inc [commands=B T T C]
765 BEGIN;
766 INSERT INTO tt_1(trans_id, stmt_id) VALUES (17, 2);
767 INSERT INTO tt_1(trans_id, stmt_id) VALUES (17, 4);
768 COMMIT;
769 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
770 include/show_binlog_events.inc
771 Log_name Pos Event_type Server_id End_log_pos Info
772 master-bin.000001 # Query # # BEGIN
773 master-bin.000001 # Query # # use `test_3`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (17, 2)
774 master-bin.000001 # Query # # use `test_3`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (17, 4)
775 master-bin.000001 # Xid # # COMMIT /* XID */
776 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
777
778 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
779 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_4
780 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
781 rpl_mixing_engines.inc [commands=B T T C]
782 BEGIN;
783 INSERT INTO tt_1(trans_id, stmt_id) VALUES (18, 2);
784 INSERT INTO tt_1(trans_id, stmt_id) VALUES (18, 4);
785 COMMIT;
786 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
787 include/show_binlog_events.inc
788 Log_name Pos Event_type Server_id End_log_pos Info
789 master-bin.000001 # Query # # BEGIN
790 master-bin.000001 # Query # # use `test_4`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (18, 2)
791 master-bin.000001 # Query # # use `test_4`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (18, 4)
792 master-bin.000001 # Xid # # COMMIT /* XID */
793 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
794
795 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
796 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_1
797 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
798 rpl_mixing_engines.inc [commands=B T T C]
799 BEGIN;
800 INSERT INTO tt_1(trans_id, stmt_id) VALUES (19, 2);
801 INSERT INTO tt_1(trans_id, stmt_id) VALUES (19, 4);
802 COMMIT;
803 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
804 include/show_binlog_events.inc
805 Log_name Pos Event_type Server_id End_log_pos Info
806 master-bin.000001 # Query # # BEGIN
807 master-bin.000001 # Query # # use `test_1`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (19, 2)
808 master-bin.000001 # Query # # use `test_1`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (19, 4)
809 master-bin.000001 # Xid # # COMMIT /* XID */
810 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
811
812 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
813 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_2
814 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
815 rpl_mixing_engines.inc [commands=B T T C]
816 BEGIN;
817 INSERT INTO tt_1(trans_id, stmt_id) VALUES (20, 2);
818 INSERT INTO tt_1(trans_id, stmt_id) VALUES (20, 4);
819 COMMIT;
820 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
821 include/show_binlog_events.inc
822 Log_name Pos Event_type Server_id End_log_pos Info
823 master-bin.000001 # Query # # BEGIN
824 master-bin.000001 # Query # # use `test_2`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (20, 2)
825 master-bin.000001 # Query # # use `test_2`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (20, 4)
826 master-bin.000001 # Xid # # COMMIT /* XID */
827 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
828
829 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
830 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_3
831 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
832 rpl_mixing_engines.inc [commands=B T T C]
833 BEGIN;
834 INSERT INTO tt_1(trans_id, stmt_id) VALUES (21, 2);
835 INSERT INTO tt_1(trans_id, stmt_id) VALUES (21, 4);
836 COMMIT;
837 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
838 include/show_binlog_events.inc
839 Log_name Pos Event_type Server_id End_log_pos Info
840 master-bin.000001 # Query # # BEGIN
841 master-bin.000001 # Query # # use `test_3`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (21, 2)
842 master-bin.000001 # Query # # use `test_3`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (21, 4)
843 master-bin.000001 # Xid # # COMMIT /* XID */
844 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
845
846 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
847 Generating Number of Workers 4 --- Number of Groups per worker 4 --- Debugging Groups 3 --- Database test_4
848 ==== begin rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
849 rpl_mixing_engines.inc [commands=B T T C]
850 BEGIN;
851 INSERT INTO tt_1(trans_id, stmt_id) VALUES (22, 2);
852 INSERT INTO tt_1(trans_id, stmt_id) VALUES (22, 4);
853 COMMIT;
854 -b-b-b-b-b-b-b-b-b-b-b- >> B T T C << -b-b-b-b-b-b-b-b-b-b-b-
855 include/show_binlog_events.inc
856 Log_name Pos Event_type Server_id End_log_pos Info
857 master-bin.000001 # Query # # BEGIN
858 master-bin.000001 # Query # # use `test_4`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (22, 2)
859 master-bin.000001 # Query # # use `test_4`; INSERT INTO tt_1(trans_id, stmt_id) VALUES (22, 4)
860 master-bin.000001 # Xid # # COMMIT /* XID */
861 -e-e-e-e-e-e-e-e-e-e-e- >> B T T C << -e-e-e-e-e-e-e-e-e-e-e-
862
863 ==== end rpl_mts_crash_safe.inc:rpl_mixing_engines.inc ====
864 ----Executing----
865 ==== begin rpl_mts_crash_safe.inc:recovery ====
866 include/start_slave_io.inc
867 ** fixing gaps **
868 include/rpl_start_server.inc [server_number=2 parameters: --skip-replica-start --relay-log-recovery=0 --replica-parallel-workers=0]
869 START REPLICA UNTIL SQL_AFTER_MTS_GAPS;
870 include/wait_for_slave_param.inc [Until_Condition]
871 include/wait_for_slave_sql_to_stop.inc
872 ** regular restart **
873 include/rpl_restart_server.inc [server_number=2 parameters: --skip-replica-start --replica-transaction-retries=0 --sync-source-info=1]
874 include/start_slave_io.inc
875 include/start_slave_sql.inc
876 include/stop_slave.inc
877 SET @@global.replica_parallel_workers= 4;
878 SET @@global.replica_checkpoint_period= 2;
879 ==== end rpl_mts_crash_safe.inc:recovery ====
880 ########################################################################
881 # CHECK CONSISTENCY
882 ########################################################################
883 include/start_slave.inc
884 include/sync_slave_sql_with_master.inc
885 ########################################################################
886 # CLEAN UP
887 ########################################################################
888 ==== begin rpl_mts_crash_safe.inc:clean ====
889 include/stop_slave.inc
890 Warnings:
891 Warning 1287 '0' is deprecated and will be removed in a future release. Please use 1 instead
892 include/start_slave.inc
893 ---- begin clean database test_1 ----
894 rpl_mixing_engines.inc [commands=clean]
895 DROP TABLE tt_1;
896 DROP TABLE tt_2;
897 DROP TABLE tt_3;
898 DROP TABLE tt_4;
899 DROP TABLE tt_5;
900 DROP TABLE tt_6;
901 DROP TABLE nt_1;
902 DROP TABLE nt_2;
903 DROP TABLE nt_3;
904 DROP TABLE nt_4;
905 DROP TABLE nt_5;
906 DROP TABLE nt_6;
907 DROP PROCEDURE pc_i_tt_5_suc;
908 DROP PROCEDURE pc_i_nt_5_suc;
909 DROP FUNCTION fc_i_tt_5_suc;
910 DROP FUNCTION fc_i_nt_5_suc;
911 DROP FUNCTION fc_i_nt_3_tt_3_suc;
912 ---- end clean database test_1 ----
913 ---- begin clean database test_2 ----
914 rpl_mixing_engines.inc [commands=clean]
915 DROP TABLE tt_1;
916 DROP TABLE tt_2;
917 DROP TABLE tt_3;
918 DROP TABLE tt_4;
919 DROP TABLE tt_5;
920 DROP TABLE tt_6;
921 DROP TABLE nt_1;
922 DROP TABLE nt_2;
923 DROP TABLE nt_3;
924 DROP TABLE nt_4;
925 DROP TABLE nt_5;
926 DROP TABLE nt_6;
927 DROP PROCEDURE pc_i_tt_5_suc;
928 DROP PROCEDURE pc_i_nt_5_suc;
929 DROP FUNCTION fc_i_tt_5_suc;
930 DROP FUNCTION fc_i_nt_5_suc;
931 DROP FUNCTION fc_i_nt_3_tt_3_suc;
932 ---- end clean database test_2 ----
933 ---- begin clean database test_3 ----
934 rpl_mixing_engines.inc [commands=clean]
935 DROP TABLE tt_1;
936 DROP TABLE tt_2;
937 DROP TABLE tt_3;
938 DROP TABLE tt_4;
939 DROP TABLE tt_5;
940 DROP TABLE tt_6;
941 DROP TABLE nt_1;
942 DROP TABLE nt_2;
943 DROP TABLE nt_3;
944 DROP TABLE nt_4;
945 DROP TABLE nt_5;
946 DROP TABLE nt_6;
947 DROP PROCEDURE pc_i_tt_5_suc;
948 DROP PROCEDURE pc_i_nt_5_suc;
949 DROP FUNCTION fc_i_tt_5_suc;
950 DROP FUNCTION fc_i_nt_5_suc;
951 DROP FUNCTION fc_i_nt_3_tt_3_suc;
952 ---- end clean database test_3 ----
953 ---- begin clean database test_4 ----
954 rpl_mixing_engines.inc [commands=clean]
955 DROP TABLE tt_1;
956 DROP TABLE tt_2;
957 DROP TABLE tt_3;
958 DROP TABLE tt_4;
959 DROP TABLE tt_5;
960 DROP TABLE tt_6;
961 DROP TABLE nt_1;
962 DROP TABLE nt_2;
963 DROP TABLE nt_3;
964 DROP TABLE nt_4;
965 DROP TABLE nt_5;
966 DROP TABLE nt_6;
967 DROP PROCEDURE pc_i_tt_5_suc;
968 DROP PROCEDURE pc_i_nt_5_suc;
969 DROP FUNCTION fc_i_tt_5_suc;
970 DROP FUNCTION fc_i_nt_5_suc;
971 DROP FUNCTION fc_i_nt_3_tt_3_suc;
972 ---- end clean database test_4 ----
973 ==== end rpl_mts_crash_safe.inc:clean ====
974 include/rpl_end.inc