title: mysql Replication stalled
body: <p>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 <code>show slave status \G</code> on server B.</p>
  
  <pre><code>            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:
  </code></pre>
  
  <p>After executing <code>show processlist;</code> i am getting a process that is waiting from a long time , having a wait time of 50071 and increasing</p>
  
  <pre><code> system user     |                               | NULL | Query       | 50071 | waiting for handler commit
  </code></pre>
  
  <p>What steps shall i take to bring my replication on track?</p>