-LOCKED - Today's Downtime.
Posted on 2017-05-02 08:57:44
Hey all. Thank you so much for your patience today regarding the downtime.

What was the downtime for?
We received an email last week notifying us that some time over the next few months our servers would be physically moved from one location to another, and they promised us ample time to prepare for this move. We then received an email a few days later stating that our servers would be moved the following day, and that a time slot of 12 hours was designated although they predicted only 2-3 hours of actual downtime would be needed. We were alarmed that it was so short notice and the window in which the downtime could happen was so long. We luckily managed to rearrange the servers to be moved on 1st May. This was the main reason for the downtime.

So what happened?
1st May rolled around and we waited with anticipation for the servers to shut down. As both coders are in the UK we were hoping that they would take the servers down just in time for us to get online and handle the aftermath. What we didn't expect was just how messed up the aftermath would be.

What should have been a simple 3 hour job turned into a nightmare day. The actual moving of the servers was over and done with early on in the day, but when we logged in we discovered that pretty much the entire database was corrupted. We investigated the logs on the servers to find that the host had started a graceful shutdown (to those who don't know, this means that they were closing everything down before turning the server off) but as time went on we believe they became impatient with it taking so long. The startup logs showed that the "Database was not shut down normally".

We have seen almost an entire day of downtime not because of the initial move, but because we have been trying to restore all the data that was corrupted.

What does this mean?
We have essentially had to do a minor rollback of the game. We store regular backups of our most important data so lions, members and hoards are the most recent - although there may be some time disconnects as lions were backed up most recently, then before that was hoard, then before that was members, etc.

Unfortunately the one table we were unable to restore has been messages. The inbox table was completely corrupted and we have no workable backup. We are continuing to try and restore everything, and the message system will continue working as it did before, but until further notice we are unable to retrieve your messages. We will be working through the night to try and get inboxes back together, but we have no guarantee that we can get this working. We’ll do our very best however!

You may notice that there was no rollover today - this failed to run regardless as it was due to run in the middle of the time the hosts took our servers offline. Due to the large amount of downtime today, we decided not to run it again, so nobody will have a rollover until tomorrow, as you normally would.

Here is a list of the backups and when they were taken to give you an idea of what data might not quite line up for you:
* Lions may not be as 100% recent as you may have wanted if you were on and making changes to lions (claiming new, customising, breeding etc) close to when we went down. We imported a backup very close to the downtime, which was taken approximately 1 hour and 20 minutes before the server went down.
* The same goes for hoard, which is a backup taken 25 minutes before the lions backup.
* User logs were imported from a backup taken 45 minutes before hoard.
* The rest of the database is imported from a backup taken 30 minutes before the user log backup.

This means that any activity taken after these backups is now lost. We hope you can appreciate how close the backups were to downtime to avoid further loss.

Lion counts may appear incorrect for those who had new lion activity between the main database backup and the lion backup (1 hour and 40 minutes gap), but this should fix itself on your next rollover.

GB purchases are of particular importance, and any that do not show up in your purchase log on the game or appear to have been credited to your account should be reported. Please send your PMs to Katze (#3) regarding this and they’ll get recredited. Mention in the PM the time/date of purchase, transaction ID, amount bought and the email address you used via Paypal.

We’d just like to reiterate that we will be spending a considerable amount of time and effort trying to get inboxes back for you guys, but we can’t make promises. We’d also like to apologise for all of this mess - sadly it was out of our control, but we’re doing our very best to rectify everything!



Hrt Icon 0 players like this post! Like?

Edited on 02/05/17 @ 16:01:20 by Kitty (#2)

Lunastar [Ferus]
[Quad Onyx] (#97406)

Angelic
View Forum Posts


Posted on
2017-05-02 18:35:31
Thanks ^-^



Hrt Icon 0 players like this post! Like?

SᥙgᥲᥣᥱssL&io
ta;zᥲrd (#23111)


View Forum Posts


Posted on
2017-05-02 19:10:47
*gets ready to burn people* one thing I learnt in college let the server shut down before moving/working on stuff it's the first thing you learn when working with servers, who in the right mind give the go ahead to move before shut down. (Wants words with the dude) and there we go xD me failing simple coding again



Hrt Icon 0 players like this post! Like?


Edited on 03/05/17 @ 02:40:40 by Sand'O'Death|🦎| (#23111)

Immortal 💜
[brimstone queen (#104310)

King of the Jungle
View Forum Posts


Posted on
2017-05-02 19:31:17
messages q---q



Hrt Icon 0 players like this post! Like?

Flash. (#26282)

Bone Collector
View Forum Posts


Posted on
2017-05-02 20:42:47
The main thing is that Lioden is still here and back at its good old self, for the most part. You guys handled the situation very well and I'm sure all the users understand and appreciate this <3



Hrt Icon 0 players like this post! Like?

vet tech mama (#105189)

Renowned
View Forum Posts


Posted on
2017-05-02 21:56:42
awww you guys are great:) Thank you so much for all your hard work:) This is why I love this site and people on it:)



Hrt Icon 0 players like this post! Like?

juice | G3 colorbomb
pie (#73793)

Magnificent
View Forum Posts


Posted on
2017-05-02 22:05:14
All is well, Abbey. Many thanks to you and all of the Lioden staff that helped fix it all up! Definitely changing my tag for this :)



Hrt Icon 0 players like this post! Like?

Rhysees Puff (#105971)

Heavenly
View Forum Posts


Posted on
2017-05-02 22:30:21
Thank you for all your hard work! Unfortunately i did have one important message but ill try and remember which user it was sent to



Hrt Icon 0 players like this post! Like?

Unahwi (#100777)

Bone Collector
View Forum Posts


Posted on
2017-05-02 23:03:49
Oh dear, well at least everything is alright



Hrt Icon 0 players like this post! Like?

Sans' Dadster (#100635)

King Of Hearts
View Forum Posts


Posted on
2017-05-02 23:14:01
You guys work so hard We love you!



Hrt Icon 0 players like this post! Like?

Okibi|CleanG1 Ebony
Torn 5xRos (#43161)

King of the Jungle
View Forum Posts


Posted on
2017-05-03 05:16:57
Woah, sounds crazy. Thank you coders, for restoring Lioden after that mess!



Hrt Icon 0 players like this post! Like?

Megajaco9 (#100861)

Fearsome
View Forum Posts


Posted on
2017-05-03 15:47:49
This is good to know



Hrt Icon 0 players like this post! Like?

Chully (#38605)

Kind
View Forum Posts


Posted on
2017-05-04 02:40:07
good deal. thanks for keeping everyone updated!



Hrt Icon 0 players like this post! Like?

Marmie (#89610)

King of the Jungle
View Forum Posts


Posted on
2017-05-04 06:13:01
You all do such wonderful work and are appreciated for everything you all do. Thank you so much. So if anyone complains just let it roll off your back because as from what I see most of us on here care very much for everything you do. Thanks again.



Hrt Icon 0 players like this post! Like?



Topic is locked




Memory Used: 629.30 KB - Queries: 0 - Query Time: 0.00000 - Total Time: 0.00437s