Debian Codegraph @

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

raw
1 include/rpl_init.inc [topology=1->2,1->3]
2 connect server_2b,127.0.0.1,root,,,$SERVER_MYPORT_2;
3 connection server_2;
4 SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
5 SET @old_parallel_mode= @@GLOBAL.slave_parallel_mode;
6 SET @old_timeout= @@GLOBAL.lock_wait_timeout;
7 SET @old_innodb_timeout= @@GLOBAL.innodb_lock_wait_timeout;
8 include/stop_slave.inc
9 SET GLOBAL slave_parallel_threads=5;
10 set global slave_parallel_mode= aggressive;
11 SET GLOBAL lock_wait_timeout= 86400;
12 SET GLOBAL innodb_lock_wait_timeout= 86400;
13 SET STATEMENT sql_log_bin=0 FOR ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
14 include/start_slave.inc
15 connection server_1;
16 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB;
17 INSERT INTO t1 VALUES (1, 0), (2, 0), (3, 0), (4, 0), (5, 0), (6, 0), (7, 0), (8, 0);
18 connection server_2;
19 include/stop_slave.inc
20 connection server_2b;
21 BEGIN;
22 SELECT * FROM t1 WHERE a=1 FOR UPDATE;
23 a b
24 1 0
25 SELECT * FROM t1 WHERE a=5 FOR UPDATE;
26 a b
27 5 0
28 connection server_1;
29 SET SESSION gtid_domain_id= 1;
30 BEGIN;
31 UPDATE t1 SET b=1 WHERE a=1;
32 UPDATE t1 SET b=1 WHERE a=7;
33 COMMIT;
34 UPDATE t1 SET b=2 WHERE a=3;
35 SET SESSION gtid_domain_id=2;
36 BEGIN;
37 UPDATE t1 SET b=3 WHERE a=5;
38 UPDATE t1 SET b=3 WHERE a=3;
39 COMMIT;
40 UPDATE t1 SET b=4 WHERE a=7;
41 SET SESSION gtid_domain_id= 0;
42 include/save_master_gtid.inc
43 connection server_2;
44 include/start_slave.inc
45 connection server_2b;
46 ROLLBACK;
47 connection server_2;
48 include/sync_with_master_gtid.inc
49 SELECT a, (
50 (a=1 AND b=1) OR
51 (a=3 AND (b=2 OR b=3)) OR
52 (a=5 AND b=3) OR
53 (a=7 AND (b=1 OR b=4)) OR
54 ((a MOD 2)=0 AND b=0)) AS `ok`
55 FROM t1
56 ORDER BY a;
57 a ok
58 1 1
59 2 1
60 3 1
61 4 1
62 5 1
63 6 1
64 7 1
65 8 1
66 connection server_3;
67 include/sync_with_master_gtid.inc
68 include/stop_slave.inc
69 connection server_2;
70 include/stop_slave.inc
71 CHANGE MASTER 'm2' to master_port=MYPORT_3 , master_host='127.0.0.1', master_user='root', master_use_gtid=slave_pos, master_ssl_verify_server_cert=0;
72 connection server_1;
73 SET SESSION gtid_domain_id= 1;
74 BEGIN;
75 UPDATE t1 SET b=11 WHERE a=1;
76 UPDATE t1 SET b=11 WHERE a=7;
77 COMMIT;
78 UPDATE t1 SET b=12 WHERE a=3;
79 SET SESSION gtid_domain_id= 1;
80 connection server_3;
81 SET SESSION gtid_domain_id=3;
82 BEGIN;
83 UPDATE t1 SET b=13 WHERE a=5;
84 UPDATE t1 SET b=13 WHERE a=3;
85 COMMIT;
86 UPDATE t1 SET b=14 WHERE a=7;
87 include/save_master_gtid.inc
88 connection server_2b;
89 BEGIN;
90 SELECT * FROM t1 WHERE a=1 FOR UPDATE;
91 a b
92 1 1
93 SELECT * FROM t1 WHERE a=5 FOR UPDATE;
94 a b
95 5 3
96 START ALL SLAVES;
97 Warnings:
98 Note 1937 SLAVE 'm2' started
99 Note 1937 SLAVE '' started
100 connection server_2b;
101 ROLLBACK;
102 connection server_1;
103 include/save_master_gtid.inc
104 connection server_2;
105 include/sync_with_master_gtid.inc
106 connection server_3;
107 include/save_master_gtid.inc
108 connection server_2;
109 include/sync_with_master_gtid.inc
110 SELECT a, (
111 (a=1 AND b=11) OR
112 (a=3 AND (b=12 OR b=13)) OR
113 (a=5 AND b=13) OR
114 (a=7 AND (b=11 OR b=14)) OR
115 ((a MOD 2)=0 AND b=0)) AS `ok`
116 FROM t1
117 ORDER BY a;
118 a ok
119 1 1
120 2 1
121 3 1
122 4 1
123 5 1
124 6 1
125 7 1
126 8 1
127 SET default_master_connection = 'm2';
128 include/stop_slave.inc
129 RESET SLAVE 'm2' ALL;
130 SET default_master_connection = '';
131 connection server_3;
132 include/start_slave.inc
133 disconnect server_2b;
134 connection server_1;
135 DROP TABLE t1;
136 connection server_2;
137 include/stop_slave.inc
138 SET GLOBAL slave_parallel_threads=@old_parallel_threads;
139 set global slave_parallel_mode= @old_parallel_mode;
140 SET GLOBAL lock_wait_timeout= @old_timeout;
141 SET GLOBAL innodb_lock_wait_timeout= @old_innodb_timeout;
142 include/start_slave.inc
143 include/rpl_end.inc