During application server startup, the following error is shown in the application server log:
Caused by: java.lang.IllegalStateException: liquibase.exception.LockException:
Could not acquire change log lock. Currently locked by XXXXXXXXX (XXXXXXX)
As a result of this error, the application server fails to start successfully.
The DATABASECHANGELOGLOCK table in the primary data source has not been updated with the release lock information, and the lock flag is enabled while the application server starts up.
This is a result of killing the application server.
LOCKED = 0
LOCKGRANTED = NULL
LOCKEDBY = NULL
A sample query is provided below:
SET [DATABASECHANGELOGLOCK].LOCKED = 0,
[DATABASECHANGELOGLOCK].LOCKGRANTED = NULL,
[DATABASECHANGELOGLOCK].LOCKEDBY = NULL
Note: The above SQL is provided by Appian as a sample and may not run correctly in all supported relational databases. For database-specific syntax, please contact your database administrator.
This article applies to all versions of Appian.
Last Reviewed: February 2017
© 2020 Appian. All rights reserved.