lock wait timeout exceeded; try restarting transactio
服务重启时,mysql数据库报如下错误信息:
com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction
解决方法:
1.查找当前活跃事务
SELECT * from information_schema.INNODB_TRX
根据trx_started等判断事务是否异常锁定
2.杀死线程
Kill id(上面查询出来的trx_mysql_thread_id)