Hi all,
I tried upgrading to the 3.7 beta today and can't get tomcat to start it. Went back to 3.6 to ensure my tomcat instance isn't the culprit...3.6 works fine. Here is my config:
Ubuntu 9.04 - amd64
Tomcat 6.0.18
Java 1.6.0_13-b03
Subsonic 3.7 beta (war file deployment)
Subsonic doesn't start after starting tomcat via command line.
Trying to start subsonic via the tomcat manager GUI I receive: "FAIL - Application at context path /subsonic could not be started"
/var/subsonic/subsonic.log indicates:
[2009-05-09 08:50:15,403] ERROR DaoHelper - Failed to initialize database.
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@2d6451a6[file =/var/subsonic/db/subsonic.lck, exists=true, locked=false, valid=false, fl =null]:
Caused by: java.sql.SQLException: The database is already in use by another process: org.hsqldb.persist.NIOLockFile@2d6451a6[file =/var/subsonic/db/subsonic.lck, exists=true, locked=false, valid=false, fl =null]:
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
Not sure if this error is related to the root cause. I should also mention that I tried rebooting the server (a feeble attempt to free up any strange locking behavior). I'm happy to post my full tomcat log if anyone thinks that may help. Any assistance would be appreciated!