the 503 error bug: I've had it

[D-e-n]

It is a long lasting problem with Subsonic: the 503 error bug. A couple a times a year I can't reach my Subsonic server. Subsonic has crashed and files in the db-folder are (as it seems) corrupt. Sometimes I can fix my database by copying the script-file and the settings from the db-folder but most of times I at least have lost my playlists. Today again...........

I love Subsonic but I am fed up with this. And I have three questions:

1) Why is the database corrupt so many times? When there is a power cut or my windows pc hangs during an update: all programs function again after a restart but Subsonic is unreachable and I have lost files.
2) Why isn't there an option to backup the database and playlists from within the program?
3) And last but not least. Where are those ***** playlist stored? Why not using normal m3u playlists? It's a pain in the ass backing up playlist or using them in another program.

[Jägs]

I used to have this problem, too, and upping the memory in the config seemed to help. Because I was burned a couple of times by this, I wrote a Perl script to back up the playlists--which are stored in the DB--to M3U files. You can get the script from this thread:

viewtopic.php?f=5&t=17436

I also have a modified version of this script that will export "starred" songs as well.

In this way, if your DB or install gets borked, assuming your music paths remain the same, you can just reinstall, set up the music paths in Subsonic, scan, and then import your playlists generated from this script.

[D-e-n]

Tnx! I will try it. The script can be very useful, not only on crashes.

[peskelsin]

I used to have this problem, too, and upping the memory in the config seemed to help. Because I was burned a couple of times by this, I wrote a Perl script to back up the playlists--which are stored in the DB--to M3U files. You can get the script from this thread:

viewtopic.php?f=5&t=17436

I also have a modified version of this script that will export "starred" songs as well.

In this way, if your DB or install gets borked, assuming your music paths remain the same, you can just reinstall, set up the music paths in Subsonic, scan, and then import your playlists generated from this script.
Thanks
liteblue

Thank you so much for the solution. Its really helpful.