Could not synchronize database state with session Lock wait timeout exceeded; try restarting transa
来源:互联网 发布:淘宝野模 编辑:程序博客网 时间:2024/05/18 11:27
控制台报错
SQLState: 41000,
Lock wait timeout exceeded; try restarting transaction
Could not synchronize database state with session
SQL Error: 1205, SQLState: 41000,
我是这样解决的:执行 select * from information_schema.innodb_trx 语句,在数据库查出是哪个trx_mysql_thread_id 下面 的id ,
然后执行 kill id 然后就行了。
0 0
- Could not synchronize database state with session Lock wait timeout exceeded; try restarting transa
- 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
- Could not synchronize database state with session
- Could not synchronize database state with session
- Could not synchronize database state with session
- Could not synchronize database state with session
- Could not synchronize database state with session
- Could not synchronize database state with session
- mysql : Lock wait timeout exceeded; try restarting transaction
- 宽字符与多字节字符
- 观念真的很重要
- struts2拦截器简介
- OBE教程之oracle使用正则表达式
- (展讯 /RK3066)Android:ADB详解 (2013-01-05 13:36:15)
- Could not synchronize database state with session Lock wait timeout exceeded; try restarting transa
- mysql输入中文乱码怎么办,字符集。
- AFNetwork 作用和用法详解
- CheckBox和控件Foreach循环
- easyUi 取的时间控件
- 线性表的链式存储
- 数据类型
- poj 1112 Team Them Up! 二分图染色+dp
- 解决MySql 报错:ERROR 1366 (HY000): Incorrect string value....