Lock wait timeout exceeded; try restarting transaction 原创

### SQL: delete from lx_role_menu WHERE ( role_id = ? )
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction

已超过锁定等待超时；请尝试重新启动事务。

查询是否存在被锁事务数据

SELECT * FROM INFORMATION_SCHEMA.INNODB_TRX;

解除事务锁

-- trx_mysql_thread_id  线程ID

SELECT t.trx_mysql_thread_id FROM INFORMATION_SCHEMA.INNODB_TRX t;

杀死进程id

kill 线程ID;