解决数据库死锁现象

解决数据库死锁现象

一、日志情况

日志情况如下：

信息: 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;