Debian Codegraph @

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

raw
1 --source include/not_embedded.inc
2 --source include/have_innodb.inc
3 --source include/have_debug.inc
4 # MDEV-8874
5 # In Named Master slave connection if we do reset slave 'connection_name' ALL and then
6 # if we reconnect slave, replication filters are ignored.
7 # This patch fixes this issue.
8 --connect (server_1,127.0.0.1,root,,,$SERVER_MYPORT_1)
9 --connect (server_2,127.0.0.1,root,,,$SERVER_MYPORT_2)
10 --connect (server_3,127.0.0.1,root,,,$SERVER_MYPORT_3)
11 --connect (server_4,127.0.0.1,root,,,$SERVER_MYPORT_4)
12
13 --connection server_1
14 create database a;
15 use a;
16 create table t1(a int);
17 insert into t1 values(1);
18 create table t2(a int);
19 insert into t2 values(1);
20 --save_master_pos
21
22 --connection server_2
23 create database b;
24 use b;
25 create table t1(a int);
26 insert into t1 values(1);
27 create table t2(a int);
28 insert into t2 values(1);
29 --save_master_pos
30
31 --connection server_3
32 create database c;
33 use c;
34 create table t1(a int);
35 insert into t1 values(1);
36 create table t2(a int);
37 insert into t2 values(1);
38 --save_master_pos
39
40 --connection server_4
41 --disable_warnings
42 --replace_result $SERVER_MYPORT_1 MYPORT_1
43 eval change master 'm1' to master_port=$SERVER_MYPORT_1 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
44 --replace_result $SERVER_MYPORT_2 MYPORT_2
45 eval change master 'm2' to master_port=$SERVER_MYPORT_2 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
46 --replace_result $SERVER_MYPORT_3 MYPORT_3
47 eval change master to master_port=$SERVER_MYPORT_3 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
48 start all slaves;
49 set default_master_connection = 'm1';
50 --source include/wait_for_slave_to_start.inc
51 set default_master_connection = 'm2';
52 --source include/wait_for_slave_to_start.inc
53 set default_master_connection = '';
54 --source include/wait_for_slave_to_start.inc
55 select @@global.'m1'.replicate_ignore_table;
56 select @@global.'m2'.replicate_ignore_table;
57 select @@global.replicate_ignore_table;
58
59 --enable_warnings
60 --sync_with_master 0,'m1'
61 --sync_with_master 0,'m2'
62 --sync_with_master 0,''
63 use a;
64 --echo #No t1 table
65 show tables;
66 use b;
67 --echo #No t1 table
68 show tables;
69 use c;
70 --echo #No t1 table
71 show tables;
72 --echo #TEST
73 STOP ALL SLAVES;
74 RESET SLAVE 'm1' ALL ;
75 RESET SLAVE 'm2' ALL ;
76 RESET SLAVE ALL ;
77 drop database a;
78 drop database b;
79 drop database c;
80 --replace_result $SERVER_MYPORT_1 MYPORT_1
81 eval change master 'm1' to master_port=$SERVER_MYPORT_1 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
82 --replace_result $SERVER_MYPORT_2 MYPORT_2
83 eval change master 'm2' to master_port=$SERVER_MYPORT_2 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
84 --replace_result $SERVER_MYPORT_3 MYPORT_3
85 eval change master to master_port=$SERVER_MYPORT_3 , master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0, master_use_gtid=no;
86 start all slaves;
87 set default_master_connection = 'm1';
88 --source include/wait_for_slave_to_start.inc
89 set default_master_connection = 'm2';
90 --source include/wait_for_slave_to_start.inc
91 set default_master_connection = '';
92 --source include/wait_for_slave_to_start.inc
93 --sync_with_master 0,'m1'
94 --sync_with_master 0,'m2'
95 --sync_with_master 0,''
96
97 --echo #Replication Filter should be intact (t1 still not replicated)
98 select @@global.'m1'.replicate_ignore_table;
99 select @@global.'m2'.replicate_ignore_table;
100 select @@global.replicate_ignore_table;
101 use a;
102 --echo #No t1 table
103 show tables;
104 use b;
105 --echo #No t1 table
106 show tables;
107 use c;
108 --echo #No t1 table
109 show tables;
110
111
112 #--echo #restart the server
113 #--source include/restart_mysqld.inc
114
115
116 --echo #CleanUp
117 --connection server_1
118 drop database a;
119 --save_master_pos
120
121 --connection server_2
122 drop database b;
123 --save_master_pos
124
125 --connection server_3
126 drop database c;
127 --save_master_pos
128
129 --connection server_4
130 --sync_with_master 0,'m1'
131 --sync_with_master 0,'m2'
132 --sync_with_master 0,''
133 --disable_warnings
134 stop all slaves;
135 --enable_warnings
136 SET default_master_connection = "m1";
137 --source include/wait_for_slave_to_stop.inc
138 SET default_master_connection = "m2";
139 --source include/wait_for_slave_to_stop.inc
140 SET default_master_connection = "";
141 --source include/wait_for_slave_to_stop.inc
142 RESET SLAVE ALL;