Service Crash

Approximately an hour ago the Amazon instance hosting the sipsorcery service froze/crashed. It happened as I was attempting to clean up the cdr’s database table by deleting the older cdr records. There were nearly half a million call records in the table which was hampering the ability to scroll through them in the Silverlight interface. It was a fairly innocuous operation but unfortunately it’s had some significant consequences.

The bad news is that at this point it looks like all the data from the sipsorcery service has been lost. That includes all user accounts, SIP providers, dial plans etc. The reason it has been lost is that I made a mistake when setting up the MySQL database and the data directory was sitting on the C: drive and not the F: drive. The F drive in this case was an Amazon ElastiC Block Volume (EBS) which survives across instance reboots. Somehow when I installed MySQL I configured it so that only the directory for the MySQL binaries was on the F volume but the data directory was on the C drive.

The good news is the service is back up and running (now with the MySQL database on the F: drive). It’s a relatively quick operation to recover in the event of a crash like this since the IP address and volume can be re-attached to a new instance very easily.

Unfortunately anyone wanting to use the sipsorcery service will need to re-create their account and dialplans etc. I realise it’s a real pain and I lost all my settings as well so am also suffering.

Sorry,

Aaron

  1. jadam’s avatar

    Thanks for letting us know, in the immortal words of Alan Sugar, you’re fired! 🙂 I’ve got all my details backed up so no issues for me

    Reply

  2. stillywud’s avatar

    i’m sorry to hear that…

    Reply

  3. TheFug’s avatar

    Already re-created my old account settings, only now TPAD won’t register, double checked the account data, no error there.

    Reply

  4. Jone’s avatar

    I am a chinese user.
    I found sipsorcery is very perfect!I love you^_^
    We don’t complain you~
    but next time when you erase data you must see more carefully and carefully~or our data will be lost-_-!
    haha~~Continue you work. I support you.
    I believe sipsorcery will be the best free services all over the world.

    Reply

  5. sipsorcery’s avatar

    tpad is ok for me. Registered straight away.

    Reply

  6. TotalDistinction’s avatar

    Where were the backups to recover from in case of such a failure? I can only guess that they weren’t any.

    Reply

    1. guduri’s avatar

      I guess Aaron means the software had a backup but the data did not. For a free service sipsorcery is really good despite this crash. Thanks Aaron.

      Reply

    2. zcharming’s avatar

      It’s an accident for all of users. but we cannot complaint for this because SSY is a free service and It’s the best PBX service!

      I tried to recover my account and dialplan, but I found I cannot do it, because if the dial is faile, I cannot do anything? it’s not same as the before SSY. can I know why with this?

      Reply

    3. MyVoip’s avatar

      I am back up and running again!! I am not complaining just because this is free service BUT this is the best service with ability to create very flexible dial plans

      I had a copy of my dial plan saved so setting up the account back was a breeze !!

      Reply

    4. TheFug’s avatar

      Just tried again to register TPAD, and now it works just fine !

      Reply

    5. macman4hire’s avatar

      Thank you for all the you have done on Sip Sorcery. All anyone can hope to do is learn from mistakes and it is great to hear that you identified the problem with the database. Once again thanks for giving us the some VoIP magic with Sip Sorcery.

      Reply

    6. Mikey’s avatar

      Please consider a dbase “backup option” for SipSorcery members?
      Mikey

      Reply

    7. msiam’s avatar

      Soo.. SipSorcery seems to be down this morning, 09/21/09, is there anyone out there that can verify that it is SS or is it IPKall, or is GV winning the battle?? I just started using SS this past week and all was cool yesterday, now today… I got problems.. 8( Somebody SAY Something!!! PLease

      Reply

      1. sipsorcery’s avatar

        I was asleep at the time you posted but there’s nothing to indicate there was any kind of outage. I get an SMS alert if the service stops responding and people will very quicly post a note on the forums http://www.mysipswitch.com/forum/index.php. Neither happened.

        Reply

Reply

Your email address will not be published. Required fields are marked *