Error 4776 - Change log lock (HSQL)

[Postgame]

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!

[Tomas]

Hi.

Newer versions of Unimus handle this automatically. It may be easiest to update Unimus to latest, and it should restore and update the DB during the first start on the new version.