Subsonic Forum

You have to wait until I upgrade MusicCabinet to REST version 1.8.0.. which should happen fairly soon I hope!

What happens on the Subsonic demo server?

Just an FYI, but the latest MadSonic beta is using REST version 1.9.0, and a 1.9.1 version may be coming soon (from what MadEvil told me via PM).

You're a very loyal user recommending standard Subsonic/Madsonic the day after your database crashed, forcing you to reinstall and re-add all your users

hakko wrote:You're a very loyal user recommending standard Subsonic/Madsonic the day after your database crashed, forcing you to reinstall and re-add all your users

I think the db crash was my fault though... lol

I was messing around with the razorsql app, but I just don't recall making any changes. I only had like 4 or 5 users other than myself, so restoring was pretty quick.

I see this sort of thing and get flamed a bit for my comments regarding, but I'll do it again for the sake of new Subsonic users and those considering trying Subsonic, Madsonic, Music Cabinet. or any other Subsonic branch.

I have several servers and some of those are running Hyper-v VM's which allows me to test all this stuff frequently and to play around with different configurations without corrupting baseline installations. My very first server was an HP ex485 that we bought when they were first introduced. It's still running today. It is running the original software, WHS v1 but the hardware has undergone some upgrades. It now has a 3.0GHz dual core Xeon CPU and 4GB of ram and has 4 2TB hard drives. It just sits on the shelf humming along day after day needing virtually NO attention and whenever I do an occasional logon and check event viewer there are NEVER any errors in event viewer.

It has been running Subsonic in one form or another for several years - AND HAS NEVER CRASHED.

I've suggested and still would argue that 99% of the issues we see here in the forums are primarily self-inflicted wounds that are the result of underlying problems on the host machine's OS or user impatience during the installation/upgrade process.

I'm not trying to cast aspersions on anyone's tech abilities here, but Subsonic is a complicated application that does require above average skills to install properly and troubleshoot. It's just the nature of the beast. One of the benefits of using SS is the education the user will get by learning everything one needs to know to get it up and running. It takes a little effort and the primary skill sets needed are PATIENCE and the ability to READ. Lacking either of those one would be better served sticking with iTunes.

We seasoned vets take a lot for granted. We've learned how to set up our routers, open ports, set static ip addresses, install Java, and do all the other things involved in setting up Subsonic. There may actually be the occasional new user who downloads and install SS and gets it to work on the first try, but I would think that percentage is VERY low. Most new users first need to understand and figure out the routing and firewall issues. Then there is the whole Java and database relationship thing that is the SS Achilles heel. Almost any installation/upgrade glitch will screw the pooch and I always back up my data before doing this just in case something doesn't go right. This can also get easily screwed by any improper shutdown/restart even ones caused by automatic upgrades from MS.

There may be newer database technologies that have better self-recovery abilities than what Subsonic uses that would help avoid some of these problems. I don't know, I'm no expert on the subject.

I'm only trying to point out here that a properly set up Subsonic installation can run indefinitely without any problems at all. It's usually when we try to fix what ain't broke that we end up shooting ourselves in the foot.

And all that is before you get into the whole ffmpeg transcoding thing!

GJ51 wrote:...been running Subsonic in one form or another for several years - AND HAS NEVER CRASHED.

Likewise. I've borked it up more times than I can count by doing something stupid, and I have a UPS so I almost NEVER have an ungraceful shutdown (which is my personal guess as the root cause of many of these corrupt databases). Subsonic has never screwed itself without my fingers being in there.

Of course YMWV (WILL vary),

Glenn

Hi,

since i upgrade Madsonic to the latest hsqldb 1.8.0.10 i saw for many months no crashes or bugs.

On the other side a Database without any Backup is no wise backup strategy

a backup script once per week is enough and beware you from total data loss.

best regards

I guess we can have this discussion forever and ever, but you won't convince me that HSQLDB that is written by one (or maybe two) persons and was released six years ago is a better piece of software than PostgreSQL, that has been worked on for the last twenty years by all these people: http://www.postgresql.org/community/contributors/

The fact that people keep reporting database crashes on the forum is enough for me. A good database is written to handle unplanned shutdowns, power outages etc. At worst, the last seconds of written data should not be commited. A database that goes totally corrupt, even on rare occasions, is useless for production code. Try selling that to a bank or a hospital?

I agree with MadEvil on doing backups, but only because hardware fails. And maybe because I sometimes write crappy code and then it's good having a backup to go back to.

No experience with PostGreSQL, but I have been using MySQL for a while now, and just set up a new database for my son's minecraft server, so he can rollback any unwanted changes to his worlds by other players.

It's a pretty cool game, even though the graphics are pretty old school.