mysql 1205 - Lock wait timeout exceeded; try restarting transaction
程序员文章站
2022-06-02 08:14:47
...
这个错误是因为有事务没处理完,执行下面的语句查找未完成的事务
select * from information_schema.innodb_trx;
kill + trx_mysql_thread_id 结束事务,问题解决
推荐阅读
-
mysql报错:Deadlock found when trying to get lock; try restarting transaction的解决方法
-
Lock wait timeout exceeded; try restarting transaction
-
Mysql出现“ Lock wait timeout exceeded; try restarting trans
-
mysql提示 Lock wait timeout exceeded解决办法
-
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction
-
[Err] 1205 - Lock wait timeout exceeded; try restarting transaction
-
mysql 1205 - Lock wait timeout exceeded; try restarting transaction
-
MySQL 1205-Lock wait timeout exceeded; try restarting transaction
-
1205 - Lock wait timeout exceeded; try restarting transaction(解决备忘)
-
Lock wait timeout exceeded try restarting transaction