Debian Codegraph @

mysql-test/suite/rpl/r/rpl_show_slave_running.result

raw
1 include/master-slave.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection master]
6 SET DEBUG_SYNC= 'RESET';
7 include/stop_slave.inc
8 # Adding debug point 'dbug.before_get_running_status_yes' to @@GLOBAL.debug
9 Slave_running, Slave_IO_Running, Slave_SQL_Running, must be OFF, NO, NO in three following queries
10 select rcs.SERVICE_STATE as Slave_IO_Running, ras.SERVICE_STATE as Slave_SQL_Running from performance_schema.replication_applier_status ras, performance_schema.replication_connection_status rcs;
11 Slave_IO_Running Slave_SQL_Running
12 OFF OFF
13 start slave io_thread;
14 Warnings:
15 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
16 Slave_running, Slave_IO_Running, Slave_SQL_Running must be OFF Connecting NO in three following queries
17 select rcs.SERVICE_STATE as Slave_IO_Running, ras.SERVICE_STATE as Slave_SQL_Running from performance_schema.replication_applier_status ras, performance_schema.replication_connection_status rcs;
18 Slave_IO_Running Slave_SQL_Running
19 CONNECTING OFF
20 SET DEBUG_SYNC='now SIGNAL signal.io_thread_let_running';
21 include/wait_for_slave_param.inc [Slave_IO_Running]
22 Slave_running, Slave_IO_Running, Slave_SQL_Running must be OFF YES NO in three following queries
23 select rcs.SERVICE_STATE as Slave_IO_Running, ras.SERVICE_STATE as Slave_SQL_Running from performance_schema.replication_applier_status ras, performance_schema.replication_connection_status rcs;
24 Slave_IO_Running Slave_SQL_Running
25 ON OFF
26 start slave sql_thread;
27 Warnings:
28 Warning 1287 'START SLAVE' is deprecated and will be removed in a future release. Please use START REPLICA instead
29 include/wait_for_slave_sql_to_start.inc
30 Slave_running, Slave_IO_Running, Slave_SQL_Running must be ON, YES, YES in three following queries
31 select rcs.SERVICE_STATE as Slave_IO_Running, ras.SERVICE_STATE as Slave_SQL_Running from performance_schema.replication_applier_status ras, performance_schema.replication_connection_status rcs;
32 Slave_IO_Running Slave_SQL_Running
33 ON ON
34 include/sync_slave_sql_with_master.inc
35 # Removing debug point 'dbug.before_get_running_status_yes' from @@GLOBAL.debug
36 SET DEBUG_SYNC= 'RESET';
37 End of tests
38 include/rpl_end.inc