MySQL Forums
Forum List  »  Replication

[REPLICATION] : replica hangs on Applying batch of row changes (update)
Posted by: christophe offroy
Date: September 06, 2023 02:59AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
[REPLICATION] : replica hangs on Applying batch of row changes (update)
397
September 06, 2023 02:59AM


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.