Debian Codegraph @

mysql-test/suite/binlog_encryption/rpl_parallel_deadlock_corrupt_binlog.result

raw
1 *** MDEV-7335: Potential parallel slave deadlock with specific binlog corruption ***
2 include/master-slave.inc
3 [connection master]
4 connection server_2;
5 include/stop_slave.inc
6 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
7 SET GLOBAL slave_parallel_threads=10;
8 CHANGE MASTER TO master_use_gtid=slave_pos;
9 include/start_slave.inc
10 connection server_1;
11 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
12 CREATE TABLE t2 (a int PRIMARY KEY) ENGINE=InnoDB;
13 connection server_2;
14 include/stop_slave.inc
15 SET GLOBAL slave_parallel_threads=1;
16 SET @old_dbug= @@GLOBAL.debug_dbug;
17 SET GLOBAL debug_dbug="+d,slave_discard_xid_for_gtid_0_x_1000";
18 CALL mtr.add_suppression("Unexpected break of being relay-logged GTID");
19 connection server_1;
20 INSERT INTO t2 VALUES (101);
21 INSERT INTO t2 VALUES (102);
22 INSERT INTO t2 VALUES (103);
23 INSERT INTO t2 VALUES (104);
24 INSERT INTO t2 VALUES (105);
25 SET gtid_seq_no=1000;
26 INSERT INTO t2 VALUES (106);
27 INSERT INTO t2 VALUES (107);
28 INSERT INTO t2 VALUES (108);
29 INSERT INTO t2 VALUES (109);
30 INSERT INTO t2 VALUES (110);
31 INSERT INTO t2 VALUES (111);
32 INSERT INTO t2 VALUES (112);
33 INSERT INTO t2 VALUES (113);
34 INSERT INTO t2 VALUES (114);
35 INSERT INTO t2 VALUES (115);
36 INSERT INTO t2 VALUES (116);
37 INSERT INTO t2 VALUES (117);
38 INSERT INTO t2 VALUES (118);
39 INSERT INTO t2 VALUES (119);
40 INSERT INTO t2 VALUES (120);
41 INSERT INTO t2 VALUES (121);
42 INSERT INTO t2 VALUES (122);
43 INSERT INTO t2 VALUES (123);
44 INSERT INTO t2 VALUES (124);
45 INSERT INTO t2 VALUES (125);
46 INSERT INTO t2 VALUES (126);
47 INSERT INTO t2 VALUES (127);
48 INSERT INTO t2 VALUES (128);
49 INSERT INTO t2 VALUES (129);
50 INSERT INTO t2 VALUES (130);
51 include/save_master_gtid.inc
52 connection server_2;
53 include/start_slave.inc
54 include/sync_with_master_gtid.inc
55 SELECT * FROM t2 WHERE a >= 100 ORDER BY a;
56 a
57 101
58 102
59 103
60 104
61 105
62 107
63 108
64 109
65 110
66 111
67 112
68 113
69 114
70 115
71 116
72 117
73 118
74 119
75 120
76 121
77 122
78 123
79 124
80 125
81 126
82 127
83 128
84 129
85 130
86 include/stop_slave.inc
87 SET GLOBAL debug_dbug=@old_dbug;
88 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
89 include/start_slave.inc
90 SET DEBUG_SYNC= 'RESET';
91 connection server_1;
92 DROP TABLE t2;
93 SET DEBUG_SYNC= 'RESET';
94 include/rpl_end.inc