db won't initialize

Need help? Post your questions here.

Moderator: moderators

db won't initialize

Postby skiKK » Tue Mar 05, 2013 5:41 am

SS has been running fine for a long time just fine, probably 2 years now. recently my CPU started failing which caused numerous BSOD. Now, as of two days ago, SS will start (according to Services and tray icon). I can get to SS Control Panel but can't get a browser connection on 4040. I did a full uninstall of SS and Java, followed by clean install of Java then Subsonic, rebooting after each one, and still have the same issue - the Control Panel showing SS is running, but get error 503 Service Unavailable when trying to access via browser and get error "server unavailable" from all clients - Win 7 pro, AMD Athlon X2 270, 8GB, SS 4.7, Java 6.39

Subsonic.Log:
[2013-03-04 20:45:15,751] INFO Schema25 - Database table 'version' not found. Creating it.
[2013-03-04 20:45:19,569] ERROR DaoHelper - Failed to initialize database.
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: File input/output error c:\subsonic/db/subsonic.backup java.io.EOFException: Unexpected end of ZLIB input stream
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:82)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:382)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:429)
at net.sourceforge.subsonic.dao.schema.Schema25.execute(Schema25.java:36)
at net.sourceforge.subsonic.dao.DaoHelper.checkDatabase(DaoHelper.java:110)
at net.sourceforge.subsonic.dao.DaoHelper.<init>(DaoHelper.java:67)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:100)
at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:61)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:877)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:839)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:440)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory$1.run(AbstractAutowireCapableBeanFactory.java:409)
at java.security.AccessController.doPrivileged(Native Method)
...

Caused by: java.sql.SQLException: File input/output error c:\subsonic/db/subsonic.backup java.io.EOFException: Unexpected end of ZLIB input stream
at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
at org.hsqldb.jdbc.jdbcConnection.<init>(Unknown Source)
at org.hsqldb.jdbcDriver.getConnection(Unknown Source)
at org.hsqldb.jdbcDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:174)
at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:165)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:149)
at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:119)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:113)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:79)
... 82 more

[2013-03-04 20:45:19,689] INFO VersionService - Resolved local Subsonic version to: 4.7

any help would be appreciated
skiKK
 
Posts: 2
Joined: Tue Mar 05, 2013 4:50 am

Re: db won't initialize

Postby BKKKPewsey » Tue Mar 05, 2013 6:44 pm

First thing to try is to turn off the firewall and check using the local host link from the SS control panel.
If it works you know what the problem is.

:mrgreen:
Everyone is entitled to be stupid, Image but some abuse the privilege!

Due to the confusion from too many genres of music, we have decided to put both country music and rap music into the genre of Crap music.
User avatar
BKKKPewsey
 
Posts: 2080
Joined: Mon May 23, 2011 12:16 pm
Location: United Kingdom

Re: db won't initialize

Postby skiKK » Tue Mar 05, 2013 6:46 pm

Solved/resolved

I don't know the root-cause of my problem but here's what I did since yesterday's post:
Removed IIS features, rebooted, uninstalled Java, rebooted, uninstalleded Subsonic, rebooted. Then installed IIS services, rebooted, installed Java6 x64, rebooted, java6 x86, rebooted, deleted all subsonic folders, rebooted, reinstalled SS, rebooted and was able to connect via the web browser.

Rescanning of my 101,000 tracks is in progress.
I've re-added my user accounts and once the scan is complete I'll be golden.
Subsonic rocks!



ski-KK
skiKK
 
Posts: 2
Joined: Tue Mar 05, 2013 4:50 am


Return to Help

Who is online

Users browsing this forum: No registered users and 22 guests