解决数据库死锁现象
一、日志情况
日志情况如下:
信息: At least one JAR was scanned for TLDs yet contained no TLDs. Enable debug logging for this logger for a complete list of JARs that were scanned but no TLDs were found in them. Skipping unneeded JARs during scanning can improve startup time and JSP compilation time.
Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
INFO 19-8-27 下午9:54: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:54: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:54: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:54: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:54: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:55: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:55: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:55: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:55: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:55: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:55: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:56: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:56: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:56: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:56: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:56: liquibase: Waiting for changelog lock....
INFO 19-8-27 下午9:56: liquibase: Waiting for changelog lock....
二、解决办法
查找对应的数据库表
SHOW DATABASES
USE <数据库名称>
SELECT * FROM DATABASECHANGELOGLOCK;
查询结果如下:
+----+--------+---------------------+-----------------------------------+
| ID | LOCKED | LOCKGRANTED | LOCKEDBY |
+----+--------+---------------------+-----------------------------------+
| 1 | | 2019-08-27 16:07:24 | 192.168.176.128 (192.168.176.128) |
+----+--------+---------------------+-----------------------------------+
1 row in set (0.00 sec)
解锁
UPDATE DATABASECHANGELOGLOCK
SET locked=0, lockgranted=null, lockedby=null
WHERE id=1;