mysql : Lock wait timeout exceeded; try restarting transaction
来源:互联网 发布:mac怎么解压zip 编辑:程序博客网 时间:2024/04/27 21:52
mysql : Lock wait timeout exceeded; try restarting transaction
原因是你使用的InnoDB 表类型的时候,
默认参数:innodb_lock_wait_timeout设置锁等待的时间是50s,
因为有的锁等待超过了这个时间,所以抱错.
你可以把这个时间加长,或者优化存储过程,事务避免过长时间的等待.
my.ini文件:
innodb_lock_wait_timeout = 50
-》
innodb_lock_wait_timeout = 500
重启mysql服务。
0 0
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- mysql错误:Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- mysql : Lock wait timeout exceeded; try restarting transaction
- lock wait timeout exceeded try restarting transaction mysql
- Mysql出现“ Lock wait timeout exceeded; try restarting transaction”错误
- mysql错误: Lock wait timeout exceeded; try restarting transaction
- Android开发--玩转WebView
- 计算机网络复习——以太网
- Android之Widget
- 商业新闻稿的写作和发布
- prim算法
- mysql : Lock wait timeout exceeded; try restarting transaction
- hdu 2069 Coin Change 背包。本来打算用母函数再写一遍的,发现代码极其相似,就没写
- 就业报到证的常见问题解答汇总
- iOS 开发实用工具
- 欢迎使用CSDN-markdown编辑器
- std::string 是否包含字串
- Oracle trunc()函数的用法
- The transaction log for database 'xx' is full,Error: 9002, Severity: 17, State: 2
- 点击Edittext之外的地方关闭Edittext