MySQL Forums
Forum List  »  Replication

start replica encounter Slave_SQL_Running NO with MY-013117 (null)
Posted by: William Wong
Date: May 23, 2023 01:58AM

we are upgrading a pair of multi-Master replication of MySQL instances from 5.7.39 to 8.0.33
OS is migrated from redhat 7 to redhat 8 as well


After upgrade, insert update delete are OK

But when we start replica, encounter below error. Same error when start replica in another DB instance

2023-05-18T18:51:55.775430+08:00 6 [ERROR] [MY-013117] [Repl] Replica SQL for channel '': (null), Error_code: MY-013117

Since the error message is (null) we do not know what is the exact issue. Kindly suggest the next step to troubleshoot this problem.




mysql> show slave status \G
*************************** 1. row ***************************
Slave_IO_State: Waiting for source to send event
Master_Host: 10.123.119.152
Master_User: replicate
Master_Port: 19001
Connect_Retry: 60
Master_Log_File: mysql-bin.010501
Read_Master_Log_Pos: 177721
Relay_Log_File: mysqld-relay-bin.000001
Relay_Log_Pos: 4
Relay_Master_Log_File: mysql-bin.010496
Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table: healthcheckdb.write_test
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table: mysql.%,information_schema.%,performance_schema.%
Last_Errno: 13117
Last_Error: (null)
Skip_Counter: 0
Exec_Master_Log_Pos: 4
Relay_Log_Space: 409019
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: 13117
Last_SQL_Error: (null)
Replicate_Ignore_Server_Ids:
Master_Server_Id: 2
Master_UUID: ff7b13c8-f569-11ed-90bc-005056b3813c
Master_Info_File: /u01/mydata/mnotintt1/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: 230518 18:53:02
Master_SSL_Crl:
Master_SSL_Crlpath:
Retrieved_Gtid_Set:
Executed_Gtid_Set:
Auto_Position: 0
Replicate_Rewrite_DB:
Channel_Name:
Master_TLS_Version:
Master_public_key_path:
Get_master_public_key: 0
Network_Namespace:
1 row in set, 1 warning (0.00 sec)

Options: ReplyQuote


Subject
Views
Written By
Posted
start replica encounter Slave_SQL_Running NO with MY-013117 (null)
239
May 23, 2023 01:58AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.