Debian Codegraph @

mysql-test/suite/binlog_encryption/multisource.result

raw
1 connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
2 change master 'abc' to relay_log_file='';
3 ERROR HY000: Failed initializing relay log position: Could not find target log during relay log initialization
4 change master 'abc2' to master_host='';
5 ERROR HY000: Incorrect arguments to MASTER_HOST
6 change master 'master1' to
7 master_port=MYPORT_1,
8 master_host='127.0.0.1',
9 master_user='root',
10 master_ssl_verify_server_cert=0;
11 start slave 'master1';
12 set default_master_connection = 'master1';
13 include/wait_for_slave_to_start.inc
14 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
15 connection slave;
16 #
17 # Checking SHOW SLAVE 'master1' STATUS
18 #
19 Master_Port = 'MYPORT_1'
20 Relay_Log_File = 'mysqld-relay-bin-master1.000002'
21 Slave_IO_Running = 'Yes'
22 Slave_SQL_Running = 'Yes'
23 Last_Errno = '0'
24 Last_SQL_Errno = '0'
25 #
26 # Checking SHOW SLAVE STATUS
27 #
28 Master_Port = 'MYPORT_1'
29 Relay_Log_File = 'mysqld-relay-bin-master1.000002'
30 Slave_IO_Running = 'Yes'
31 Slave_SQL_Running = 'Yes'
32 Last_Errno = '0'
33 Last_SQL_Errno = '0'
34 #
35 # Checking SHOW ALL SLAVES STATUS
36 #
37 Connection_name = 'master1'
38 Master_Port = 'MYPORT_1'
39 Relay_Log_File = 'mysqld-relay-bin-master1.000002'
40 Slave_IO_Running = 'Yes'
41 Slave_SQL_Running = 'Yes'
42 Last_Errno = '0'
43 Last_SQL_Errno = '0'
44 Slave_heartbeat_period = '60.000'
45 #
46 connection master1;
47 drop database if exists db1;
48 create database db1;
49 use db1;
50 create table t1 (i int auto_increment, f1 varchar(16), primary key pk (i,f1)) engine=MyISAM;
51 Warnings:
52 Warning 1280 Name 'pk' ignored for PRIMARY key.
53 insert into t1 (f1) values ('one'),('two');
54 connection slave;
55 select * from db1.t1;
56 i f1
57 1 one
58 2 two
59 # List of relay log files in the datadir
60 mysqld-relay-bin-master1.000001
61 mysqld-relay-bin-master1.000002
62 mysqld-relay-bin-master1.index
63 include/show_events.inc
64 Log_name Pos Event_type Server_id End_log_pos Info
65 mysqld-relay-bin-master1.000001 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
66 mysqld-relay-bin-master1.000001 # Rotate # # mysqld-relay-bin-master1.000002;pos=4
67 include/show_events.inc
68 Log_name Pos Event_type Server_id End_log_pos Info
69 mysqld-relay-bin-master1.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
70 mysqld-relay-bin-master1.000002 # Rotate # # master-bin.000001;pos=POS
71 mysqld-relay-bin-master1.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
72 mysqld-relay-bin-master1.000002 # Gtid_list # # []
73 mysqld-relay-bin-master1.000002 # Binlog_checkpoint # # master-bin.000001
74 mysqld-relay-bin-master1.000002 # Gtid # # GTID #-#-#
75 mysqld-relay-bin-master1.000002 # Query # # drop database if exists db1
76 mysqld-relay-bin-master1.000002 # Gtid # # GTID #-#-#
77 mysqld-relay-bin-master1.000002 # Query # # create database db1
78 mysqld-relay-bin-master1.000002 # Gtid # # GTID #-#-#
79 mysqld-relay-bin-master1.000002 # Query # # use `db1`; create table t1 (i int auto_increment, f1 varchar(16), primary key pk (i,f1)) engine=MyISAM
80 mysqld-relay-bin-master1.000002 # Gtid # # BEGIN GTID #-#-#
81 mysqld-relay-bin-master1.000002 # Intvar # # INSERT_ID=1
82 mysqld-relay-bin-master1.000002 # Query # # use `db1`; insert into t1 (f1) values ('one'),('two')
83 mysqld-relay-bin-master1.000002 # Query # # COMMIT
84 change master 'master1' to
85 master_port=MYPORT_2,
86 master_host='127.0.0.1',
87 master_user='root';
88 ERROR HY000: This operation cannot be performed as you have a running slave 'master1'; run STOP SLAVE 'master1' first
89 change master to
90 master_port=MYPORT_2,
91 master_host='127.0.0.1',
92 master_user='root';
93 ERROR HY000: This operation cannot be performed as you have a running slave 'master1'; run STOP SLAVE 'master1' first
94 change master 'master2' to
95 master_port=MYPORT_1,
96 master_host='127.0.0.1',
97 master_user='root';
98 ERROR HY000: Connection 'master2' conflicts with existing connection 'master1'
99 set default_master_connection = '';
100 change master to
101 master_port=MYPORT_2,
102 master_host='127.0.0.1',
103 master_user='root',
104 master_ssl_verify_server_cert=0,
105 master_use_gtid=no;
106 start slave;
107 include/wait_for_slave_to_start.inc
108 #
109 # Checking SHOW ALL SLAVES STATUS
110 #
111 Connection_name = ''
112 Connection_name = 'master1'
113 Master_Port = 'MYPORT_2'
114 Master_Port = 'MYPORT_1'
115 Relay_Log_File = 'mysqld-relay-bin.000002'
116 Relay_Log_File = 'mysqld-relay-bin-master1.000002'
117 Slave_IO_Running = 'Yes'
118 Slave_IO_Running = 'Yes'
119 Slave_SQL_Running = 'Yes'
120 Slave_SQL_Running = 'Yes'
121 Last_Errno = '0'
122 Last_Errno = '0'
123 Last_SQL_Errno = '0'
124 Last_SQL_Errno = '0'
125 Slave_heartbeat_period = '60.000'
126 Slave_heartbeat_period = '60.000'
127 #
128 connection master1;
129 insert into t1 (f1) values ('three');
130 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
131 drop database if exists db2;
132 create database db2;
133 use db2;
134 create table t1 (pk int auto_increment primary key, f1 int) engine=InnoDB;
135 begin;
136 insert into t1 (f1) values (1),(2);
137 connection slave;
138 connection master2;
139 connection slave;
140 select * from db1.t1;
141 i f1
142 1 one
143 2 two
144 3 three
145 select * from db2.t1;
146 pk f1
147 connection master2;
148 commit;
149 connection slave;
150 select * from db2.t1;
151 pk f1
152 1 1
153 2 2
154 connection master1;
155 flush logs;
156 connection slave;
157 connection master1;
158 purge binary logs to 'master-bin.000002';
159 show binary logs;
160 Log_name File_size
161 master-bin.000002 filesize
162 insert into t1 (f1) values ('four');
163 create table db1.t3 (f1 int) engine=InnoDB;
164 connection slave;
165 #
166 # Checking SHOW ALL SLAVES STATUS
167 #
168 Connection_name = ''
169 Connection_name = 'master1'
170 Master_Port = 'MYPORT_2'
171 Master_Port = 'MYPORT_1'
172 Relay_Log_File = 'mysqld-relay-bin.000002'
173 Relay_Log_File = 'mysqld-relay-bin-master1.000004'
174 Slave_IO_Running = 'Yes'
175 Slave_IO_Running = 'Yes'
176 Slave_SQL_Running = 'Yes'
177 Slave_SQL_Running = 'Yes'
178 Last_Errno = '0'
179 Last_Errno = '0'
180 Last_SQL_Errno = '0'
181 Last_SQL_Errno = '0'
182 Slave_heartbeat_period = '60.000'
183 Slave_heartbeat_period = '60.000'
184 #
185 #
186 # MDEV:16437: merge 5.7 P_S replication instrumentation and tables
187 #
188 SELECT * FROM performance_schema.replication_applier_status_by_coordinator;
189 CHANNEL_NAME master1
190 THREAD_ID #
191 SERVICE_STATE ON
192 LAST_ERROR_NUMBER 0
193 LAST_ERROR_MESSAGE
194 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00
195 LAST_SEEN_TRANSACTION 0-1-7
196 LAST_TRANS_RETRY_COUNT 0
197 CHANNEL_NAME
198 THREAD_ID #
199 SERVICE_STATE ON
200 LAST_ERROR_NUMBER 0
201 LAST_ERROR_MESSAGE
202 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00
203 LAST_SEEN_TRANSACTION 0-2-4
204 LAST_TRANS_RETRY_COUNT 0
205 select * from db1.t1;
206 i f1
207 1 one
208 2 two
209 3 three
210 4 four
211 include/show_events.inc
212 Log_name Pos Event_type Server_id End_log_pos Info
213 mysqld-relay-bin.000001 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
214 mysqld-relay-bin.000001 # Rotate # # mysqld-relay-bin.000002;pos=4
215 include/show_events.inc
216 Log_name Pos Event_type Server_id End_log_pos Info
217 mysqld-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
218 mysqld-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS
219 mysqld-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
220 mysqld-relay-bin.000002 # Gtid_list # # []
221 mysqld-relay-bin.000002 # Binlog_checkpoint # # master-bin.000001
222 mysqld-relay-bin.000002 # Gtid # # GTID #-#-#
223 mysqld-relay-bin.000002 # Query # # drop database if exists db2
224 mysqld-relay-bin.000002 # Gtid # # GTID #-#-#
225 mysqld-relay-bin.000002 # Query # # create database db2
226 mysqld-relay-bin.000002 # Gtid # # GTID #-#-#
227 mysqld-relay-bin.000002 # Query # # use `db2`; create table t1 (pk int auto_increment primary key, f1 int) engine=InnoDB
228 mysqld-relay-bin.000002 # Gtid # # BEGIN GTID #-#-#
229 mysqld-relay-bin.000002 # Intvar # # INSERT_ID=1
230 mysqld-relay-bin.000002 # Query # # use `db2`; insert into t1 (f1) values (1),(2)
231 mysqld-relay-bin.000002 # Xid # # COMMIT /* XID */
232 disconnect slave;
233 connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
234 stop slave io_thread;
235 show status like 'Slave_running';
236 Variable_name Value
237 Slave_running OFF
238 set default_master_connection = 'master1';
239 show status like 'Slave_running';
240 Variable_name Value
241 Slave_running ON
242 drop database db1;
243 drop database db2;
244 include/reset_master_slave.inc
245 disconnect slave;
246 connection master1;
247 drop database db1;
248 include/reset_master_slave.inc
249 disconnect master1;
250 connection master2;
251 drop database db2;
252 include/reset_master_slave.inc
253 disconnect master2;