Debian Codegraph @

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

raw
1 --source include/not_embedded.inc
2 --source include/have_innodb.inc
3 --source include/have_debug.inc
4 --source include/not_windows.inc
5
6 --connect (server_1,127.0.0.1,root,,,$SERVER_MYPORT_1)
7 --connect (server_2,127.0.0.1,root,,,$SERVER_MYPORT_2)
8 --connect (server_3,127.0.0.1,root,,,$SERVER_MYPORT_3)
9 --connect (server_4,127.0.0.1,root,,,$SERVER_MYPORT_4)
10
11 --connection server_1
12 create database a;
13 use a;
14 create table t1(a int);
15 insert into t1 values(1);
16 create table t2(a int);
17 insert into t2 values(1);
18 --save_master_pos
19
20 --connection server_2
21 create database b;
22 use b;
23 create table t1(a int);
24 insert into t1 values(1);
25 create table t2(a int);
26 insert into t2 values(1);
27 --save_master_pos
28
29 --connection server_3
30 create database c;
31 use c;
32 create table t1(a int);
33 insert into t1 values(1);
34 create table t2(a int);
35 insert into t2 values(1);
36 --save_master_pos
37
38 --connection server_4
39 --disable_warnings
40 --replace_result $SERVER_MYPORT_1 MYPORT_1
41 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;
42 --replace_result $SERVER_MYPORT_2 MYPORT_2
43 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;
44 --replace_result $SERVER_MYPORT_3 MYPORT_3
45 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;
46 start all slaves;
47 set default_master_connection = 'm1';
48 --source include/wait_for_slave_to_start.inc
49 set default_master_connection = 'm2';
50 --source include/wait_for_slave_to_start.inc
51 set default_master_connection = '';
52 --source include/wait_for_slave_to_start.inc
53
54 --enable_warnings
55 --sync_with_master 0,'m1'
56 --sync_with_master 0,'m2'
57 --sync_with_master 0,''
58 use a;
59 show tables;
60 use b;
61 show tables;
62 use c;
63 show tables;
64 --echo #TEST
65 SET default_master_connection = "m1";
66 --let $old_m1 = query_get_value("show relaylog events;", "Log_name",1)
67 SET default_master_connection = "m2";
68 --let $old_m2 = query_get_value("show relaylog events;", "Log_name",1)
69 SET default_master_connection = "";
70 --let $old__ = query_get_value("show relaylog events;", "Log_name",1)
71 flush logs;
72 --sleep 2
73 --let $MYSQLD_DATADIR = `select @@datadir`
74 SET default_master_connection = "m1";
75 --let $new_m1 = query_get_value("show relaylog events;", "Log_name",1)
76 --if ($new_m1 != $old_m1) {
77 --echo #log Rotated
78 --exec ls $MYSQLD_DATADIR | grep "mysqld-relay-bin\."
79 }
80 SET default_master_connection = "m2";
81 --let $new_m2 = query_get_value("show relaylog events;", "Log_name",1)
82 --if ($new_m2 != $old_m2) {
83 --echo #log Rotated
84 --exec ls $MYSQLD_DATADIR | grep "mysqld-relay-bin-m1"
85 }
86 SET default_master_connection = "";
87 --let $new__ = query_get_value("show relaylog events;", "Log_name",1)
88 --if ($new__ != $old__) {
89 --echo #log Rotated
90 --exec ls $MYSQLD_DATADIR | grep "mysqld-relay-bin-m2"
91 }
92
93 --echo #CleanUp
94 --connection server_1
95 drop database a;
96 --save_master_pos
97
98 --connection server_2
99 drop database b;
100 --save_master_pos
101
102 --connection server_3
103 drop database c;
104 --save_master_pos
105
106 --connection server_4
107 --sync_with_master 0,'m1'
108 --sync_with_master 0,'m2'
109 --sync_with_master 0,''
110 stop all slaves;
111 SET default_master_connection = "m1";
112 --source include/wait_for_slave_to_stop.inc
113 SET default_master_connection = "m2";
114 --source include/wait_for_slave_to_stop.inc
115 SET default_master_connection = "";
116 --source include/wait_for_slave_to_stop.inc
117
118 # Reset for check-testcase
119 change master to master_use_gtid=slave_pos;
120 change master 'm1' to master_use_gtid=slave_pos;
121 change master 'm2' to master_use_gtid=slave_pos;