Liquibase provides listLocks command that read the DATABASECHANGELOGLOCK
table and return a list of IP address
, host name
, and time stamp
of the user
or process
who currently having the lock
on the database
.
Liquibase
also provides a releaseLocks command
, that will release all locks
present in DATABASECHANGELOGLOCK
table.
liquibase.properties (update changeLog File file format with SQL, XML, YAML, JSON as per changelog.mysql.)
liquibase.command.url=jdbc:mysql://localhost:3306/appleDb?createDatabaseIfNotExist=true&autoReconnect=true&useSSL=false&allowPublicKeyRetrieval=true
liquibase.command.username= root
liquibase.command.password= rootroot
execute the command
liquibase releaseLocks