MySQL Bugs: #111074: start replica encounter Slave_SQL

Bug #111074	start replica encounter Slave_SQL_Running NO with MY-013117 (null)
Submitted:	18 May 2023 12:15	Modified:	22 May 2023 14:07
Reporter:	William Wong	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Replication	Severity:	S2 (Serious)
Version:	8.0.33	OS:	Red Hat (redhat 8.7)
Assigned to:	MySQL Verification Team	CPU Architecture:	x86
Tags:	MY-013117

Description:
we are upgrading DB from 5.7.39 to 8.0.33
OS is migrated from redhat 7 to redhat 8 as well

2 of them are replication pair. That means instance 1 (mnotintt1) replica data to instance 2 (mnotintt2). And instance 2 (mnotintt2) replica data to instance 1 (mnotintt1). 

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

uploaded my.cnf and DB log for reference
- my.cnf.mnotintt1
- my.cnf.mnotintt2
- mysqld.err.mnotintt1
- mysqld.err.mnotintt2

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

How to repeat:
this problem happens in one group of DB since upgrade today in one group of DB

But we cannot provide a test case
we upgraded 2 groups of such DB from 5.7.39 to 8.0.33. one group is OK. And the other group (above case) encountered SQL thread error

node 1 my.cnf

Attachment: my.cnf.mnotintt1 (application/octet-stream, text), 4.00 KiB.

node 2 my.cnf

Attachment: my.cnf.mnotintt2 (application/octet-stream, text), 4.92 KiB.

node 1 DB log

Attachment: mysqld.err.mnotintt1 (application/octet-stream, text), 12.24 KiB.

node 2 DB log

Attachment: mysqld.err.mnotintt2 (application/octet-stream, text), 12.32 KiB.

below is the result of slow replica status

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)

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.