| 1 |
include/master-slave.inc |
| 2 |
[connection master] |
| 3 |
connection slave; |
| 4 |
SET DEBUG_SYNC= 'RESET'; |
| 5 |
include/stop_slave.inc |
| 6 |
SET @saved_dbug = @@GLOBAL.debug_dbug; |
| 7 |
set global debug_dbug= 'd,dbug.before_get_running_status_yes'; |
| 8 |
Slave_running, Slave_IO_Running, Slave_SQL_Running, must be OFF, NO, NO in three following queries |
| 9 |
SHOW STATUS LIKE 'Slave_running'; |
| 10 |
Variable_name Value |
| 11 |
Slave_running OFF |
| 12 |
Slave_IO_Running= No |
| 13 |
Slave_SQL_Running= No |
| 14 |
start slave io_thread; |
| 15 |
Slave_running, Slave_IO_Running, Slave_SQL_Running must be OFF Connecting NO in three following queries |
| 16 |
SHOW STATUS LIKE 'Slave_running'; |
| 17 |
Variable_name Value |
| 18 |
Slave_running OFF |
| 19 |
Slave_IO_Running= Connecting |
| 20 |
Slave_SQL_Running= No |
| 21 |
SET DEBUG_SYNC='now SIGNAL signal.io_thread_let_running'; |
| 22 |
include/wait_for_slave_param.inc [Slave_IO_Running] |
| 23 |
Slave_running, Slave_IO_Running, Slave_SQL_Running must be OFF YES NO in three following queries |
| 24 |
SHOW STATUS LIKE 'Slave_running'; |
| 25 |
Variable_name Value |
| 26 |
Slave_running OFF |
| 27 |
Slave_IO_Running= Yes |
| 28 |
Slave_SQL_Running= No |
| 29 |
start slave sql_thread; |
| 30 |
include/wait_for_slave_sql_to_start.inc |
| 31 |
Slave_running, Slave_IO_Running, Slave_SQL_Running must be ON, YES, YES in three following queries |
| 32 |
SHOW STATUS LIKE 'Slave_running'; |
| 33 |
Variable_name Value |
| 34 |
Slave_running ON |
| 35 |
Slave_IO_Running= Yes |
| 36 |
Slave_SQL_Running= Yes |
| 37 |
connection slave; |
| 38 |
SET @@GLOBAL.debug_dbug = @saved_dbug; |
| 39 |
SET DEBUG_SYNC= 'RESET'; |
| 40 |
End of tests |
| 41 |
include/rpl_end.inc |