Dealing with locked H2 database
Article ID: KB0082483
Updated On:
| Products | Versions |
|---|---|
| Spotfire Statistics Services | All supported versions |
Description
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);
=====
=====
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);
=====
Issue/Introduction
When trying to reach TSSS instance a 'Not Found' error is thrown
Environment
Product: TIBCO Spotfire (Desktop client / Analyst)
Version: All supported versions
OS: Linux RedHat
Resolution
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.
>ps -ef | grep spserver
Delete these services, confirm the db.lock.db file is behaving as expected, then try reaching TSSS again.
Attachments
Feedback
Yes
No
Powered by
