Argh...

Post by **Rollie** » Sat Feb 24, 2007 3:37 pm

So you might be able to view the forums right now, even though the site is offline.

Looks like I had a motherboard failure on the database server late last night. It has been replaced, but it also looks like in the process that some of the data files have been corrupted. I'm working on recovery and update and have taken the site offline in the meantime.

Good times... well, not really... but .. anyway...

back to work for me!

Babs · Post by **Babs** » Sat Feb 24, 2007 3:56 pm

hmm...
Got 13 realms data to submit at the moment...

hup hup... go and work on it!

Babs · Post by **Babs** » Sat Feb 24, 2007 4:01 pm

Btw:
Ding.

My murlock is now lvl 6 !

DM. · Post by **DM.** » Sat Feb 24, 2007 4:11 pm

I guess my late night trolling knocked it offline

Anyway hope you get it fixed soon! =)

Post by **Rollie** » Sat Feb 24, 2007 4:11 pm

Well, I think I'm going to be able to recover most stuff, but there will likely be some loss to character data. I am in the process of rebuilding the tables from backups and then I'll set it to reprocess quite a few of the data files.

Fun fun =)

DM. · Post by **DM.** » Sat Feb 24, 2007 4:20 pm

Polls are bugged.... http://www.warcraftrealms.com/forum/vie ... php?t=2927

NiennaMiriel · Post by **NiennaMiriel** » Sat Feb 24, 2007 7:02 pm

I guess there goes my chance to hit 100k this month.

Post by **Rollie** » Sat Feb 24, 2007 10:46 pm

Well, I think everything is back online. Please let me know if you see anything amiss with characters, guilds, histories, etc.

Post by **Rollie** » Sat Feb 24, 2007 11:30 pm

/sigh

Spoke too soon, still at it

DM. · Post by **DM.** » Sun Feb 25, 2007 1:45 am

Yea I noticed that once I read the previous post the whole site just quit loading....

And I noticed the changes made to now show the Images in our WR Profile =)
And also to show the filename of the image that you chose instead of the image number in the database.

Still waiting on the Guild Images

*edit* It actually took a about 30 seconds to make this post =( Guess not back to normal yet....

Babs · Post by **Babs** » Sun Feb 25, 2007 2:09 am

Code: Select all

Date  	New  	Updated  	Processed
Feb 25, 07 02&#58;06&#58;45 	0 	0 	N
Feb 23, 07 14&#58;53&#58;45 	0 	7 	N
Feb 23, 07 12&#58;26&#58;31 	54 	995 	N
Feb 22, 07 15&#58;18&#58;11 	76 	1205 	N
Feb 21, 07 14&#58;53&#58;41 	63 	1132 	Y

Is this ok?
Updates did get through, but didn't get processsed

DM. · Post by **DM.** » Sun Feb 25, 2007 2:20 am

Seems like Rollie rolled the updates back, the status shows it as being on Feb 22nd as of posting: http://warcraftrealms.com/dbstats.php

So while it might of been processed once, its going to get processed again. Just trying to salvage whatever was left of the corrupt files I guess....

Balgair · Post by **Balgair** » Sun Feb 25, 2007 4:27 am

I like the images in the profile bit!

Only trouble is all those ugly red X's on the characters I haven't got pictures for, suppose I need to take some more screenies

Babs · Post by **Babs** » Sun Feb 25, 2007 9:18 am

Currently I can't upload anything =\

Database error again:

Sorry, but there appears to be some sort of database error. Please try again later!

Post by **Rollie** » Sun Feb 25, 2007 12:08 pm

DM. - you didn't notice that I also added comments and captions to images? ;p

And I need to be more diligent about testing in IE. I've removed the images from the profile page for now, will revisit later.

DM. · Post by **DM.** » Sun Feb 25, 2007 12:24 pm

/gasp! You did!! yay!

DM. · Post by **DM.** » Sun Feb 25, 2007 12:28 pm

Hmm is it possible that maybe the Captions can be displayed in the Gallery section as well? That way we dont have to go to the individual picture to see the caption. But still have to go to the image if you want to see any comments made by anyone.

And you removed the images from the Profile main page..... =(
There were some issues with the tables anyways.

Post by **Rollie** » Sun Feb 25, 2007 12:31 pm

Ya, I was thinking about putting them in the gallery as well.

Nemelis · Post by **Nemelis** » Sun Mar 25, 2007 3:00 pm

Ah so is this the cause why my updates from yesterday still showed a N for being processed.

Are those updates with an N ever going to be processed, or did you have to throw them into the bit-(garbage-)bin since the files were corrupted? (Just curious).

DM. · Post by **DM.** » Sun Mar 25, 2007 3:21 pm

Rollie is most likely fixing up some of the database issues that the EU realms had with the most recent release of Census Plus and the bug with the less than 3 characters not being captured correctly.

Check the status of what file the database is currently processing here:
http://www.warcraftrealms.com/dbstats.php

As of posting its on March 24th. And no your files are still there and will be processed sometime =)