If the Valsight Server process gets interrupted during a regular startup, the database may end up in a locked state.

To remove the lock, run the following query on the database.

UPDATE DATABASECHANGELOGLOCK SET LOCKED=false, LOCKGRANTED=null, LOCKEDBY=null where ID=1;
SQL

If you are running with the integrated H2 database, you may use the following tool to issue the above query against the DB.

Instructions

  1. Download Tool: ResetDBLock-ResetDBLock-1.0.jar

  2. Locate your Valsight directory

  3. Stop the Valsight Server

  4. Run the tool from the Windows Command Line (Windows-Key+R, cmd, [Enter]) (warning) The command must be run without the ".mv.db" extension:

    1. java -jar path/to/ResetDBLock-ResetDBLock-1.0.jar -f path/to/dbdir/prod 

Example Output