Out of Memory (java?)

[infocalypse]

Hey folks,

I've been running a registered copy of Subsonic for ages but recently I noticed my Android app couldn't communicate with the server and was giving "Didnt understand the reply" messages for pretty much everything. I tried cycling the Subsonic service and even rebooting the server with no luck. I was trolling the subsonic logs and spotted this:

[2017-02-21 13:46:34,473] INFO HsqlDaoHelper - Checking database schema.
[2017-02-21 13:46:35,051] ERROR HsqlDaoHelper - Failed to initialize database.
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: error in script file line: 63 out of memory

I've tried cranking up the amount of memory defined for the service as high as 1GB with no change. I also tried upgrading from my ancient v4.8 to 6.0 but I'm seeing the same error. Can someone point me in the right direction?

[toolman]

Can you login to Subsonic and use the webinterface without any problems?
On which OS is your Subsonic-server running?
Which Java version is running?
Did you try updating or repairing Java on your server?

[infocalypse]

Negative, the web interface is broken as well. Here's what I see when attempting to hit the page, regardless of whether I'm remote or local on the server:

HTTP ERROR: 503

SERVICE_UNAVAILABLE
RequestURI=/

Powered by jetty://

The OS is Windows 10. I just updated Java to 1.8.0_121 but I'm seeing the same failures.

[toolman]

It seems your database is corrupt.
Try this:
Stop Subsonic service. Copy the content from folder subsonic\db.backup\ to subsonic\db\ overwriting all existing files.
Start the service and try logging in.
If that doesn't work you could try:
Stop Subsonic service. rename the folder Subsonic.db to Subsonic.db.old
Start Subsonic service.
Subsonic will recreate the database folder. You will have to reconfigure Subsonic from scratch so don't be surprised if you must follow all the steps required with a brandnew installation.

[infocalypse]

Looks like you were correct. Applying the backup DB didn't help but renaming the db folder (and forcing a recreate) did work - and yes, now I'm re-setting all the various config bits but that's no big deal. Thanks for the assist!

[toolman]

Thanks for letting us know that you've solved your problem.

[infocalypse]

Drat, OK, new problem. Re-scanning my library results in... nothing. I've tried manual re-scans and scheduled scans with no luck. When initiating a manual scan (local drive, not networked) the counter gets up to ~95k files or so and then simply disappears. The web UI and android interface both show no music at all.

I've yet to find anything interesting in the logs but I could be looking in the wrong place. Any ideas?

[toolman]

You did configure Settings >> Users >> Allow access to these media folders ?
If you keep having problems I would suggest uninstalling subsonic.
Manually delete any remaining folders from the current installation and install Subsonic again.

[infocalypse]

Well, crap. That was it - I'd allowed access to the Music share for my regular users... but not for admin. Figures.

Thanks again!