解决“Liquibase: Waiting for changelog lock”数据库死锁问题

最新推荐文章于 2025-02-28 16:51:21 发布

bboyHan

最新推荐文章于 2025-02-28 16:51:21 发布

阅读量9k

点赞数 2

分类专栏： Java MySQL

本文链接：https://blog.csdn.net/han0373/article/details/108471481

版权

Java 同时被 2 个专栏收录

26 篇文章

订阅专栏

MySQL

9 篇文章

订阅专栏

现象：

启动程序时报错"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;