| 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 |