解决“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;

 

posted on 2021-11-03 22:07  小破孩楼主  阅读(5003)  评论(0编辑  收藏  举报