解决“Liquibase: Waiting for changelog lock”数据库死锁问题
现象:
启动程序时报错"Liquibase: Waiting for changelog lock..."
解决:
SELECT * FROM DATABASECHANGELOGLOCK;
+----+--------+---------------------+-----------------------------------+
| ID | LOCKED | LOCKGRANTED | LOCKEDBY |
+----+--------+---------------------+-----------------------------------+
| 1 | | 2020-09-08 16:00:21 | 192.168.16.18 (192.168.16.18) |
+----+--------+---------------------+-----------------------------------+
1 row in set (0.00 sec)
# 更新状态
UPDATE DATABASECHANGELOGLOCK SET locked=0, lockgranted=null, lockedby=null WHERE id=1;