Page 1 of 2

Database server is having problems

PostPosted: Fri Feb 23, 2007 9:41 am
by Seibertron
Sorry for the delay in relaying this information to you guys. HMW will most likely be down for the next 72 hours until this problem is resolved. I need to make a backup of the entire site's database first before I will authorize this hardware change and server restore.

The Trouble Ticket you entered into Server Command of EV1Servers.net has been modified. The following notes have been made to your ticket.
------------------------
Description of the Resolution:


2/22/2007 5:25:08 PM
DataCenter
Ryan Yzquierdo

It appears that sda is going bad, and will need to be replaced. Since this is a hardware failure you will need a restore and the restore, obviously will be of no charge to you. All we need is the go ahead to bring your server down for this maintenance or a good date and time thats convenient for you. Your server only holds two drives so we can remove your sdb drive temporarily to slave the old master to the new master drive for data recovery. Please let us know how you would like to proceed. Thank you.

Aaron R
Datacenter Server Technician
Houston Datacenter 2
The Planet

PostPosted: Fri Feb 23, 2007 9:43 am
by Psychout
Well, i call that weekend off. Wonder what outside looks like...

Cheers for the heads-up Siebs.

PostPosted: Fri Feb 23, 2007 9:48 am
by Supercollider
Psychout wrote:Well, i call that weekend off. Wonder what outside looks like...

Cheers for the heads-up Siebs.


Dalmascia for me as Final Fantasy XII arrived today!

PostPosted: Fri Feb 23, 2007 9:57 am
by Archanubis
Looks like Silkroad and finishing my Gripen model is my weekend.

PostPosted: Fri Feb 23, 2007 9:58 am
by QuietStorm
Perfect timing, I've got to move out this weekend. Nothing to distract me from that....except Gears of War and Dethklok.

Sweet. Big ups on the "official" word, settles everything a bit.

Word.

PostPosted: Fri Feb 23, 2007 10:19 am
by Hull
I guess I'll go do something with my wife...

PostPosted: Fri Feb 23, 2007 10:23 am
by Phasewing
Loverly... ._.

*Deciding whether or not to instantly drop dead asleep right now for the next 7 - 14 hours, having stayed up all night in hopes HMW would come back on.* :lol:

Oh well, thanks for the details, Ryan. :)

PostPosted: Fri Feb 23, 2007 10:26 am
by Tifereth
Thanks for the info

72 hours without hmw, i wonder how is the world outside :oops: , i think ill finish Black ;)

