2017-02-11T22:51:14.073570Z 229 [Note] 'CHANGE MASTER TO FOR CHANNEL 'ne1-002' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='dbatestdb-002.mysql.corp.ne1.yahoo.com', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2017-02-11T22:51:14.079906Z 229 [Note] 'CHANGE MASTER TO FOR CHANNEL 'ne1-003' executed'. Previous state master_host='', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. New state master_host='dbatestdb-003.mysql.corp.ne1.yahoo.com', master_port= 3306, master_log_file='', master_log_pos= 4, master_bind=''. 2017-02-11T22:51:20.485624Z 239 [Note] Slave I/O thread: Start semi-sync replication to master 'replication@dbatestdb-002.mysql.corp.ne1.yahoo.com:3306' in log 'FIRST' at position 4 2017-02-11T22:51:20.485704Z 239 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2017-02-11T22:51:20.487184Z 240 [Note] Slave SQL thread for channel 'ne1-002' initialized, starting replication in log 'FIRST' at position 0, relay log '/home/y/var/mysql/data/mysqld-relay-bin-ne1@00 2d002.000001' position: 4 2017-02-11T22:51:20.487986Z 241 [Note] Slave I/O thread: Start semi-sync replication to master 'replication@dbatestdb-003.mysql.corp.ne1.yahoo.com:3306' in log 'FIRST' at position 4 2017-02-11T22:51:20.488017Z 241 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2017-02-11T22:51:20.488245Z 239 [Note] Slave I/O thread for channel 'ne1-002': connected to master 'replication@dbatestdb-002.mysql.corp.ne1.yahoo.com:3306',replication started in log 'FIRST' at posi tion 4 2017-02-11T22:51:20.489243Z 242 [Note] Slave SQL thread for channel 'ne1-003' initialized, starting replication in log 'FIRST' at position 0, relay log '/home/y/var/mysql/data/mysqld-relay-bin-ne1@00 2d003.000001' position: 4 2017-02-11T22:51:20.489414Z 241 [Note] Slave I/O thread for channel 'ne1-003': connected to master 'replication@dbatestdb-003.mysql.corp.ne1.yahoo.com:3306',replication started in log 'FIRST' at posi tion 4 2017-02-11T22:51:20.491731Z 241 [Warning] Master server does not support semi-sync, fallback to asynchronous replication 2017-02-11T22:51:20.492186Z 239 [ERROR] Slave I/O for channel 'ne1-002': Replication event checksum verification failed while reading from network. Error_code: 1743 2017-02-11T22:51:20.492216Z 239 [ERROR] Slave I/O for channel 'ne1-002': Relay log write failure: could not queue event from master, Error_code: 1595 2017-02-11T22:51:20.492223Z 239 [Note] Slave I/O thread exiting for channel 'ne1-002', read up to log 'FIRST', position 4 2017-02-11T22:57:14.572214Z 240 [Note] Error reading relay log event for channel 'ne1-002': slave SQL thread was killed 2017-02-11T22:57:14.572803Z 242 [Note] Error reading relay log event for channel 'ne1-003': slave SQL thread was killed 2017-02-11T22:57:14.573303Z 241 [Note] Slave I/O thread killed while reading event for channel 'ne1-003' 2017-02-11T22:57:14.573331Z 241 [Note] Slave I/O thread exiting for channel 'ne1-003', read up to log 'mysqld-bin.000003', position 1062 2017-02-11T22:57:19.756681Z 297 [Note] Slave I/O thread: Start semi-sync replication to master 'replication@dbatestdb-002.mysql.corp.ne1.yahoo.com:3306' in log 'FIRST' at position 4 2017-02-11T22:57:19.756727Z 297 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2017-02-11T22:57:19.757556Z 298 [Note] Slave SQL thread for channel 'ne1-002' initialized, starting replication in log 'FIRST' at position 0, relay log '/home/y/var/mysql/data/mysqld-relay-bin-ne1@00 2d002.000001' position: 4 2017-02-11T22:57:19.758320Z 297 [Note] Slave I/O thread for channel 'ne1-002': connected to master 'replication@dbatestdb-002.mysql.corp.ne1.yahoo.com:3306',replication started in log 'FIRST' at posi tion 4 2017-02-11T23:01:59.096675Z 336 [Note] Slave I/O thread: Start semi-sync replication to master 'replication@dbatestdb-003.mysql.corp.ne1.yahoo.com:3306' in log 'mysqld-bin.000003' at position 1062 2017-02-11T23:01:59.096720Z 336 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2017-02-11T23:01:59.097594Z 337 [Note] Slave SQL thread for channel 'ne1-003' initialized, starting replication in log 'mysqld-bin.000003' at position 1062, relay log '/home/y/var/mysql/data/mysqld-relay-bin-ne1@002d003.000002' position: 1277 2017-02-11T23:01:59.098312Z 336 [Note] Slave I/O thread for channel 'ne1-003': connected to master 'replication@dbatestdb-003.mysql.corp.ne1.yahoo.com:3306',replication started in log 'mysqld-bin.000003' at position 1062 2017-02-11T23:01:59.101639Z 336 [Warning] Master server does not support semi-sync, fallback to asynchronous replication 2017-02-11T23:02:19.763953Z 297 [ERROR] Slave I/O for channel 'ne1-002': Replication event checksum verification failed while reading from network. Error_code: 1743 2017-02-11T23:02:19.763991Z 297 [ERROR] Slave I/O for channel 'ne1-002': Relay log write failure: could not queue event from master, Error_code: 1595 2017-02-11T23:02:19.763999Z 297 [Note] Slave I/O thread exiting for channel 'ne1-002', read up to log 'mysqld-bin.000003', position 1062 2017-02-11T23:02:25.161251Z 298 [Note] Error reading relay log event for channel 'ne1-002': slave SQL thread was killed 2017-02-11T23:02:43.531679Z 347 [Note] Slave I/O thread: Start semi-sync replication to master 'replication@dbatestdb-002.mysql.corp.ne1.yahoo.com:3306' in log 'mysqld-bin.000003' at position 1062 2017-02-11T23:02:43.531727Z 347 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2017-02-11T23:02:43.532605Z 348 [Note] Slave SQL thread for channel 'ne1-002' initialized, starting replication in log 'mysqld-bin.000003' at position 1062, relay log '/home/y/var/mysql/data/mysqld-relay-bin-ne1@002d002.000002' position: 1277 2017-02-11T23:02:43.533353Z 347 [Note] Slave I/O thread for channel 'ne1-002': connected to master 'replication@dbatestdb-002.mysql.corp.ne1.yahoo.com:3306',replication started in log 'mysqld-bin.000003' at position 1062 2017-02-11T23:02:59.019263Z 348 [Note] Error reading relay log event for channel 'ne1-002': slave SQL thread was killed 2017-02-11T23:02:59.019904Z 347 [Note] Slave I/O thread killed while reading event for channel 'ne1-002' 2017-02-11T23:02:59.019931Z 347 [Note] Slave I/O thread exiting for channel 'ne1-002', read up to log 'mysqld-bin.000003', position 1062 2017-02-11T23:02:59.020665Z 337 [Note] Error reading relay log event for channel 'ne1-003': slave SQL thread was killed 2017-02-11T23:02:59.021050Z 336 [Note] Slave I/O thread killed while reading event for channel 'ne1-003' 2017-02-11T23:02:59.021074Z 336 [Note] Slave I/O thread exiting for channel 'ne1-003', read up to log 'mysqld-bin.000003', position 1062 2017-02-11T23:03:05.623622Z 352 [Note] Slave I/O thread: Start semi-sync replication to master 'replication@dbatestdb-002.mysql.corp.ne1.yahoo.com:3306' in log 'mysqld-bin.000003' at position 1062 2017-02-11T23:03:05.623665Z 352 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2017-02-11T23:03:05.624624Z 353 [Note] Slave SQL thread for channel 'ne1-002' initialized, starting replication in log 'mysqld-bin.000003' at position 1062, relay log '/home/y/var/mysql/data/mysqld-relay-bin-ne1@002d002.000003' position: 457 2017-02-11T23:03:05.624861Z 354 [Note] Slave I/O thread: Start semi-sync replication to master 'replication@dbatestdb-003.mysql.corp.ne1.yahoo.com:3306' in log 'mysqld-bin.000003' at position 1062 2017-02-11T23:03:05.624887Z 354 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. 2017-02-11T23:03:05.625324Z 352 [Note] Slave I/O thread for channel 'ne1-002': connected to master 'replication@dbatestdb-002.mysql.corp.ne1.yahoo.com:3306',replication started in log 'mysqld-bin.000003' at position 1062 2017-02-11T23:03:05.625593Z 355 [Note] Slave SQL thread for channel 'ne1-003' initialized, starting replication in log 'mysqld-bin.000003' at position 1062, relay log '/home/y/var/mysql/data/mysqld-relay-bin-ne1@002d003.000003' position: 457 2017-02-11T23:03:05.626435Z 354 [Note] Slave I/O thread for channel 'ne1-003': connected to master 'replication@dbatestdb-003.mysql.corp.ne1.yahoo.com:3306',replication started in log 'mysqld-bin.000003' at position 1062 2017-02-11T23:03:05.629845Z 354 [Warning] Master server does not support semi-sync, fallback to asynchronous replication 2017-02-11T23:03:06.028421Z 352 [ERROR] Slave I/O for channel 'ne1-002': Replication event checksum verification failed while reading from network. Error_code: 1743 2017-02-11T23:03:06.028447Z 352 [ERROR] Slave I/O for channel 'ne1-002': Relay log write failure: could not queue event from master, Error_code: 1595 2017-02-11T23:03:06.028463Z 352 [Note] Slave I/O thread exiting for channel 'ne1-002', read up to log 'mysqld-bin.000003', position 1062 mysql> start slave; Query OK, 0 rows affected (0.01 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: dbatestdb-002.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: Read_Master_Log_Pos: 4 Relay_Log_File: mysqld-relay-bin-ne1@002d002.000001 Relay_Log_Pos: 4 Relay_Master_Log_File: Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 0 Relay_Log_Space: 154 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 1595 Last_IO_Error: Relay log write failure: could not queue event from master Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271617 Master_UUID: 584d6412-efbd-11e6-88f7-782bcb1804bf Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: 170211 22:51:20 Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: Executed_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-002 Master_TLS_Version: *************************** 2. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: dbatestdb-003.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d003.000002 Relay_Log_Pos: 1277 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1497 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271619 Master_UUID: 5d10e410-efbd-11e6-94bd-782bcb180148 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3 Executed_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-003 Master_TLS_Version: 2 rows in set (0.00 sec) mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> start slave for channel 'ne1-002'; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: dbatestdb-002.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d002.000002 Relay_Log_Pos: 1277 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1497 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271617 Master_UUID: 584d6412-efbd-11e6-88f7-782bcb1804bf Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-002 Master_TLS_Version: *************************** 2. row *************************** Slave_IO_State: Master_Host: dbatestdb-003.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d003.000002 Relay_Log_Pos: 1277 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1497 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271619 Master_UUID: 5d10e410-efbd-11e6-94bd-782bcb180148 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-003 Master_TLS_Version: 2 rows in set (0.00 sec) mysql> start slave for channel 'ne1-003'; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: dbatestdb-002.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d002.000002 Relay_Log_Pos: 1277 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1497 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271617 Master_UUID: 584d6412-efbd-11e6-88f7-782bcb1804bf Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-002 Master_TLS_Version: *************************** 2. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: dbatestdb-003.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d003.000003 Relay_Log_Pos: 457 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1800 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271619 Master_UUID: 5d10e410-efbd-11e6-94bd-782bcb180148 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-003 Master_TLS_Version: 2 rows in set (0.00 sec) mysql> stop slave for channel 'ne1-002'; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: dbatestdb-002.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d002.000002 Relay_Log_Pos: 1277 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1497 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 1595 Last_IO_Error: Relay log write failure: could not queue event from master Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271617 Master_UUID: 584d6412-efbd-11e6-88f7-782bcb1804bf Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: 170211 23:02:19 Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-002 Master_TLS_Version: *************************** 2. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: dbatestdb-003.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d003.000003 Relay_Log_Pos: 457 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1800 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271619 Master_UUID: 5d10e410-efbd-11e6-94bd-782bcb180148 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-003 Master_TLS_Version: 2 rows in set (0.00 sec) mysql> start slave for channel 'ne1-002'; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: dbatestdb-002.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d002.000003 Relay_Log_Pos: 457 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1800 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271617 Master_UUID: 584d6412-efbd-11e6-88f7-782bcb1804bf Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-002 Master_TLS_Version: *************************** 2. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: dbatestdb-003.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d003.000003 Relay_Log_Pos: 457 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1800 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271619 Master_UUID: 5d10e410-efbd-11e6-94bd-782bcb180148 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-003 Master_TLS_Version: 2 rows in set (0.00 sec) mysql> stop slave; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: dbatestdb-002.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d002.000003 Relay_Log_Pos: 457 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1800 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271617 Master_UUID: 584d6412-efbd-11e6-88f7-782bcb1804bf Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-002 Master_TLS_Version: *************************** 2. row *************************** Slave_IO_State: Master_Host: dbatestdb-003.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d003.000003 Relay_Log_Pos: 457 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: No Slave_SQL_Running: No Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1800 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271619 Master_UUID: 5d10e410-efbd-11e6-94bd-782bcb180148 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-003 Master_TLS_Version: 2 rows in set (0.00 sec) mysql> start slave; Query OK, 0 rows affected (0.00 sec) mysql> show slave status\G *************************** 1. row *************************** Slave_IO_State: Master_Host: dbatestdb-002.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d002.000003 Relay_Log_Pos: 457 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: No Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 1800 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: NULL Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 1595 Last_IO_Error: Relay log write failure: could not queue event from master Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271617 Master_UUID: 584d6412-efbd-11e6-88f7-782bcb1804bf Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: 170211 23:03:06 Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-002 Master_TLS_Version: *************************** 2. row *************************** Slave_IO_State: Waiting for master to send event Master_Host: dbatestdb-003.mysql.corp.ne1.yahoo.com Master_User: replication Master_Port: 3306 Connect_Retry: 60 Master_Log_File: mysqld-bin.000003 Read_Master_Log_Pos: 1062 Relay_Log_File: mysqld-relay-bin-ne1@002d003.000004 Relay_Log_Pos: 457 Relay_Master_Log_File: mysqld-bin.000003 Slave_IO_Running: Yes Slave_SQL_Running: Yes Replicate_Do_DB: Replicate_Ignore_DB: ops,ops Replicate_Do_Table: Replicate_Ignore_Table: Replicate_Wild_Do_Table: Replicate_Wild_Ignore_Table: Last_Errno: 0 Last_Error: Skip_Counter: 0 Exec_Master_Log_Pos: 1062 Relay_Log_Space: 980 Until_Condition: None Until_Log_File: Until_Log_Pos: 0 Master_SSL_Allowed: No Master_SSL_CA_File: Master_SSL_CA_Path: Master_SSL_Cert: Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 0 Master_SSL_Verify_Server_Cert: No Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error: Replicate_Ignore_Server_Ids: Master_Server_Id: 1653271619 Master_UUID: 5d10e410-efbd-11e6-94bd-782bcb180148 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: Slave has read all relay log; waiting for more updates Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl: Master_SSL_Crlpath: Retrieved_Gtid_Set: 5d10e410-efbd-11e6-94bd-782bcb180148:1-3 Executed_Gtid_Set: 584d6412-efbd-11e6-88f7-782bcb1804bf:1-3, 5d10e410-efbd-11e6-94bd-782bcb180148:1-3, e65451a8-efbc-11e6-aac9-782bcb1808c5:1-15 Auto_Position: 1 Replicate_Rewrite_DB: Channel_Name: ne1-003 Master_TLS_Version: 2 rows in set (0.00 sec)