数据库重构工具 LiquiBase(5 Liquibase被锁)

经常运行过程中出现

Liquibase - Waiting for changelog lockWaiting for changelog lock....Running the migration script for a database may produce this:...INFO … Liquibase: Waiting for changelog lock....INFO … Liquibase: Waiting for changelog lock....INFO … Liquibase: Waiting for changelog lock.......

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9

解决方法： 看下那个机器锁住了database，执行下面语句；

USE [Database Name]SELECT * FROM DATABASECHANGELOGLOCK;

• 1
• 2

一般情况下是本机锁住的；则通过下面sql解锁

UPDATE DATABASECHANGELOGLOCKSET locked=0, lockgranted=null, lockedby=nullWHERE id=1

• 1
• 2
• 3