(/subsonic/index.view) is not available

[stebbi67]

Hi.

I have been trying to upgrade from 3.3 to 3.7. Doing that I followed the War install instructions here : http://subsonic.sourceforge.net/installation.php#war

After the installation I started apache-tomcat, but subsonic was unavailable, according to the /var/subsonic/subsonic.log it could not log in to the database ( "is presumably locked by another process" in the log ). So I followed these instructions ( http://forum.subsonic.org/forum/viewtop ... 24a9b511b0 ) :

o Stop Subsonic.
o Remove c:\subsonic\db
o Start Subsonic.

Now I get this waring in the web browser :

HTTP Status 404 - /subsonic/index.view

type Status report

message /subsonic/index.view

description The requested resource (/subsonic/index.view) is not available.
Apache Tomcat/5.5.25

And this error in the /var/subsonic/subsonic.log :

[2009-07-16 10:55:49,596] INFO DaoHelper - Checking database schema.
[2009-07-16 10:55:49,737] INFO Schema25 - Database table 'version' not found. Creating it.
[2009-07-16 10:55:49,745] ERROR DaoHelper - Failed to initialize database.
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQ
LException: The database is already in use by another process: org.hsqldb.persist.N[2009-07-16 11:00:46,797] INFO Podcast
Service - Starting scheduled Podcast refresh.
[2009-07-16 11:00:46,798] INFO PodcastService - Completed scheduled Podcast refresh.
ic/db/subsonic.lck] is presumably locked by another process.

Now I'm out of ides. Does anyone have idea how to trouble shoot this issue?

Java = jdk1.6.0_04


Thanks,

Stebbi67

[stebbi67]

Some more info from the catalina ( apache-tomcat ) log:

Jul 16, 2009 1:34:47 PM org.apache.catalina.loader.WebappClassLoader loadClass
INFO: Illegal access: this web application instance has been stopped already. Could not load org.apache.commons.logging.
impl.Log4JLogger. The eventual following stack trace is caused by an error thrown for debugging purposes as well as to a
ttempt to terminate the thread which caused the illegal access, and has no functional impact.
java.lang.IllegalStateException
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1248)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1208)
at org.apache.commons.logging.impl.LogFactoryImpl$1.run(LogFactoryImpl.java:441)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.commons.logging.impl.LogFactoryImpl.loadClass(LogFactoryImpl.java:435)
at org.apache.commons.logging.impl.LogFactoryImpl.getLogConstructor(LogFactoryImpl.java:376)
at org.apache.commons.logging.impl.LogFactoryImpl.newInstance(LogFactoryImpl.java:529)
at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:235)
at org.apache.commons.logging.impl.LogFactoryImpl.getInstance(LogFactoryImpl.java:209)
at org.apache.commons.logging.LogFactory.getLog(LogFactory.java:351)
at org.springframework.jdbc.support.JdbcAccessor.<init>(JdbcAccessor.java:41)
at org.springframework.jdbc.core.JdbcTemplate.<init>(JdbcTemplate.java:152)
at net.sourceforge.subsonic.dao.DaoHelper.getJdbcTemplate(DaoHelper.java:67)
at net.sourceforge.subsonic.dao.DaoHelper$1.run(DaoHelper.java:55)

[stebbi67]

Anyone?

[donpearson]

Anyone?

Not yet.

[stebbi67]

Bit more information :

Kernel Version 2.6.26-2-686 (SMP) i686
Distro Name Debian 5.0.2

Same user rights as on 3.3

[stebbi67]

Well, do not worry about this. I cleaned everything out and then installed 3.7.

It works like a charm now.