ERROR 1205 : Lock wait timeout exceeded; try restarting transaction
来源:互联网 发布:农村淘宝报名条件 编辑:程序博客网 时间:2024/06/05 06:34
今天在删除凭证的时候删除不了凭证,调试后发现是数据库的问题,在数据库中执行删除操作,提示如下:
解决方案:
1.查看先前库线程情况:show full processlist;
2.找到线程State为Waiting...的线程(被锁线程),kill掉出现问题的线程:kill 2711526
3.查看事务表:select * from information_schema.innodb_trx;
分析:
Mysql的 InnoDB存储引擎是支持事务的,事务开启后没有被主动Commit。导致该资源被长期占用,其他事务在抢占该资源时,因上一个事务的锁而导致抢占失败!因此出现 Lock wait timeout exceeded
查看使用的mySql的默认超时时间:
在my.ini文件中修改超时时间,自己根据需求进行修改即可:
阅读全文
0 0
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- MySql ERROR 1205:Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- MYSQL:Lock wait timeout exceeded; try restarting transaction ;ERROR 1205
- mysql Error 1205: Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
- LED驱动
- Hadoop入门之Join的两种实现Demo
- 单调栈与单调队列
- sql server技术知识
- linux下tomcat配置自定义jdk
- ERROR 1205 : Lock wait timeout exceeded; try restarting transaction
- strace 跟踪进程中的系统调用
- Spring boot入门五 spring mvc spring boot mybatis配置整合
- TCP和UDP的最完整的区别
- java.security.cert.CertificateException: No name matching https证书验证不通过
- 拨开字符编码的迷雾
- 树莓派 Raspberry Pi 更换国内源
- ARCore
- 获取当前手机单个app内存限制