list-locks
list-locks
returns the hostname, IP address, and the timestamp the Liquibase lock record was added to the DATABASECHANGELOGLOCK table.
Uses
list-locks
is typically used when an error occurs during a database deployment. The error might indicate that there is a lock record in the DATABASECHANGELOGLOCK table by another user that is preventing Liquibase from applying changes to the specified database.
list-locks
will read the DATABASECHANGELOGLOCK table and return a list that includes the hostname, IP address, and the timestamp the lock record was granted to the DATABASECHANGELOGLOCK table and determines the connections to the DATABASECHANGELOGLOCK table based on the database URL.
Running the list-locks
command
To run the list-locks
command, specify the driver, classpath, and URL in the Liquibase properties file. For more information, see Specifying Properties in a Connection Profile. You can also specify these properties in your command line.
Then run the list-locks
command:
liquibase –-changelog-file=mainchangelog.xml list-locks
Note: Enter the name of the changelog you want to use in place of main-changelog.xml
. You can also add the changelog-file
to the properties file.
list-locks
global attributes
Attribute | Definition | Requirement |
---|---|---|
--changelog-file
|
The root changelog | Required |
--username |
The database username | Required |
--password |
The database password | Required |
--url
|
The JDBC database connection | Required |
Note: The username
and password
attributes are not required for connections and systems which use alternate means of authentication.

The list-locks
command produces the following output when there is no lock on the table:
Liquibase Community 4.9.1 by Liquibase
Database change log locks for DBUSER@jdbc:h2:tcp://localhost:9090/mem:dev
- No locks
Liquibase command 'list-locks' was executed successfully.
The list-locks
command produces the following output when there is a lock on the table:
Liquibase Community 4.9.1 by Liquibase
Database change log locks for DBUSER@jdbc:h2:tcp://localhost:9090/mem:dev
- 2605:6000:101c:686:486:f4ae:82fe:3c99%en0 (2605:6000:101c:686:486:f4ae:82fe:3c99%en0) at May 6, 2022, 9:04:38 PM
Liquibase command 'list-locks' was executed successfully.