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

最新推荐文章于 2022-08-28 12:13:48 发布

weixin_30551947

最新推荐文章于 2022-08-28 12:13:48 发布

阅读量962

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/yangxiaochu/p/9269377.html

版权

本文描述了遇到MySQL复制过程中出现错误：Slave SQL thread retried transaction 10 time(s) in vain，建议增加slave_transaction_retries变量值以解决此问题，并提供了开始奴隶SQL线程的解决方案。

摘要由CSDN通过智能技术生成

今天遇到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 ret