工作流模块Jar包启动报错：liquibase – Waiting for changelog lock….

原文地址：https://cloud.tencent.com/developer/article/1833728

1.异常

工作流模块Jar包启动报错：

2021-02-14 13:45:13.735 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:45:23.739 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:45:33.744 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:45:43.750 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:45:53.755 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:46:03.762 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:46:13.767 [main] INFO  liquibase - Waiting for changelog lock....
2021-02-14 13:46:23.773 [main] INFO  liquibase - Waiting for changelog lock....

2.原因

工作流表部分日志表被锁，可能上次未正常终止程序导致的异常。

3.借鉴网上说是表被锁，解除锁定就行，可执行下面的语句，但是提示找不到表或试图不存在

#查询被锁的表
SELECT * FROM DATABASECHANGELOGLOCK;
#解除锁定
UPDATE DATABASECHANGELOGLOCK SET locked=0, lockgranted=null, lockedby=null WHERE id=1

4.解决办法（所有以DATABASECHANGELOGLOCK结尾的表都检查一遍，修改如：图2）

图1

图2