Server Downtime - 2012-08-08 |
||
|
Server Downtime - 2012-08-08
Database locked up around 5AM central time. It started the backup process and it never was able to complete it and I don't know why. I couldn't gracefully shut it down so I had to kill dash nine it. Looks like a database table has gone missing and I will be pulling it from backup. As a result some pages might not load. I will keep you informed.
Quetzalcoatl.Moonsshadow
Offline
Oh, good, I thought it was me putting too many animated gifs in the lol thread. (>.<)
Me getting "Application error" when try to view someone's page is temporary or unrelated?
Odin.Godofgods
Offline
Fenrir.Scragg said: » Database locked up around 5AM central time. It started the backup process and it never was able to complete it and I don't know why. I couldn't gracefully shut it down so I had to kill dash nine it. Looks like a database table has gone missing and I will be pulling it from backup. As a result some pages might not load. I will keep you informed. wish i had knowledge to understand what you just said for the most part.. lol Odin.Godofgods said: » Fenrir.Scragg said: » Database locked up around 5AM central time. It started the backup process and it never was able to complete it and I don't know why. I couldn't gracefully shut it down so I had to kill dash nine it. Looks like a database table has gone missing and I will be pulling it from backup. As a result some pages might not load. I will keep you informed. wish i had knowledge to understand what you just said for the most part.. lol stuff got stuck. Commander Scragg got it unstuck. Phoenix.Professoroak said: » Me getting "Application error" when try to view someone's page is temporary or unrelated? I'm having the same problem. It may or may not be related but I couldn't search for any items sporatically yesterday/see item sets. Maybe a data error? I don't know I am not good with computer etc etc
The one day i wake up before 1pm, it was horrible.
I've noticed the site has been acting screwy or messing up in very different areas lately lol.
Feels like I have problems with the AH almost anytime I'm on around 5~7am EST. Pages always load slow or the connection times out. Been this way for as long as I can remember. And it's only FFXIAH that does it, anywhere else is just fine and dandy, so I don't believe anything is wrong on my side.
Idk if this has any relevance to this happening, but I thought I'd share. kill -9... ouchie :x
I havn't had LS community auto-update in a few weeks
then again they suck. Odin.Hirokei said: » Feels like I have problems with the AH almost anytime I'm on around 5~7am EST. Pages always load slow or the connection times out. Been this way for as long as I can remember. And it's only FFXIAH that does it, anywhere else is just fine and dandy, so I don't believe anything is wrong on my side. Idk if this has any relevance to this happening, but I thought I'd share. That's around the time of back up. It's normal. Scragg, not sure if anyone has told you this, but you're doing Altana's work.
Thanks, I restored the missing table and as far as I know there was just one missing.
The DB size (not counting sales) is around 50GB. Dumping the data while maintaining data integrity requires locking tables, which makes users on the website wait until the operation is done. This also includes compression and transfer. I'm going to suspend the daily backups until I find a better solution. Carbuncle.Elvaanmoq said: » kill -9... ouchie :x Can you fix the giant list of 99 empyreans too? :(
I feel obligated to do this:
NSFW: http://graphics.stanford.edu/~monzy/KillDashNine.mp3 Ick :| yeah the site has been screwy for the past few days, locking up and not loading at all at times!
Hopefully you can get it all back up and running good~ Lakshmi.Byrth said: » I feel obligated to do this: NSFW: http://graphics.stanford.edu/~monzy/KillDashNine.mp3 You doing incremental database backups? Or full backup?
Incremental might take longer recovery times, but should be far less intensive backing up. And, I don't know why I'm suggesting anything, at this point you probably know way more about server admin than I do. Lakshmi.Byrth said: » I feel obligated to do this: NSFW: http://graphics.stanford.edu/~monzy/KillDashNine.mp3 Wooooooow, I feel nerdy for understanding it lol. "Application error" is back when trying to view someone's page, at least for me.
I am getting the same error when looking at someone's page as well
Ragnarok.Ashman said: » I am not good with computer etc etc Glad to see you have us back up and running Scragg. Thank you very much Scragg for keeping us informed.
Told me my password was wrong and wouldn't let me log in for about 20 minutes before, assuming that was due to issues mentioned here and its gonna work now? (I'm clearly logged in now)
anything us users could do to help lighten the load of the backup?
or feature you could change, that we may not need, etc kill. dash. nine. edit: totally beat by byrth oh well! Ramuh.Yarly said: » kill. dash. nine. edit: totally beat by byrth oh well! I had no idea what kill dash nine is but this video is great. |
|
All FFXI content and images © 2002-2024 SQUARE ENIX CO., LTD. FINAL
FANTASY is a registered trademark of Square Enix Co., Ltd.
|