PostPosted: Fri Feb 23, 2007 10:27 am
by Tristar
(wait a tick I'm actaully posting!) Just greet and I was hopping to work on my team.

PostPosted: Fri Feb 23, 2007 11:18 am
by Mkall
Thanks for the update Seibs.

PostPosted: Fri Feb 23, 2007 12:20 pm
by Bun-Bun
Well now we know....

*sigh
Well that sucks, but nothing much to be done about it.

everyone meet back here in 72 hours and we'll try again.

PostPosted: Fri Feb 23, 2007 12:27 pm
by -Soundwave-
Hmmmm Alright Thanks for the update!

PostPosted: Fri Feb 23, 2007 12:29 pm
by Subsonika
Thanks, Seibs..

Off to the pub I go then :wink:

PostPosted: Fri Feb 23, 2007 1:17 pm
by God Magnus
And just when I was starting to get back into it.

PostPosted: Fri Feb 23, 2007 1:28 pm
by chrisjbrandon
Mkall wrote:Thanks for the update Seibs.

I agree. No worries... :grin:

PostPosted: Fri Feb 23, 2007 1:42 pm
by ShockwaveUK
Did they find midgets tampering with the server?

PostPosted: Fri Feb 23, 2007 1:43 pm
by Redimus
Goddamnit.... 2 days off, and 2 days with only short shifts that leave me with plenty of HMW time, and the game goes down....

This seems to happen EVERY time i get a chance for some good playage.

And with this in mind I apologise in advance for the down time HMW will suffer on the last full week of april, the second week of may, and sometime in the middle of june...

PostPosted: Fri Feb 23, 2007 5:22 pm
by Seibertron
I added this to the news section after changing the initial text.

"Sorry for the delay in relaying this information to you guys. The site is currently running off a backup server right now. HMW will be down for the next 72 hours until this problem is resolved. Apparently the database server had a bad scuzzy drive which has been causing the problems with the bad database tables, according to ThePlanet (the company which hosts Seibertron.com's servers). This would explain why I wasn't able to create proper backups of the Forums, Demiurgic City and Heavy Metal War. Hopefully once this issue is resolved, everything will be back to normal. I apologize for any inconvenience this has caused any of you."

PostPosted: Fri Feb 23, 2007 5:25 pm
by ShockwaveUK
Seibertron wrote:I added this to the news section after changing the initial text.

"Sorry for the delay in relaying this information to you guys. The site is currently running off a backup server right now. HMW will be down for the next 72 hours until this problem is resolved. Apparently the database server had a bad scuzzy drive which has been causing the problems with the bad database tables, according to ThePlanet (the company which hosts Seibertron.com's servers). This would explain why I wasn't able to create proper backups of the Forums, Demiurgic City and Heavy Metal War. Hopefully once this issue is resolved, everything will be back to normal. I apologize for any inconvenience this has caused any of you."


So we'll have lost HMW data?

PostPosted: Fri Feb 23, 2007 5:26 pm
by Seibertron
I was glad to see this was a server problem and not a coding problem. The site's been doing about double the traffic that it was doing back in October and November. Instead of doing 150,000 pageviews per day, the site is doing about 250,000 to 300,000 pageviews per day. I think the day after Toy Fair the site did about 379,000 pageviews. It's been pretty crazy server wise the past few weeks.

PostPosted: Fri Feb 23, 2007 5:29 pm
by decepticonjon
dethklok dethklok
yea, guess i need to find something to do this weekend.
hah.
thanks for the heads up.

PostPosted: Fri Feb 23, 2007 5:29 pm
by Seibertron
shockwaveuk wrote:
Seibertron wrote:I added this to the news section after changing the initial text.

"Sorry for the delay in relaying this information to you guys. The site is currently running off a backup server right now. HMW will be down for the next 72 hours until this problem is resolved. Apparently the database server had a bad scuzzy drive which has been causing the problems with the bad database tables, according to ThePlanet (the company which hosts Seibertron.com's servers). This would explain why I wasn't able to create proper backups of the Forums, Demiurgic City and Heavy Metal War. Hopefully once this issue is resolved, everything will be back to normal. I apologize for any inconvenience this has caused any of you."


So we'll have lost HMW data?


I updated my statement above. I meant to say "during the past few months" to the part you bolded. The only think that looks like had become corrupted this time were the private messages for some reason. I haven't had a chance to look at mine yet.

PostPosted: Fri Feb 23, 2007 5:30 pm
by ShGarland_1383
Is this effecting how many of my posts turn up when I click the "view posts" page? There should be 7 pages of them when I do and I get a "No topics or posts met your search criteria" for all but the first page instead.

edit: to be clear about it I'm getting posts for what would be the first page (which would be the most recent) it's the other 6 I'm having the no topics or posts message.

PostPosted: Fri Feb 23, 2007 5:31 pm
by ShockwaveUK
Seibertron wrote:
shockwaveuk wrote:
Seibertron wrote:I added this to the news section after changing the initial text.

"Sorry for the delay in relaying this information to you guys. The site is currently running off a backup server right now. HMW will be down for the next 72 hours until this problem is resolved. Apparently the database server had a bad scuzzy drive which has been causing the problems with the bad database tables, according to ThePlanet (the company which hosts Seibertron.com's servers). This would explain why I wasn't able to create proper backups of the Forums, Demiurgic City and Heavy Metal War. Hopefully once this issue is resolved, everything will be back to normal. I apologize for any inconvenience this has caused any of you."


So we'll have lost HMW data?


I updated my statement above. I meant to say "during the past few months" to the part you bolded. The only think that looks like had become corrupted this time were the private messages for some reason. I haven't had a chance to look at mine yet.


So all HMW data is still good?

PostPosted: Fri Feb 23, 2007 5:31 pm
by Seibertron
Yep, it appears that a lot of the private messages were lost. I'm going to leave the private message topics in the database that don't have corresponding text so that you guys can at least contact the people that you need to get a hold of. I'll clear out the bad private message topics at a later date (maybe a month or so down the road).