Debian Codegraph @

mysql-test/suite/rpl/r/rpl_parallel_mdev6589.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 include/start_slave.inc
8 *** MDEV-6589: Incorrect relay log start position when restarting SQL thread after error in parallel replication ***
9 connection server_1;
10 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
11 CREATE TABLE t1 (a int PRIMARY KEY) ENGINE=MyISAM;
12 CREATE TABLE t2 (a int PRIMARY KEY) ENGINE=InnoDB;
13 INSERT INTO t1 VALUES (1);
14 INSERT INTO t2 VALUES (1);
15 connection server_2;
16 SELECT * FROM t1;
17 a
18 1
19 SELECT * FROM t2;
20 a
21 1
22 connect con_temp1,127.0.0.1,root,,test,$SERVER_MYPORT_2,;
23 SET sql_log_bin=0;
24 BEGIN;
25 INSERT INTO t2 VALUES (5);
26 connection server_1;
27 SET gtid_domain_id=0;
28 INSERT INTO t1 VALUES (2);
29 INSERT INTO t2 VALUES (3);
30 FLUSH LOGS;
31 INSERT INTO t1 VALUES (4);
32 SET gtid_domain_id=1;
33 INSERT INTO t2 VALUES (5);
34 SET gtid_domain_id=0;
35 INSERT INTO t1 VALUES (6);
36 INSERT INTO t1 VALUES (7);
37 SET gtid_domain_id=2;
38 INSERT INTO t2 VALUES (8);
39 INSERT INTO t1 VALUES (9);
40 FLUSH LOGS;
41 SET gtid_domain_id=3;
42 INSERT INTO t2 VALUES (10);
43 INSERT INTO t1 VALUES (11);
44 SET gtid_domain_id=1;
45 INSERT INTO t1 VALUES (12);
46 INSERT INTO t2 VALUES (13);
47 SET gtid_domain_id=0;
48 INSERT INTO t2 VALUES (14);
49 FLUSH LOGS;
50 SET gtid_domain_id=3;
51 INSERT INTO t2 VALUES (15);
52 SET gtid_domain_id=2;
53 INSERT INTO t2 VALUES (16);
54 SET gtid_domain_id=0;
55 INSERT INTO t1 VALUES (17);
56 SET @gtid0 = @@last_gtid;
57 SET gtid_domain_id=2;
58 INSERT INTO t1 VALUES (18);
59 SET @gtid2 = @@last_gtid;
60 SET gtid_domain_id=3;
61 INSERT INTO t1 VALUES (19);
62 SET @gtid3 = @@last_gtid;
63 SELECT * FROM t1 ORDER BY a;
64 a
65 1
66 2
67 4
68 6
69 7
70 9
71 11
72 12
73 17
74 18
75 19
76 SELECT * FROM t2 ORDER BY a;
77 a
78 1
79 3
80 5
81 8
82 10
83 13
84 14
85 15
86 16
87 include/save_master_gtid.inc
88 connection server_2;
89 SELECT MASTER_GTID_WAIT('WAIT_POS');
90 MASTER_GTID_WAIT('WAIT_POS')
91 0
92 connection con_temp1;
93 COMMIT;
94 CALL mtr.add_suppression("Commit failed due to failure of an earlier commit on which this one depends");
95 SET sql_log_bin=1;
96 connection server_2;
97 include/wait_for_slave_sql_error.inc [errno=1062]
98 SELECT * FROM t1 ORDER BY a;
99 a
100 1
101 2
102 4
103 6
104 7
105 9
106 11
107 17
108 18
109 19
110 SELECT * FROM t2 ORDER BY a;
111 a
112 1
113 3
114 5
115 8
116 10
117 14
118 15
119 16
120 SET sql_log_bin=0;
121 DELETE FROM t2 WHERE a=5;
122 SET sql_log_bin=1;
123 include/start_slave.inc
124 include/sync_with_master_gtid.inc
125 SELECT * FROM t1 ORDER BY a;
126 a
127 1
128 2
129 4
130 6
131 7
132 9
133 11
134 12
135 17
136 18
137 19
138 SELECT * FROM t2 ORDER BY a;
139 a
140 1
141 3
142 5
143 8
144 10
145 13
146 14
147 15
148 16
149 connection server_2;
150 include/stop_slave.inc
151 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
152 include/start_slave.inc
153 SET DEBUG_SYNC= 'RESET';
154 connection server_1;
155 DROP TABLE t1,t2;
156 SET DEBUG_SYNC= 'RESET';
157 include/rpl_end.inc