start replica encounter Slave_SQL_Running NO with MY-013117 (null)
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)
Subject
Views
Written By
Posted
start replica encounter Slave_SQL_Running NO with MY-013117 (null)
971
May 23, 2023 01:58AM
Sorry, you can't reply to this topic. It has been closed.
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.