[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)
154
September 06, 2023 02:59AM
30
November 20, 2023 05:43AM
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.