Debian Codegraph @

mysql-test/suite/multi_source/mdev-8874.result

raw
1 connect server_1,127.0.0.1,root,,,$SERVER_MYPORT_1;
2 connect server_2,127.0.0.1,root,,,$SERVER_MYPORT_2;
3 connect server_3,127.0.0.1,root,,,$SERVER_MYPORT_3;
4 connect server_4,127.0.0.1,root,,,$SERVER_MYPORT_4;
5 connection server_1;
6 create database a;
7 use a;
8 create table t1(a int);
9 insert into t1 values(1);
10 create table t2(a int);
11 insert into t2 values(1);
12 connection server_2;
13 create database b;
14 use b;
15 create table t1(a int);
16 insert into t1 values(1);
17 create table t2(a int);
18 insert into t2 values(1);
19 connection server_3;
20 create database c;
21 use c;
22 create table t1(a int);
23 insert into t1 values(1);
24 create table t2(a int);
25 insert into t2 values(1);
26 connection server_4;
27 change master 'm1' to master_port=MYPORT_1 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
28 change master 'm2' to master_port=MYPORT_2 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
29 change master to master_port=MYPORT_3 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
30 start all slaves;
31 set default_master_connection = 'm1';
32 include/wait_for_slave_to_start.inc
33 set default_master_connection = 'm2';
34 include/wait_for_slave_to_start.inc
35 set default_master_connection = '';
36 include/wait_for_slave_to_start.inc
37 select @@global.'m1'.replicate_ignore_table;
38 @@global.'m1'.replicate_ignore_table
39 a.t1
40 select @@global.'m2'.replicate_ignore_table;
41 @@global.'m2'.replicate_ignore_table
42 b.t1
43 select @@global.replicate_ignore_table;
44 @@global.replicate_ignore_table
45 c.t1
46 use a;
47 #No t1 table
48 show tables;
49 Tables_in_a
50 t2
51 use b;
52 #No t1 table
53 show tables;
54 Tables_in_b
55 t2
56 use c;
57 #No t1 table
58 show tables;
59 Tables_in_c
60 t2
61 #TEST
62 STOP ALL SLAVES;
63 Warnings:
64 Note 1938 SLAVE 'm2' stopped
65 Note 1938 SLAVE '' stopped
66 Note 1938 SLAVE 'm1' stopped
67 RESET SLAVE 'm1' ALL ;
68 Warnings:
69 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
70 RESET SLAVE 'm2' ALL ;
71 Warnings:
72 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
73 RESET SLAVE ALL ;
74 Warnings:
75 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'
76 drop database a;
77 drop database b;
78 drop database c;
79 change master 'm1' to master_port=MYPORT_1 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
80 change master 'm2' to master_port=MYPORT_2 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
81 change master to master_port=MYPORT_3 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
82 start all slaves;
83 Warnings:
84 Note 1937 SLAVE 'm2' started
85 Note 1937 SLAVE '' started
86 Note 1937 SLAVE 'm1' started
87 set default_master_connection = 'm1';
88 include/wait_for_slave_to_start.inc
89 set default_master_connection = 'm2';
90 include/wait_for_slave_to_start.inc
91 set default_master_connection = '';
92 include/wait_for_slave_to_start.inc
93 #Replication Filter should be intact (t1 still not replicated)
94 select @@global.'m1'.replicate_ignore_table;
95 @@global.'m1'.replicate_ignore_table
96 a.t1
97 select @@global.'m2'.replicate_ignore_table;
98 @@global.'m2'.replicate_ignore_table
99 b.t1
100 select @@global.replicate_ignore_table;
101 @@global.replicate_ignore_table
102 c.t1
103 use a;
104 #No t1 table
105 show tables;
106 Tables_in_a
107 t2
108 use b;
109 #No t1 table
110 show tables;
111 Tables_in_b
112 t2
113 use c;
114 #No t1 table
115 show tables;
116 Tables_in_c
117 t2
118 #CleanUp
119 connection server_1;
120 drop database a;
121 connection server_2;
122 drop database b;
123 connection server_3;
124 drop database c;
125 connection server_4;
126 stop all slaves;
127 SET default_master_connection = "m1";
128 include/wait_for_slave_to_stop.inc
129 SET default_master_connection = "m2";
130 include/wait_for_slave_to_stop.inc
131 SET default_master_connection = "";
132 include/wait_for_slave_to_stop.inc
133 RESET SLAVE ALL;
134 Warnings:
135 Note 4190 RESET SLAVE is implicitly changing the value of 'Using_Gtid' from 'No' to 'Slave_Pos'