I am having mysql 8.0 installation with replication between 2 servers in master-master configuration. While data is being replicated from server A to server B the replication is stalled from hours. Below is the snippet for show slave status \G on server B. I am not sure on what
waiting for handler commit means and whether its the cause of my Replication stalling
Master_SSL_Cipher: Master_SSL_Key: Seconds_Behind_Master: 49808 Last_IO_Errno: 0 Last_IO_Error: Last_SQL_Errno: 0 Last_SQL_Error:Replicate_Ignore_Server_Ids: Master_Server_Id: 1 Master_Info_File: mysql.slave_master_info SQL_Delay: 0 SQL_Remaining_Delay: NULL Slave_SQL_Running_State: waiting for handler commit Master_Retry_Count: 86400 Master_Bind: Last_IO_Error_Timestamp: Last_SQL_Error_Timestamp: Master_SSL_Crl:
After executing show processlist; i am getting a process that is waiting from a long time , having a wait time of 50071 and increasing
system user | | NULL | Query | 50071 | waiting for handler commit
What steps shall i take to bring my replication on track?