Debian Codegraph @

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

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