Error 4776 - Change log lock (HSQL)
Posted: Thu Jul 30, 2026 7:24 pm
I've inherited a Unimus server that is getting unable to upgrade the database error. I've searched for the log and found the bottom entry.
10.232 ERROR 4776 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.boot.step.DatabaseUpdate : Failed to update database schema. Reason = 'liquibase.exception.LockException: Could not acquire change log lock. Currently locked by XXXunimus (10.10.x.xx) since 7/19/26 6:06 PM'
HSQL is the database in use
Some online research points me to run this:
UPDATE DATABASECHANGELOGLOCK SET LOCKED=0, LOCKGRANTED=null, LOCKEDBY=null where ID=1;
When I try to connect to HSQL using DBeaver and the "SA" account (with no password), I get this error...
SQL Error [42501]: user lacks privilege or object not found: DATABASECHANGELOGLOCK
Am I doing this right? should I be doing something else? Is the SA account with no password not enough?
Thank you ahead of time!
10.232 ERROR 4776 --- [SimpleAsyncTaskExecutor-1] n.u.s.b.boot.step.DatabaseUpdate : Failed to update database schema. Reason = 'liquibase.exception.LockException: Could not acquire change log lock. Currently locked by XXXunimus (10.10.x.xx) since 7/19/26 6:06 PM'
HSQL is the database in use
Some online research points me to run this:
UPDATE DATABASECHANGELOGLOCK SET LOCKED=0, LOCKGRANTED=null, LOCKEDBY=null where ID=1;
When I try to connect to HSQL using DBeaver and the "SA" account (with no password), I get this error...
SQL Error [42501]: user lacks privilege or object not found: DATABASECHANGELOGLOCK
Am I doing this right? should I be doing something else? Is the SA account with no password not enough?
Thank you ahead of time!