Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2->3->4]
2 connection server_1;
3 ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
4 CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
5 connection server_2;
6 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
7 include/stop_slave.inc
8 SET GLOBAL slave_parallel_threads=10;
9 CHANGE MASTER TO master_use_gtid=slave_pos;
10 SET @old_parallel_mode=@@GLOBAL.slave_parallel_mode;
11 SET GLOBAL slave_parallel_mode='optimistic';
12 connection server_3;
13 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
14 include/stop_slave.inc
15 SET GLOBAL slave_parallel_threads=10;
16 CHANGE MASTER TO master_use_gtid=slave_pos;
17 SET @old_parallel_mode=@@GLOBAL.slave_parallel_mode;
18 SET GLOBAL slave_parallel_mode='optimistic';
19 connection server_4;
20 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
21 include/stop_slave.inc
22 SET GLOBAL slave_parallel_threads=10;
23 CHANGE MASTER TO master_use_gtid=slave_pos;
24 SET @old_parallel_mode=@@GLOBAL.slave_parallel_mode;
25 SET GLOBAL slave_parallel_mode='optimistic';
26 *** MDEV-6676: Test that @@skip_parallel_replication is preserved in slave binlog ***
27 connection server_1;
28 INSERT INTO t1 VALUES(1,1);
29 BEGIN;
30 INSERT INTO t1 VALUES(2,1);
31 INSERT INTO t1 VALUES(3,1);
32 COMMIT;
33 SET SESSION skip_parallel_replication=1;
34 UPDATE t1 SET b=b+1 WHERE a=2;
35 UPDATE t1 SET b=b+1 WHERE a=2;
36 UPDATE t1 SET b=b+1 WHERE a=2;
37 UPDATE t1 SET b=b+1 WHERE a=2;
38 UPDATE t1 SET b=b+1 WHERE a=2;
39 UPDATE t1 SET b=b+1 WHERE a=2;
40 UPDATE t1 SET b=b+1 WHERE a=2;
41 UPDATE t1 SET b=b+1 WHERE a=2;
42 UPDATE t1 SET b=b+1 WHERE a=2;
43 UPDATE t1 SET b=b+1 WHERE a=2;
44 SET SESSION skip_parallel_replication=0;
45 SELECT * FROM t1 ORDER BY a;
46 a b
47 1 1
48 2 11
49 3 1
50 include/save_master_gtid.inc
51 connection server_2;
52 include/start_slave.inc
53 include/sync_with_master_gtid.inc
54 SELECT * FROM t1 ORDER BY a;
55 a b
56 1 1
57 2 11
58 3 1
59 status
60 Ok, no retry
61 connection server_3;
62 include/start_slave.inc
63 include/sync_with_master_gtid.inc
64 SELECT * FROM t1 ORDER BY a;
65 a b
66 1 1
67 2 11
68 3 1
69 status
70 Ok, no retry
71 connection server_4;
72 include/start_slave.inc
73 include/sync_with_master_gtid.inc
74 SELECT * FROM t1 ORDER BY a;
75 a b
76 1 1
77 2 11
78 3 1
79 status
80 Ok, no retry
81 *** MDEV-6676: Test that the FL_WAITED flag in GTID is preserved in slave binlog ***
82 connection server_2;
83 include/stop_slave.inc
84 CHANGE MASTER TO master_use_gtid=slave_pos;
85 SET GLOBAL slave_parallel_mode='optimistic';
86 connection server_3;
87 include/stop_slave.inc
88 CHANGE MASTER TO master_use_gtid=slave_pos;
89 SET GLOBAL slave_parallel_mode='optimistic';
90 connection server_4;
91 include/stop_slave.inc
92 CHANGE MASTER TO master_use_gtid=slave_pos;
93 SET GLOBAL slave_parallel_mode='optimistic';
94 connection server_1;
95 BEGIN;
96 UPDATE t1 SET b=b+1 WHERE a=2;
97 connect con_temp1,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
98 SET debug_sync="thd_report_wait_for SIGNAL waiting1";
99 UPDATE t1 SET b=b+1 WHERE a=2;
100 connection server_1;
101 SET debug_sync="now WAIT_FOR waiting1";
102 connect con_temp2,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
103 SET debug_sync="thd_report_wait_for SIGNAL waiting2";
104 UPDATE t1 SET b=b+1 WHERE a=2;
105 connection server_1;
106 SET debug_sync="now WAIT_FOR waiting2";
107 connect con_temp3,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
108 SET debug_sync="thd_report_wait_for SIGNAL waiting3";
109 UPDATE t1 SET b=b+1 WHERE a=2;
110 connection server_1;
111 SET debug_sync="now WAIT_FOR waiting3";
112 connect con_temp4,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
113 SET debug_sync="thd_report_wait_for SIGNAL waiting4";
114 UPDATE t1 SET b=b+1 WHERE a=2;
115 connection server_1;
116 SET debug_sync="now WAIT_FOR waiting4";
117 connect con_temp5,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
118 SET debug_sync="thd_report_wait_for SIGNAL waiting5";
119 UPDATE t1 SET b=b+1 WHERE a=2;
120 connection server_1;
121 SET debug_sync="now WAIT_FOR waiting5";
122 connect con_temp6,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
123 SET debug_sync="thd_report_wait_for SIGNAL waiting6";
124 UPDATE t1 SET b=b+1 WHERE a=2;
125 connection server_1;
126 SET debug_sync="now WAIT_FOR waiting6";
127 connect con_temp7,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
128 SET debug_sync="thd_report_wait_for SIGNAL waiting7";
129 UPDATE t1 SET b=b+1 WHERE a=2;
130 connection server_1;
131 SET debug_sync="now WAIT_FOR waiting7";
132 connect con_temp8,127.0.0.1,root,,test,$SERVER_MYPORT_1,;
133 SET debug_sync="thd_report_wait_for SIGNAL waiting8";
134 UPDATE t1 SET b=b+1 WHERE a=2;
135 connection server_1;
136 SET debug_sync="now WAIT_FOR waiting8";
137 COMMIT;
138 SET debug_sync="RESET";
139 connection con_temp1;
140 COMMIT;
141 connection con_temp2;
142 COMMIT;
143 connection con_temp3;
144 COMMIT;
145 connection con_temp4;
146 COMMIT;
147 connection con_temp5;
148 COMMIT;
149 connection con_temp6;
150 COMMIT;
151 connection con_temp7;
152 COMMIT;
153 connection con_temp8;
154 connection server_1;
155 SELECT * FROM t1 ORDER BY a;
156 a b
157 1 1
158 2 20
159 3 1
160 include/save_master_gtid.inc
161 connection server_2;
162 include/start_slave.inc
163 include/sync_with_master_gtid.inc
164 SELECT * FROM t1 ORDER BY a;
165 a b
166 1 1
167 2 20
168 3 1
169 status
170 Ok, no retry
171 connection server_3;
172 include/start_slave.inc
173 include/sync_with_master_gtid.inc
174 SELECT * FROM t1 ORDER BY a;
175 a b
176 1 1
177 2 20
178 3 1
179 status
180 Ok, no retry
181 connection server_4;
182 include/start_slave.inc
183 include/sync_with_master_gtid.inc
184 SELECT * FROM t1 ORDER BY a;
185 a b
186 1 1
187 2 20
188 3 1
189 status
190 Ok, no retry
191 connection server_2;
192 include/stop_slave.inc
193 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
194 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
195 include/start_slave.inc
196 connection server_3;
197 include/stop_slave.inc
198 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
199 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
200 include/start_slave.inc
201 connection server_4;
202 include/stop_slave.inc
203 SET GLOBAL slave_parallel_mode=@old_parallel_mode;
204 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
205 include/start_slave.inc
206 connection server_1;
207 DROP TABLE t1;
208 include/rpl_end.inc