Slave SQL thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of t

今天遇到mysql报错：

Slave_IO_Running: Yes
Slave_SQL_Running: No
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 1205
Last_Error: Slave SQL thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction_retries variable.
Skip_Counter: 0
Exec_Master_Log_Pos: 204441882
Relay_Log_Space: 162909204
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: NULL
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 1205
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.
Replicate_Ignore_Server_Ids:
Master_Server_Id: 2

 

 

error.log

2018-07-05T02:18:00.648716Z 1752962 [ERROR] Slave SQL for channel '': Slave SQL thread retried transaction 10 time(s) in vain, giving up. Consider raising the value of the slave_transaction
_retries variable. Error_code: 12052018-07-05T02:18:00.648741Z 1752962 [Warning] Slave: Lock wait timeout exceeded; try restarting transaction Error_code: 1205
2018-07-05T02:18:00.648746Z 1752962 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql2-bi
n.000242' position 204441882

 

解决办法：

start slave;