Dealing with locked H2 database

Created
October 08, 2021 23:27

Date Posted: 2018-02-23
Product: TIBCO Spotfire®

Problem:

Solution:

When trying to reach the TSSS landing page a 'Not found' error is thrown with the following error in the SplusServer.log file:

=====
Caused by: org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Database may be already in use: "Locked by another process". Possible solutions: close all other connection(s);
=====

There is a lock file on the H2 database (TSSSInstall\h2\db.lock.db) to prevent access by multiple programs. When the TSSS service is stopped the db.lock.db file should be removed, then restored when the service is restarted. If the file isn't removed then another process may be accessing the service. Look for these processes with this command:

>ps -ef | grep spserver

Delete these services, confirm the db.lock.db file is behaving as expected, then try reaching TSSS again.