解决idea调试过程中liquibase –liquibase.lockservice: Waiting for changelog lock导致数据库死锁问题

 1.出现数据库死锁问题原因可能为idea运行时频繁，导致Jar包启动报错,工作流表部分日志表被锁，也可能上次未正常终止程序导致的异常

2023-03-20 14:43:06.599  INFO 21208 --- [main] liquibase.lockservice   : Waiting for changelog lock....
2023-03-20 14:43:16.878  INFO 21208 --- [main] liquibase.lockservice   : Waiting for changelog lock....
2023-03-20 14:43:27.225  INFO 21208 --- [main] liquibase.lockservice   : Waiting for changelog lock....
2023-03-20 14:43:37.628  INFO 21208 --- [main] liquibase.lockservice   : Waiting for changelog lock....
2023-03-20 14:43:48.026  INFO 21208 --- [main] liquibase.lockservice   : Waiting for changelog lock....
2023-03-20 14:43:58.592  INFO 21208 --- [main] liquibase.lockservice   : Waiting for changelog lock....
2023-03-20 14:44:09.105  INFO 21208 --- [main] liquibase.lockservice   : Waiting for changelog lock....

2.执行下面的第一条语句，查出的数据库中数据的locked的值是1，说明database被锁了，然后在执行第二条修改语句，进行修改

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

3.如果提示找不到表或试图不存在

解决办法（所有以DATABASECHANGELOGLOCK结尾的表都检查一遍，并修改locked字段的值为0即可）如图所示：