当前位置:   article > 正文

Error updating database. Cause:java.sql.SQLException: Lock wait timeout exceeded; try 清除数据库执行时间较长的任务_error updating database. cause: java.sql.sqlexcept

error updating database. cause: java.sql.sqlexception: lock wait timeout exc


SELECT * FROM information_schema.`PROCESSLIST` WHERE TIME > 1000 AND USER = 'dimsusr' ORDER BY TIME DESC;
  kill   id ;

Error updating database. Cause:java.sql.SQLException: Lock wait timeout exceeded; try restartingtransaction

select * from information_schema.innodb_trx
查看 trx_mysql_thread_id

show processlist
kill 100070;

引起的问题:并发下spring事务造成了死锁。

声明:本文内容由网友自发贡献,不代表【wpsshop博客】立场,版权归原作者所有,本站不承担相应法律责任。如您发现有侵权的内容,请联系我们。转载请注明出处:https://www.wpsshop.cn/w/不正经/article/detail/729242
推荐阅读
相关标签
  

闽ICP备14008679号