MySql事务- Lock wait timeout exceeded; try restarting transaction问题解决 1.查看数据库当前的进程 show processlist; 2.查看当前的事务 #当前运行的所有事务 SELECT * FROM information_schema.INNODB_TRX; #当前出现的锁 SELECT * FROM information_schema.INNODB_LOCKs; #锁等待的对应关系 SELECT * FROM information_schema.INNODB_LOCK_waits; 3.删除进程 kill 进程id Previous MySQL问题 Next MySQL问题 CATALOG MySql事务- Lock wait timeout exceeded; try restarting transaction问题解决1.查看数据库当前的进程2.查看当前的事务3.删除进程 FEATURED TAGS MySQL JAVA git Jenkins Docker Elasticsearch SpringData Nexus Linux VMware FRIENDS 简书·BY CSDN Apple Apple Developer
