1205 Lock wait timeout exceed

当出现错误提示"Lock wait timeout exceeded"时，意味着某个查询语句被锁住了，并且等待超时了。为了解决这个问题，有几个可能的解决方案。首先，可以尝试重新启动事务来释放锁定。另外，可以使用show full processlist命令查看当前的进程列表，以获得更多的信息。另外一个解决方案是使用innodb_lock_waits表来获取有关锁等待的详细信息，可以使用命令information_schema.innodb_lock_waits来查询该表。通过这些方法，您可以更好地了解锁定等待的原因，并采取适当的措施解决此问题。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* [mysql出现SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded； try restarting ...](https://blog.csdn.net/qq_15957557/article/details/121469452)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
- *2* *3* [mysql 报错 Lock wait timeout exceeded； try restarting transaction 解决方法](https://blog.csdn.net/whatday/article/details/125109700)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]