Debian Codegraph @

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

raw
1 include/master-slave.inc
2 [connection master]
3 *** MDEV-7847: "Slave worker thread retried transaction 10 time(s) in vain, giving up", followed by replication hanging ***
4 *** MDEV-7882: Excessive transaction retry in parallel replication ***
5 connection server_1;
6 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
7 CREATE TABLE t7 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
8 CREATE TABLE t8 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
9 connection server_2;
10 include/stop_slave.inc
11 SET @old_mode= @@GLOBAL.slave_parallel_mode;
12 SET GLOBAL slave_parallel_mode='conservative';
13 SET @old_threads= @@GLOBAL.slave_parallel_threads;
14 SET GLOBAL slave_parallel_threads=40;
15 SET @old_transaction_retries= @@GLOBAL.slave_transaction_retries;
16 SET GLOBAL slave_transaction_retries=5;
17 connection server_1;
18 INSERT INTO t7 VALUES (1,1), (2,2), (3,3), (4,4), (5,5);
19 SET @old_dbug= @@SESSION.debug_dbug;
20 SET @commit_id= 42;
21 SET SESSION debug_dbug="+d,binlog_force_commit_id";
22 INSERT INTO t8 VALUES (1,1);
23 INSERT INTO t8 VALUES (2,2);
24 INSERT INTO t8 VALUES (3,3);
25 INSERT INTO t8 VALUES (4,4);
26 INSERT INTO t8 VALUES (5,5);
27 INSERT INTO t8 VALUES (6,6);
28 INSERT INTO t8 VALUES (7,7);
29 INSERT INTO t8 VALUES (8,8);
30 UPDATE t7 SET b=9 WHERE a=3;
31 UPDATE t7 SET b=10 WHERE a=3;
32 UPDATE t7 SET b=11 WHERE a=3;
33 INSERT INTO t8 VALUES (12,12);
34 INSERT INTO t8 VALUES (13,13);
35 UPDATE t7 SET b=14 WHERE a=3;
36 UPDATE t7 SET b=15 WHERE a=3;
37 INSERT INTO t8 VALUES (16,16);
38 UPDATE t7 SET b=17 WHERE a=3;
39 INSERT INTO t8 VALUES (18,18);
40 INSERT INTO t8 VALUES (19,19);
41 UPDATE t7 SET b=20 WHERE a=3;
42 INSERT INTO t8 VALUES (21,21);
43 UPDATE t7 SET b=22 WHERE a=3;
44 INSERT INTO t8 VALUES (23,24);
45 INSERT INTO t8 VALUES (24,24);
46 UPDATE t7 SET b=25 WHERE a=3;
47 INSERT INTO t8 VALUES (26,26);
48 UPDATE t7 SET b=27 WHERE a=3;
49 BEGIN;
50 INSERT INTO t8 VALUES (28,28);
51 INSERT INTO t8 VALUES (29,28), (30,28);
52 INSERT INTO t8 VALUES (31,28);
53 INSERT INTO t8 VALUES (32,28);
54 INSERT INTO t8 VALUES (33,28);
55 INSERT INTO t8 VALUES (34,28);
56 INSERT INTO t8 VALUES (35,28);
57 INSERT INTO t8 VALUES (36,28);
58 INSERT INTO t8 VALUES (37,28);
59 INSERT INTO t8 VALUES (38,28);
60 INSERT INTO t8 VALUES (39,28);
61 INSERT INTO t8 VALUES (40,28);
62 INSERT INTO t8 VALUES (41,28);
63 INSERT INTO t8 VALUES (42,28);
64 COMMIT;
65 SET @commit_id=43;
66 INSERT INTO t8 VALUES (43,43);
67 INSERT INTO t8 VALUES (44,44);
68 UPDATE t7 SET b=45 WHERE a=3;
69 INSERT INTO t8 VALUES (46,46);
70 INSERT INTO t8 VALUES (47,47);
71 UPDATE t7 SET b=48 WHERE a=3;
72 INSERT INTO t8 VALUES (49,49);
73 INSERT INTO t8 VALUES (50,50);
74 SET @commit_id=44;
75 INSERT INTO t8 VALUES (51,51);
76 INSERT INTO t8 VALUES (52,52);
77 UPDATE t7 SET b=53 WHERE a=3;
78 INSERT INTO t8 VALUES (54,54);
79 INSERT INTO t8 VALUES (55,55);
80 UPDATE t7 SET b=56 WHERE a=3;
81 INSERT INTO t8 VALUES (57,57);
82 UPDATE t7 SET b=58 WHERE a=3;
83 INSERT INTO t8 VALUES (58,58);
84 INSERT INTO t8 VALUES (59,59);
85 INSERT INTO t8 VALUES (60,60);
86 INSERT INTO t8 VALUES (61,61);
87 UPDATE t7 SET b=62 WHERE a=3;
88 INSERT INTO t8 VALUES (63,63);
89 INSERT INTO t8 VALUES (64,64);
90 INSERT INTO t8 VALUES (65,65);
91 INSERT INTO t8 VALUES (66,66);
92 UPDATE t7 SET b=67 WHERE a=3;
93 INSERT INTO t8 VALUES (68,68);
94 UPDATE t7 SET b=69 WHERE a=3;
95 UPDATE t7 SET b=70 WHERE a=3;
96 UPDATE t7 SET b=71 WHERE a=3;
97 INSERT INTO t8 VALUES (72,72);
98 UPDATE t7 SET b=73 WHERE a=3;
99 UPDATE t7 SET b=74 WHERE a=3;
100 UPDATE t7 SET b=75 WHERE a=3;
101 UPDATE t7 SET b=76 WHERE a=3;
102 INSERT INTO t8 VALUES (77,77);
103 UPDATE t7 SET b=78 WHERE a=3;
104 INSERT INTO t8 VALUES (79,79);
105 UPDATE t7 SET b=80 WHERE a=3;
106 INSERT INTO t8 VALUES (81,81);
107 UPDATE t7 SET b=82 WHERE a=3;
108 INSERT INTO t8 VALUES (83,83);
109 UPDATE t7 SET b=84 WHERE a=3;
110 SET @commit_id=45;
111 INSERT INTO t8 VALUES (85,85);
112 UPDATE t7 SET b=86 WHERE a=3;
113 INSERT INTO t8 VALUES (87,87);
114 SET @commit_id=46;
115 INSERT INTO t8 VALUES (88,88);
116 INSERT INTO t8 VALUES (89,89);
117 INSERT INTO t8 VALUES (90,90);
118 SET SESSION debug_dbug=@old_dbug;
119 INSERT INTO t8 VALUES (91,91);
120 INSERT INTO t8 VALUES (92,92);
121 INSERT INTO t8 VALUES (93,93);
122 INSERT INTO t8 VALUES (94,94);
123 INSERT INTO t8 VALUES (95,95);
124 INSERT INTO t8 VALUES (96,96);
125 INSERT INTO t8 VALUES (97,97);
126 INSERT INTO t8 VALUES (98,98);
127 INSERT INTO t8 VALUES (99,99);
128 SELECT * FROM t7 ORDER BY a;
129 a b
130 1 1
131 2 2
132 3 86
133 4 4
134 5 5
135 SELECT * FROM t8 ORDER BY a;
136 a b
137 1 1
138 2 2
139 3 3
140 4 4
141 5 5
142 6 6
143 7 7
144 8 8
145 12 12
146 13 13
147 16 16
148 18 18
149 19 19
150 21 21
151 23 24
152 24 24
153 26 26
154 28 28
155 29 28
156 30 28
157 31 28
158 32 28
159 33 28
160 34 28
161 35 28
162 36 28
163 37 28
164 38 28
165 39 28
166 40 28
167 41 28
168 42 28
169 43 43
170 44 44
171 46 46
172 47 47
173 49 49
174 50 50
175 51 51
176 52 52
177 54 54
178 55 55
179 57 57
180 58 58
181 59 59
182 60 60
183 61 61
184 63 63
185 64 64
186 65 65
187 66 66
188 68 68
189 72 72
190 77 77
191 79 79
192 81 81
193 83 83
194 85 85
195 87 87
196 88 88
197 89 89
198 90 90
199 91 91
200 92 92
201 93 93
202 94 94
203 95 95
204 96 96
205 97 97
206 98 98
207 99 99
208 include/save_master_gtid.inc
209 connection server_2;
210 include/start_slave.inc
211 include/sync_with_master_gtid.inc
212 SELECT * FROM t7 ORDER BY a;
213 a b
214 1 1
215 2 2
216 3 86
217 4 4
218 5 5
219 SELECT * FROM t8 ORDER BY a;
220 a b
221 1 1
222 2 2
223 3 3
224 4 4
225 5 5
226 6 6
227 7 7
228 8 8
229 12 12
230 13 13
231 16 16
232 18 18
233 19 19
234 21 21
235 23 24
236 24 24
237 26 26
238 28 28
239 29 28
240 30 28
241 31 28
242 32 28
243 33 28
244 34 28
245 35 28
246 36 28
247 37 28
248 38 28
249 39 28
250 40 28
251 41 28
252 42 28
253 43 43
254 44 44
255 46 46
256 47 47
257 49 49
258 50 50
259 51 51
260 52 52
261 54 54
262 55 55
263 57 57
264 58 58
265 59 59
266 60 60
267 61 61
268 63 63
269 64 64
270 65 65
271 66 66
272 68 68
273 72 72
274 77 77
275 79 79
276 81 81
277 83 83
278 85 85
279 87 87
280 88 88
281 89 89
282 90 90
283 91 91
284 92 92
285 93 93
286 94 94
287 95 95
288 96 96
289 97 97
290 98 98
291 99 99
292 *** MDEV-8302: Duplicate key with parallel replication ***
293 connection server_2;
294 include/stop_slave.inc
295 /* Inject a small sleep which makes the race easier to hit. */
296 SET @old_dbug=@@GLOBAL.debug_dbug;
297 SET GLOBAL debug_dbug="+d,inject_mdev8302";
298 connection server_1;
299 INSERT INTO t7 VALUES (100,1), (101,2), (102,3), (103,4), (104,5);
300 SET @old_dbug= @@SESSION.debug_dbug;
301 SET @commit_id= 20000;
302 SET SESSION debug_dbug="+d,binlog_force_commit_id";
303 SET SESSION debug_dbug=@old_dbug;
304 SELECT * FROM t7 ORDER BY a;
305 a b
306 1 1
307 2 2
308 3 86
309 4 4
310 5 5
311 100 5
312 101 1
313 102 2
314 103 3
315 104 4
316 include/save_master_gtid.inc
317 connection server_2;
318 include/start_slave.inc
319 include/sync_with_master_gtid.inc
320 SELECT * FROM t7 ORDER BY a;
321 a b
322 1 1
323 2 2
324 3 86
325 4 4
326 5 5
327 100 5
328 101 1
329 102 2
330 103 3
331 104 4
332 include/stop_slave.inc
333 SET GLOBAL debug_dbug=@old_dbug;
334 SET GLOBAL slave_parallel_mode=@old_mode;
335 SET GLOBAL slave_parallel_threads=@old_threads;
336 SET GLOBAL slave_transaction_retries=@old_transaction_retries;
337 include/start_slave.inc
338 SET DEBUG_SYNC= 'RESET';
339 connection server_1;
340 DROP TABLE t7,t8;
341 SET DEBUG_SYNC= 'RESET';
342 include/rpl_end.inc