WTF Happened?! A Tale of Extended Downtime

Discussion in 'News & Updates' started by Hentai, Jun 20, 2014.

  1. Hentai

    Hentai Forum Theming Guy Administrator Supporter Defender of Defoko

    Messages
    396
    Likes Received
    314
    Trophy Points
    87
    Alright back up! For those that hadn't guessed already UtaForum suffered some extended downtime.

    This downtime was caused by the MySQL database that powers this site horribly corrupting after a server crash while the forum was in the middle of a critical read/write operation. The crash was caused by another website on our server node being DDOSed, overloading my server's memory, taking everyone hosted there down with it, UtaForum and many other sites I host included.

    With our main database corrupted I have spent the last couple days recovering what I could from our backups. I was able to save the users table and its associated data, the forum structure, the threads, PMS, and even the polls but sadly 'mybb_posts' was the one table I wasn't able to recover.

    I will try to see what I can do, but after having spent the last 5 days doing what I can I am not sure what else I can recover. I have even older backups, backups from early April but I am not sure how much good that will do us.

    For now UtaForum is tentatively back with myBB but as a shadow of its former self. Myst, the staff, and myself have much to discuss about where we want to go from here. We hope to have an announcement soon. Please check back later.
     
  2.  
  3. MystSaphyr

    MystSaphyr Procrastinator Extraordinaire Administrator Defender of Defoko

    Messages
    261
    Likes Received
    82
    Trophy Points
    58
    RE:

    I want to apologize deeply for what happened.

    Hentai, you've working incredibly hard on recovering everything and I greatly appreciate your help.

    If nothing else, we'd be able to make an archive of the aforementioned April backup to go alongside the Forumotion and Zetaboards iterations.
     
  4. oteto

    oteto Tetoholic Defender of Defoko

    Messages
    356
    Likes Received
    383
    Trophy Points
    93
    RE:

    Yiiiiiiii! Utaforum is back! You guys rock!
     
  5. Ori

    Ori Momo's Minion

    Messages
    4
    Likes Received
    0
    Trophy Points
    4
    RE:

    Ohhh, good luck! I know rollbacks can be a pain.
     
  6. Aion

    Aion Momo's Minion

    Messages
    1
    Likes Received
    0
    Trophy Points
    1
    RE:

    AHHHHHHHHHHHHHHHH NOO THAT IS TERRIBLE ; O ; I Mean if you guys managed yet to get some threads well there's a few ones with download links which i really needed it that i can't acess i'm sorry for what happened and i also thought it was my PC's problem lol
     
  7. Hentai

    Hentai Forum Theming Guy Administrator Supporter Defender of Defoko

    Messages
    396
    Likes Received
    314
    Trophy Points
    87
    As I said more backups exist, some older than others, some VERY VERY old.

    Depending on the specific threads age it may or may-not be recoverable.

    I will keep trying, but what you see today is the culmination of almost a week's work.

    More options may open up soon, I will keep you guys updated on the progress.
     
  8. Kyoren

    Kyoren Momo's Minion

    Messages
    8
    Likes Received
    1
    Trophy Points
    14
    RE:

    It's very sad to see this, but if there is anything we can do to help. Hopefully, let us know. c:
     
  9. kimchi-tan

    kimchi-tan Your local Mikotard Moderator Defender of Defoko

    Messages
    497
    Likes Received
    1,094
    Trophy Points
    119
    RE:

    [size=-3]I saw this thread this morning but I will make my reply now that others did.[/size]

    Hopefully the April backup could do us some good enough. It's really unfortunate for this to happen so suddenly. (Engloids.info seems fine though)

    Also, when will the discussion start?
     
  10. MillyAqualine

    MillyAqualine Ritsu's Renegades Defender of Defoko

    Messages
    489
    Likes Received
    310
    Trophy Points
    72
    RE:

    Happy to see it's back~
     
  11. Kyoren

    Kyoren Momo's Minion

    Messages
    8
    Likes Received
    1
    Trophy Points
    14
    RE:

    Most of us are still active in the Skype group chat though, if any of the moderators or Hentai would like to come there and collaborate with us?
     
  12. moonst4r

    moonst4r Witch of the Night Supporter Defender of Defoko

    Messages
    280
    Likes Received
    135
    Trophy Points
    72
    RE:

    It's unfortunate what happened, but at least the forum is back now! Thank you Hentai for your hard work you're doing for all of us.
     
  13. Uchuu

    Uchuu CeVIO Enthusiast Supporter Defender of Defoko

    Messages
    210
    Likes Received
    112
    Trophy Points
    69
    RE:

    Well, at least we're back now. o3o
    There's a Forum Skype? *wants in*
     
  14. insanemollum

    insanemollum Momo's Minion

    Messages
    78
    Likes Received
    1
    Trophy Points
    13
    RE:

    wow o.o i thought it was my pc that wasn't letting me access UTAforum
    anyways
    i'm glad to see it up and running again! :3
     
  15. Uchuu

    Uchuu CeVIO Enthusiast Supporter Defender of Defoko

    Messages
    210
    Likes Received
    112
    Trophy Points
    69
    RE:

    Might I say that A LOT of threads and posts are missing.. like, 90% of them...
     
  16. MystSaphyr

    MystSaphyr Procrastinator Extraordinaire Administrator Defender of Defoko

    Messages
    261
    Likes Received
    82
    Trophy Points
    58
    See Hentai's first post: The posts table is the one that was corrupted. There are separate tables for topics and posts, so while the topics were recovered, their posts weren't.
     
  17. Uchuu

    Uchuu CeVIO Enthusiast Supporter Defender of Defoko

    Messages
    210
    Likes Received
    112
    Trophy Points
    69
    RE:

    damn, that sucks. No more UST/VSQ thread, all those games...
    welp, it's a clean slate I guess, unless we can recover them?
     
  18. Umbreon126

    Umbreon126 Ruko's Ruffians Defender of Defoko

    Messages
    207
    Likes Received
    7
    Trophy Points
    32
    RE:

    Good luck on the continued recovery of the forum. Good job so far~
     
  19. _caustic_

    _caustic_ Double-crossed Lunatic Supporter Defender of Defoko

    Messages
    794
    Likes Received
    832
    Trophy Points
    130
    RE:

    Ah HELLa I'm crying!

    as long as the forum is back, I think as a community, most of the users would be just fine without their old threads/post!
    You have obviously been working your butt off getting things back into working order, even if there wasn't much to be done from this point (assuming that further dated backups don't have what you are looking for) a clean state might be a good thing in some way
    (okay, I'm trying to look at the bright side...I'm should shut up)
    ... ... ...
    too bad no one has been downloading the forum AND at least had a mirror of it (you know, for the links and such...though it probably wouldn't be of much use to you guys)
    (I totally would of done that, though I didn't because that is probably wrong from some moral standpoint...and it probably is irrational from a technical standpoint...for lack of a better term)
    edit: ...oh yeah...and someone downloading the whole forum every week would definitely siphon your allotted bandwidth... (._.)

    But even if you have some earlier backups, HAVING SOMETHING could be better than nothing!
    I couldn't imagine the work it takes to keep things working smoothly and consistantly, it is apparent that you have be kicking your self a bit getting things back in order- I almost say (short of the old theme) that things are pretty decent!

    I'm pretty sure that most would disagree, I'm trying to be an optimist and I'm not good at it...backward opinions, I have.
    If it happens that some things can't be recovered, then it can't be helped and people will have to learn to tolerate and understand the situation and the state of fact...
    Keep up DAMN GOOD work! I swear I would donate an organ for you guys!...or just have it taken out in a back ally...
     
  20. dio

    dio i want to see dio run Global Mod Defender of Defoko

    Messages
    25
    Likes Received
    47
    Trophy Points
    26
    I had no idea there was a Skype group chat. I personally would love to join, I think it would be pretty useful!


    Hentai really deserves a huge thank you for all the work he's put forth into salvaging what we have of utaforum right now. While we may have lost the most recent archive of posts, Hentai was able to recover everything else which is pretty fantastic.
     
  21. _caustic_

    _caustic_ Double-crossed Lunatic Supporter Defender of Defoko

    Messages
    794
    Likes Received
    832
    Trophy Points
    130
    RE:

    To brighten you day- Here is a recent discovery of mine-
    The "MyBB" logo looks like a floating fat person...reaching out for something...just take a look at the top!

    and what about old.utaforum.net? how recent is that?
     

Share This Page