[REPLICATION] : replica hangs on Applying batch of row changes (update)
HI,
My replica worker is waiting indefinitely on this message :
show processlist :
11 | system user | | TMP | Query | 4437 | Applying batch of row changes (update) | NULL
the performance_schema.replication_applier_status_by_worker table indicate the last transaction applied
show replica status :
| Replica_IO_State | Source_Host | Source_User | Source_Port | Connect_Retry | Source_Log_File | Read_Source_Log_Pos | Relay_Log_File | Relay_Log_Pos | Relay_Source_Log_File | Replica_IO_Running | Replica_SQL_Running | Replicate_Do_DB | Replicate_Ignore_DB | Replicate_Do_Table | Replicate_Ignore_Table | Replicate_Wild_Do_Table | Replicate_Wild_Ignore_Table | Last_Errno | Last_Error | Skip_Counter | Exec_Source_Log_Pos | Relay_Log_Space | Until_Condition | Until_Log_File | Until_Log_Pos | Source_SSL_Allowed | Source_SSL_CA_File | Source_SSL_CA_Path | Source_SSL_Cert | Source_SSL_Cipher | Source_SSL_Key | Seconds_Behind_Source | Source_SSL_Verify_Server_Cert | Last_IO_Errno | Last_IO_Error | Last_SQL_Errno | Last_SQL_Error | Replicate_Ignore_Server_Ids | Source_Server_Id | Source_UUID | Source_Info_File | SQL_Delay | SQL_Remaining_Delay | Replica_SQL_Running_State | Source_Retry_Count | Source_Bind | Last_IO_Error_Timestamp | Last_SQL_Error_Timestamp | Source_SSL_Crl | Source_SSL_Crlpath | Retrieved_Gtid_Set | Executed_Gtid_Set | Auto_Position | Replicate_Rewrite_DB | Channel_Name | Source_TLS_Version | Source_public_key_path | Get_Source_public_key | Network_Namespace |
+----------------------------------+-------------+------------------+------------
| Waiting for source to send event | ugdaspdt03 | replication_user | 3306 | 60 | mysql-bin.000005 | 15980987 | ugdaspdt04-relay-bin.000006 | 35688101 | mysql-bin.000001 | Yes | Yes | btspdrp2,btspdch2,btspdrf1,TMP | | | | | | 0 | | 0 | 35826685 | 4362053769 | None | | 0 | No | | | | | | 4801 | No | 0 | | 0 | | | 1 | 5696678d-b671-11ed-a9c1-00505697b35f | mysql.slave_master_info | 0 | NULL | Waiting for dependent transaction to commit | 86400 | | | | | | | 5696678d-b671-11ed-a9c1-00505697b35f:1-1226 | 0 |
I tried to modify my config and to run only one worker but it's the same.
Did you face this problem ?
Thanks
Subject
Views
Written By
Posted
[REPLICATION] : replica hangs on Applying batch of row changes (update)
950
September 06, 2023 02:59AM
448
November 20, 2023 05:43AM
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.