Debian Codegraph @

mysql-test/suite/multi_source/simple.result

raw
1 connect slave,127.0.0.1,root,,,$SERVER_MYPORT_3;
2 connect master1,127.0.0.1,root,,,$SERVER_MYPORT_1;
3 connect master2,127.0.0.1,root,,,$SERVER_MYPORT_2;
4 connection slave;
5 change master 'slave1' to master_port=MYPORT_1, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
6 change master 'slave2' to master_port=MYPORT_2, master_host='127.0.0.1', master_user='root', master_ssl_verify_server_cert=0;
7 start slave 'slave1';
8 set default_master_connection = 'slave1';
9 include/wait_for_slave_to_start.inc
10 set default_master_connection = 'slave2';
11 start all slaves;
12 Warnings:
13 Note 1937 SLAVE 'slave2' started
14 include/wait_for_slave_to_start.inc
15 set default_master_connection = '';
16 connection master1;
17 connection slave;
18 connection master2;
19 connection slave;
20 show all slaves status;
21 Connection_name slave1
22 Slave_SQL_State Slave has read all relay log; waiting for more updates
23 Slave_IO_State Waiting for master to send event
24 Master_Host 127.0.0.1
25 Master_User root
26 Master_Port MYPORT_1
27 Connect_Retry 60
28 Master_Log_File master-bin.000001
29 Read_Master_Log_Pos <read_master_log_pos>
30 Relay_Log_File mysqld-relay-bin-slave1.000002
31 Relay_Log_Pos <relay_log_pos>
32 Relay_Master_Log_File master-bin.000001
33 Slave_IO_Running Yes
34 Slave_SQL_Running Yes
35 Replicate_Do_DB
36 Replicate_Ignore_DB
37 Replicate_Do_Table
38 Replicate_Ignore_Table
39 Replicate_Wild_Do_Table
40 Replicate_Wild_Ignore_Table
41 Last_Errno 0
42 Last_Error
43 Skip_Counter 0
44 Exec_Master_Log_Pos <read_master_log_pos>
45 Relay_Log_Space <relay_log_space1>
46 Until_Condition None
47 Until_Log_File
48 Until_Log_Pos 0
49 Master_SSL_Allowed Yes
50 Master_SSL_CA_File
51 Master_SSL_CA_Path
52 Master_SSL_Cert
53 Master_SSL_Cipher
54 Master_SSL_Key
55 Seconds_Behind_Master 0
56 Master_SSL_Verify_Server_Cert No
57 Last_IO_Errno 0
58 Last_IO_Error
59 Last_SQL_Errno 0
60 Last_SQL_Error
61 Replicate_Ignore_Server_Ids
62 Master_Server_Id 1
63 Master_SSL_Crl
64 Master_SSL_Crlpath
65 Using_Gtid Slave_Pos
66 Gtid_IO_Pos
67 Replicate_Do_Domain_Ids
68 Replicate_Ignore_Domain_Ids
69 Parallel_Mode optimistic
70 SQL_Delay 0
71 SQL_Remaining_Delay NULL
72 Slave_SQL_Running_State Slave has read all relay log; waiting for more updates
73 Slave_DDL_Groups 0
74 Slave_Non_Transactional_Groups 0
75 Slave_Transactional_Groups 0
76 Replicate_Rewrite_DB
77 Retried_transactions 0
78 Max_relay_log_size 1073741824
79 Executed_log_entries 7
80 Slave_received_heartbeats 0
81 Slave_heartbeat_period 60.000
82 Gtid_Slave_Pos
83 Master_last_event_time NULL
84 Slave_last_event_time NULL
85 Master_Slave_time_diff NULL
86 Connection_name slave2
87 Slave_SQL_State Slave has read all relay log; waiting for more updates
88 Slave_IO_State Waiting for master to send event
89 Master_Host 127.0.0.1
90 Master_User root
91 Master_Port MYPORT_2
92 Connect_Retry 60
93 Master_Log_File master-bin.000001
94 Read_Master_Log_Pos <read_master_log_pos>
95 Relay_Log_File mysqld-relay-bin-slave2.000002
96 Relay_Log_Pos <relay_log_pos>
97 Relay_Master_Log_File master-bin.000001
98 Slave_IO_Running Yes
99 Slave_SQL_Running Yes
100 Replicate_Do_DB
101 Replicate_Ignore_DB
102 Replicate_Do_Table
103 Replicate_Ignore_Table
104 Replicate_Wild_Do_Table
105 Replicate_Wild_Ignore_Table
106 Last_Errno 0
107 Last_Error
108 Skip_Counter 0
109 Exec_Master_Log_Pos <read_master_log_pos>
110 Relay_Log_Space <relay_log_space1>
111 Until_Condition None
112 Until_Log_File
113 Until_Log_Pos 0
114 Master_SSL_Allowed Yes
115 Master_SSL_CA_File
116 Master_SSL_CA_Path
117 Master_SSL_Cert
118 Master_SSL_Cipher
119 Master_SSL_Key
120 Seconds_Behind_Master 0
121 Master_SSL_Verify_Server_Cert No
122 Last_IO_Errno 0
123 Last_IO_Error
124 Last_SQL_Errno 0
125 Last_SQL_Error
126 Replicate_Ignore_Server_Ids
127 Master_Server_Id 2
128 Master_SSL_Crl
129 Master_SSL_Crlpath
130 Using_Gtid Slave_Pos
131 Gtid_IO_Pos
132 Replicate_Do_Domain_Ids
133 Replicate_Ignore_Domain_Ids
134 Parallel_Mode optimistic
135 SQL_Delay 0
136 SQL_Remaining_Delay NULL
137 Slave_SQL_Running_State Slave has read all relay log; waiting for more updates
138 Slave_DDL_Groups 0
139 Slave_Non_Transactional_Groups 0
140 Slave_Transactional_Groups 0
141 Replicate_Rewrite_DB
142 Retried_transactions 0
143 Max_relay_log_size 1073741824
144 Executed_log_entries 7
145 Slave_received_heartbeats 0
146 Slave_heartbeat_period 60.000
147 Gtid_Slave_Pos
148 Master_last_event_time NULL
149 Slave_last_event_time NULL
150 Master_Slave_time_diff NULL
151 #
152 # MDEV:16437: merge 5.7 P_S replication instrumentation and tables
153 #
154 select * from performance_schema.replication_connection_configuration;
155 CHANNEL_NAME slave2
156 HOST 127.0.0.1
157 PORT #
158 USER root
159 USING_GTID SLAVE_POS
160 SSL_ALLOWED YES
161 SSL_CA_FILE
162 SSL_CA_PATH
163 SSL_CERTIFICATE
164 SSL_CIPHER
165 SSL_KEY
166 SSL_VERIFY_SERVER_CERTIFICATE NO
167 SSL_CRL_FILE
168 SSL_CRL_PATH
169 CONNECTION_RETRY_INTERVAL 60
170 CONNECTION_RETRY_COUNT 100000
171 HEARTBEAT_INTERVAL 60.000
172 IGNORE_SERVER_IDS
173 REPL_DO_DOMAIN_IDS
174 REPL_IGNORE_DOMAIN_IDS
175 CHANNEL_NAME slave1
176 HOST 127.0.0.1
177 PORT #
178 USER root
179 USING_GTID SLAVE_POS
180 SSL_ALLOWED YES
181 SSL_CA_FILE
182 SSL_CA_PATH
183 SSL_CERTIFICATE
184 SSL_CIPHER
185 SSL_KEY
186 SSL_VERIFY_SERVER_CERTIFICATE NO
187 SSL_CRL_FILE
188 SSL_CRL_PATH
189 CONNECTION_RETRY_INTERVAL 60
190 CONNECTION_RETRY_COUNT 100000
191 HEARTBEAT_INTERVAL 60.000
192 IGNORE_SERVER_IDS
193 REPL_DO_DOMAIN_IDS
194 REPL_IGNORE_DOMAIN_IDS
195 start all slaves;
196 #
197 # MDEV:16437: merge 5.7 P_S replication instrumentation and tables
198 #
199 select * from performance_schema.replication_applier_status_by_coordinator;
200 CHANNEL_NAME slave2
201 THREAD_ID #
202 SERVICE_STATE ON
203 LAST_ERROR_NUMBER 0
204 LAST_ERROR_MESSAGE
205 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00
206 LAST_SEEN_TRANSACTION
207 LAST_TRANS_RETRY_COUNT 0
208 CHANNEL_NAME slave1
209 THREAD_ID #
210 SERVICE_STATE ON
211 LAST_ERROR_NUMBER 0
212 LAST_ERROR_MESSAGE
213 LAST_ERROR_TIMESTAMP 0000-00-00 00:00:00
214 LAST_SEEN_TRANSACTION
215 LAST_TRANS_RETRY_COUNT 0
216 stop slave 'slave1';
217 show slave 'slave1' status;
218 Slave_IO_State
219 Master_Host 127.0.0.1
220 Master_User root
221 Master_Port MYPORT_1
222 Connect_Retry 60
223 Master_Log_File master-bin.000001
224 Read_Master_Log_Pos <read_master_log_pos>
225 Relay_Log_File mysqld-relay-bin-slave1.000002
226 Relay_Log_Pos <relay_log_pos>
227 Relay_Master_Log_File master-bin.000001
228 Slave_IO_Running No
229 Slave_SQL_Running No
230 Replicate_Do_DB
231 Replicate_Ignore_DB
232 Replicate_Do_Table
233 Replicate_Ignore_Table
234 Replicate_Wild_Do_Table
235 Replicate_Wild_Ignore_Table
236 Last_Errno 0
237 Last_Error
238 Skip_Counter 0
239 Exec_Master_Log_Pos <read_master_log_pos>
240 Relay_Log_Space <relay_log_space1>
241 Until_Condition None
242 Until_Log_File
243 Until_Log_Pos 0
244 Master_SSL_Allowed Yes
245 Master_SSL_CA_File
246 Master_SSL_CA_Path
247 Master_SSL_Cert
248 Master_SSL_Cipher
249 Master_SSL_Key
250 Seconds_Behind_Master NULL
251 Master_SSL_Verify_Server_Cert No
252 Last_IO_Errno 0
253 Last_IO_Error
254 Last_SQL_Errno 0
255 Last_SQL_Error
256 Replicate_Ignore_Server_Ids
257 Master_Server_Id 1
258 Master_SSL_Crl
259 Master_SSL_Crlpath
260 Using_Gtid Slave_Pos
261 Gtid_IO_Pos
262 Replicate_Do_Domain_Ids
263 Replicate_Ignore_Domain_Ids
264 Parallel_Mode optimistic
265 SQL_Delay 0
266 SQL_Remaining_Delay NULL
267 Slave_SQL_Running_State
268 Slave_DDL_Groups 0
269 Slave_Non_Transactional_Groups 0
270 Slave_Transactional_Groups 0
271 Replicate_Rewrite_DB
272 reset slave 'slave1';
273 show all slaves status;
274 Connection_name slave1
275 Slave_SQL_State
276 Slave_IO_State
277 Master_Host 127.0.0.1
278 Master_User root
279 Master_Port MYPORT_1
280 Connect_Retry 60
281 Master_Log_File
282 Read_Master_Log_Pos 4
283 Relay_Log_File
284 Relay_Log_Pos <relay_log_pos>
285 Relay_Master_Log_File
286 Slave_IO_Running No
287 Slave_SQL_Running No
288 Replicate_Do_DB
289 Replicate_Ignore_DB
290 Replicate_Do_Table
291 Replicate_Ignore_Table
292 Replicate_Wild_Do_Table
293 Replicate_Wild_Ignore_Table
294 Last_Errno 0
295 Last_Error
296 Skip_Counter 0
297 Exec_Master_Log_Pos 0
298 Relay_Log_Space <relay_log_space1>
299 Until_Condition None
300 Until_Log_File
301 Until_Log_Pos 0
302 Master_SSL_Allowed Yes
303 Master_SSL_CA_File
304 Master_SSL_CA_Path
305 Master_SSL_Cert
306 Master_SSL_Cipher
307 Master_SSL_Key
308 Seconds_Behind_Master NULL
309 Master_SSL_Verify_Server_Cert No
310 Last_IO_Errno 0
311 Last_IO_Error
312 Last_SQL_Errno 0
313 Last_SQL_Error
314 Replicate_Ignore_Server_Ids
315 Master_Server_Id 1
316 Master_SSL_Crl
317 Master_SSL_Crlpath
318 Using_Gtid Slave_Pos
319 Gtid_IO_Pos
320 Replicate_Do_Domain_Ids
321 Replicate_Ignore_Domain_Ids
322 Parallel_Mode optimistic
323 SQL_Delay 0
324 SQL_Remaining_Delay NULL
325 Slave_SQL_Running_State
326 Slave_DDL_Groups 0
327 Slave_Non_Transactional_Groups 0
328 Slave_Transactional_Groups 0
329 Replicate_Rewrite_DB
330 Retried_transactions 0
331 Max_relay_log_size 1073741824
332 Executed_log_entries 7
333 Slave_received_heartbeats 0
334 Slave_heartbeat_period 60.000
335 Gtid_Slave_Pos
336 Master_last_event_time NULL
337 Slave_last_event_time NULL
338 Master_Slave_time_diff NULL
339 Connection_name slave2
340 Slave_SQL_State Slave has read all relay log; waiting for more updates
341 Slave_IO_State Waiting for master to send event
342 Master_Host 127.0.0.1
343 Master_User root
344 Master_Port MYPORT_2
345 Connect_Retry 60
346 Master_Log_File master-bin.000001
347 Read_Master_Log_Pos <read_master_log_pos>
348 Relay_Log_File mysqld-relay-bin-slave2.000002
349 Relay_Log_Pos <relay_log_pos>
350 Relay_Master_Log_File master-bin.000001
351 Slave_IO_Running Yes
352 Slave_SQL_Running Yes
353 Replicate_Do_DB
354 Replicate_Ignore_DB
355 Replicate_Do_Table
356 Replicate_Ignore_Table
357 Replicate_Wild_Do_Table
358 Replicate_Wild_Ignore_Table
359 Last_Errno 0
360 Last_Error
361 Skip_Counter 0
362 Exec_Master_Log_Pos <read_master_log_pos>
363 Relay_Log_Space <relay_log_space1>
364 Until_Condition None
365 Until_Log_File
366 Until_Log_Pos 0
367 Master_SSL_Allowed Yes
368 Master_SSL_CA_File
369 Master_SSL_CA_Path
370 Master_SSL_Cert
371 Master_SSL_Cipher
372 Master_SSL_Key
373 Seconds_Behind_Master 0
374 Master_SSL_Verify_Server_Cert No
375 Last_IO_Errno 0
376 Last_IO_Error
377 Last_SQL_Errno 0
378 Last_SQL_Error
379 Replicate_Ignore_Server_Ids
380 Master_Server_Id 2
381 Master_SSL_Crl
382 Master_SSL_Crlpath
383 Using_Gtid Slave_Pos
384 Gtid_IO_Pos
385 Replicate_Do_Domain_Ids
386 Replicate_Ignore_Domain_Ids
387 Parallel_Mode optimistic
388 SQL_Delay 0
389 SQL_Remaining_Delay NULL
390 Slave_SQL_Running_State Slave has read all relay log; waiting for more updates
391 Slave_DDL_Groups 0
392 Slave_Non_Transactional_Groups 0
393 Slave_Transactional_Groups 0
394 Replicate_Rewrite_DB
395 Retried_transactions 0
396 Max_relay_log_size 1073741824
397 Executed_log_entries 7
398 Slave_received_heartbeats 0
399 Slave_heartbeat_period 60.000
400 Gtid_Slave_Pos
401 Master_last_event_time NULL
402 Slave_last_event_time NULL
403 Master_Slave_time_diff NULL
404 reset slave 'slave1' all;
405 show all slaves status;
406 Connection_name slave2
407 Slave_SQL_State Slave has read all relay log; waiting for more updates
408 Slave_IO_State Waiting for master to send event
409 Master_Host 127.0.0.1
410 Master_User root
411 Master_Port MYPORT_2
412 Connect_Retry 60
413 Master_Log_File master-bin.000001
414 Read_Master_Log_Pos <read_master_log_pos>
415 Relay_Log_File mysqld-relay-bin-slave2.000002
416 Relay_Log_Pos <relay_log_pos>
417 Relay_Master_Log_File master-bin.000001
418 Slave_IO_Running Yes
419 Slave_SQL_Running Yes
420 Replicate_Do_DB
421 Replicate_Ignore_DB
422 Replicate_Do_Table
423 Replicate_Ignore_Table
424 Replicate_Wild_Do_Table
425 Replicate_Wild_Ignore_Table
426 Last_Errno 0
427 Last_Error
428 Skip_Counter 0
429 Exec_Master_Log_Pos <read_master_log_pos>
430 Relay_Log_Space <relay_log_space1>
431 Until_Condition None
432 Until_Log_File
433 Until_Log_Pos 0
434 Master_SSL_Allowed Yes
435 Master_SSL_CA_File
436 Master_SSL_CA_Path
437 Master_SSL_Cert
438 Master_SSL_Cipher
439 Master_SSL_Key
440 Seconds_Behind_Master 0
441 Master_SSL_Verify_Server_Cert No
442 Last_IO_Errno 0
443 Last_IO_Error
444 Last_SQL_Errno 0
445 Last_SQL_Error
446 Replicate_Ignore_Server_Ids
447 Master_Server_Id 2
448 Master_SSL_Crl
449 Master_SSL_Crlpath
450 Using_Gtid Slave_Pos
451 Gtid_IO_Pos
452 Replicate_Do_Domain_Ids
453 Replicate_Ignore_Domain_Ids
454 Parallel_Mode optimistic
455 SQL_Delay 0
456 SQL_Remaining_Delay NULL
457 Slave_SQL_Running_State Slave has read all relay log; waiting for more updates
458 Slave_DDL_Groups 0
459 Slave_Non_Transactional_Groups 0
460 Slave_Transactional_Groups 0
461 Replicate_Rewrite_DB
462 Retried_transactions 0
463 Max_relay_log_size 1073741824
464 Executed_log_entries 7
465 Slave_received_heartbeats 0
466 Slave_heartbeat_period 60.000
467 Gtid_Slave_Pos
468 Master_last_event_time NULL
469 Slave_last_event_time NULL
470 Master_Slave_time_diff NULL
471 stop all slaves;
472 Warnings:
473 Note 1938 SLAVE 'slave2' stopped
474 show all slaves status;
475 Connection_name slave2
476 Slave_SQL_State
477 Slave_IO_State
478 Master_Host 127.0.0.1
479 Master_User root
480 Master_Port MYPORT_2
481 Connect_Retry 60
482 Master_Log_File master-bin.000001
483 Read_Master_Log_Pos <read_master_log_pos>
484 Relay_Log_File mysqld-relay-bin-slave2.000002
485 Relay_Log_Pos <relay_log_pos>
486 Relay_Master_Log_File master-bin.000001
487 Slave_IO_Running No
488 Slave_SQL_Running No
489 Replicate_Do_DB
490 Replicate_Ignore_DB
491 Replicate_Do_Table
492 Replicate_Ignore_Table
493 Replicate_Wild_Do_Table
494 Replicate_Wild_Ignore_Table
495 Last_Errno 0
496 Last_Error
497 Skip_Counter 0
498 Exec_Master_Log_Pos <read_master_log_pos>
499 Relay_Log_Space <relay_log_space1>
500 Until_Condition None
501 Until_Log_File
502 Until_Log_Pos 0
503 Master_SSL_Allowed Yes
504 Master_SSL_CA_File
505 Master_SSL_CA_Path
506 Master_SSL_Cert
507 Master_SSL_Cipher
508 Master_SSL_Key
509 Seconds_Behind_Master NULL
510 Master_SSL_Verify_Server_Cert No
511 Last_IO_Errno 0
512 Last_IO_Error
513 Last_SQL_Errno 0
514 Last_SQL_Error
515 Replicate_Ignore_Server_Ids
516 Master_Server_Id 2
517 Master_SSL_Crl
518 Master_SSL_Crlpath
519 Using_Gtid Slave_Pos
520 Gtid_IO_Pos
521 Replicate_Do_Domain_Ids
522 Replicate_Ignore_Domain_Ids
523 Parallel_Mode optimistic
524 SQL_Delay 0
525 SQL_Remaining_Delay NULL
526 Slave_SQL_Running_State
527 Slave_DDL_Groups 0
528 Slave_Non_Transactional_Groups 0
529 Slave_Transactional_Groups 0
530 Replicate_Rewrite_DB
531 Retried_transactions 0
532 Max_relay_log_size 1073741824
533 Executed_log_entries 7
534 Slave_received_heartbeats 0
535 Slave_heartbeat_period 60.000
536 Gtid_Slave_Pos
537 Master_last_event_time NULL
538 Slave_last_event_time NULL
539 Master_Slave_time_diff NULL
540 stop all slaves;
541 #
542 # MDEV-21858: START/STOP ALL SLAVES does not return access errors
543 #
544 connection slave;
545 SET SESSION sql_log_bin=0;
546 CREATE USER 'unpriv'@'127.0.0.1';
547 GRANT USAGE ON *.* TO 'unpriv'@'127.0.0.1';
548 connect con1,127.0.0.1,unpriv,,,$SERVER_MYPORT_3;
549 STOP SLAVE 'slave2';
550 ERROR 42000: Access denied; you need (at least one of) the REPLICATION SLAVE ADMIN privilege(s) for this operation
551 START SLAVE 'slave2';
552 ERROR 42000: Access denied; you need (at least one of) the REPLICATION SLAVE ADMIN privilege(s) for this operation
553 STOP ALL SLAVES;
554 ERROR 42000: Access denied; you need (at least one of) the REPLICATION SLAVE ADMIN privilege(s) for this operation
555 connection slave;
556 START SLAVE 'slave2';
557 set default_master_connection = 'slave2';
558 include/wait_for_slave_to_start.inc
559 connection con1;
560 START ALL SLAVES;
561 ERROR 42000: Access denied; you need (at least one of) the REPLICATION SLAVE ADMIN privilege(s) for this operation
562 disconnect con1;
563 connection slave;
564 STOP SLAVE 'slave2';
565 set default_master_connection = 'slave2';
566 include/wait_for_slave_to_stop.inc
567 DROP USER 'unpriv'@'127.0.0.1';
568 SET SESSION sql_log_bin=1;
569 include/reset_master_slave.inc
570 disconnect slave;
571 connection master1;
572 include/reset_master_slave.inc
573 disconnect master1;
574 connection master2;
575 include/reset_master_slave.inc
576 disconnect master2;