I have a master-slave setup, which was running fine with out any issues. 3 days back i have loaded close to 1 TB data in Master DB, since then Slave is having issues and i can see the errors like in slave logs. table1_trn is the biggest table and it took close to 8 hrs to load it in Master DB
22019-03-04T18:00:32.463342Z 2 [Warning] Slave SQL for channel ‘’: Could not execute Write_rows event on table myschmea.table1_trn; Lock wait timeout exceeded; try restarting transaction, Error_code: 1205; handler error HA_ERR_LOCK_WAIT_TIMEOUT; the event’s master log mysql-bin.005104, end_log_pos 60822466, Error_code: 1205
mysql> show slave status \G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Last_Error: Slave SQL thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable.
Last_SQL_Error: Slave SQL thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable.
Last_SQL_Error_Timestamp: 190304 13:09:37