Database size 2Gb issue

[SplanK]

Hello,
I have been running SS for years, however every now and then I encounter a database size issue where its reaches 2GB and whilst I can log into the web client and view content, I am not able to play any video or audio, add any new tracks and my Subsonic app (dsub) has a bit of a fit and will only play cached content.

In the past, ive followed this:
https://dpedu.io/article/2015-08-01/sub ... corruption

Where you change a flag in a file and it recovers, jowever it no longer seems to work. Attempting to run the DB cleanup doesnt appear to do anything either.

The last time this happened, I ended up starting again (complete uninstall and re-install, including new database) thinking there was something iffy with the original database. However today, it has done it again.

In the log, I will eventualy get errors surrounding update queries as per above link.

Log as it stands however after restarting the service a short while ago:

[3/6/18 2:48:12 PM GMT] INFO HsqlDaoHelper Checking database schema.
[3/6/18 2:50:19 PM GMT] INFO HsqlDaoHelper Done checking database schema.
[3/6/18 2:50:20 PM GMT] INFO SettingsService Java: 1.8.0_161, OS: Windows Server 2012 R2
[3/6/18 2:50:21 PM GMT] INFO VersionService Resolved local Subsonic version to: 6.1.3
[3/6/18 2:50:22 PM GMT] INFO MediaScannerService Automatic media library scanning scheduled to run every 1 day(s), starting at Wed Mar 07 03:00:00 GMT 2018
[3/6/18 2:50:23 PM GMT] INFO UPnPService Starting UPnP service...
[3/6/18 2:50:23 PM GMT] INFO PodcastService Automatic Podcast update scheduled to run every 24 hour(s), starting at Tue Mar 06 14:55:23 GMT 2018
[3/6/18 2:50:24 PM GMT] INFO UPnPService Disabling UPnP/DLNA media server
[3/6/18 2:50:24 PM GMT] INFO UPnPService Starting UPnP service - Done!
[3/6/18 2:50:36 PM GMT] INFO BootstrapVerificationFilter Servlet container: jetty-6.1.x
[3/6/18 2:51:32 PM GMT] INFO VersionService Resolved latest Subsonic final version to: 6.1.3
[3/6/18 2:51:32 PM GMT] INFO VersionService Resolved latest Subsonic beta version to: 6.1.beta2
[3/6/18 2:52:42 PM GMT] INFO NetworkService Deleted port mapping for port 4040
[3/6/18 2:54:50 PM GMT] INFO NetworkService Deleted port mapping for port 4443
[3/6/18 2:55:23 PM GMT] INFO PodcastService Starting scheduled Podcast refresh.
[3/6/18 2:55:23 PM GMT] INFO PodcastService Completed scheduled Podcast refresh.
[3/6/18 2:57:54 PM GMT] INFO MediaScannerService Starting to scan media library.
[3/6/18 2:57:54 PM GMT] ERROR MediaScannerService Failed to scan media library.
[3/6/18 2:57:54 PM GMT] INFO PlaylistService Starting playlist import.
[3/6/18 2:57:54 PM GMT] INFO PlaylistService Completed playlist import.
[3/6/18 2:58:06 PM GMT] INFO MediaScannerService Starting to scan media library.
[3/6/18 2:58:06 PM GMT] ERROR MediaScannerService Failed to scan media library.
[3/6/18 2:58:06 PM GMT] INFO PlaylistService Starting playlist import.
[3/6/18 2:58:06 PM GMT] INFO PlaylistService Completed playlist import.

[SplanK]

WOHO - fixed it!

navigated to https://addressofserver.com/db.view

I ran command SHUTDOWN COMPACT

This compacted the database down from 2GB to 16MB

Restarted the Subsonic windows service and all is good with the world.... until next time that is but at least I now have a fix!

[Tak-MK]

Yay! Thanks for the command!

[Krosscheck]

Thank you! Thank you! Thank you! I've had to come back and look for this command 3 times now - It's a life-saver.

WOHO - fixed it!

navigated to https://addressofserver.com/db.view

I ran command SHUTDOWN COMPACT

This compacted the database down from 2GB to 16MB

Restarted the Subsonic windows service and all is good with the world.... until next time that is but at least I now have a fix!