1205, 'Lock wait timeout exceeded; try restarting transaction') 解决方法

mysql 运行出错提示:1205, 'Lock wait timeout exceeded; try restarting transaction')

登录navicat 运行查询SELECT * FROM information_schema.INNODB_TRX

try_mysql_thread_id显示:623423

则执行kill 623423来解决

posted @ 2022-02-02 15:41  myrj  阅读(151)  评论(0编辑  收藏  举报