Severe database crash

[luck777jojo]

I'm sure you've all noticed that mpc has been down for a few days now. It was caused by a severe database crash (which was a pain to fix from my hotle room).

In either case everything is fixed now, hopefully nothing was lost in the process (nothing should have been lost in theory).

[Skyline_R34]

Glad to know everything is back up and running. On IRC VF told us it would be a week until it's back up. I'm so happy he was wrong :P

[barry_white]

Thx again for the hard work from the hotel room luck. ;)

[gil]

Thanks for the best Tech Admin ever.
You're the man luck. Your hard work is appreciated, at least here.

But we all know it's a temporary solution until... next time.
I hope we can find a permanent solution soon.


Thanks again.
Enjoy the rest of your trip :ermm:

[Virtuosofriend]

One hell of a job.

[Sudden Death]

^^
Is it being crashed by someone, or is it just going down?

[gil]

^^
Is it being crashed by someone, or is it just going down?
Server issues.
Not related to anyone.

[shoot]

Glad to see you're back up man. I can imagine the hell it must have been to fix.

[Diddle]

Great job luck, thanks a lot! :D

[noob-cheater]

Where would we be without luck :cheeky:

awsome job man!!

[scruie]

woot...luck is on our side ;)


great work.






(bad pun but i had to....)

[Skyline_R34]

Now I'm gonna have to stop those "MPC is down, blame it on luck" jokes :P. Nice job luck. I have a hard time trying to make my teeny forum work properly, I can't imagine the work it takes to run this place

[3y3w4nn4ch34t]

WooHoo I didnt lose any posts, so you did something right :classic:

Have fun :knockedou

[No1uKnow]

nice job luck, thanks

[h4x0r2damh4x0r]

But we all know it's a temporary solution until... next time.
I hope we can find a permanent solution soon.

Yeah , We can't always be dependent on Luck. anyway GJ luck.

[Ping_pong]

Thnx Luck, for solving the issue that quick :)

[gil]

I think he's still sleeping (or pissed) :x

[GuNnEr-UK]

Thx for the fix jojo :), and and thanks for the update.

[Dark Blaze]

Indeed permanent solutions would always be welcome. Well done luck, thanks again :)

[st3ph3nt4n]

glad the servers are back up .. great job luck!

[luck777jojo]

I think he's still sleeping (or pissed)

well I was sorta in the middle of my plane trip back, finally home again now, gonna get some sleep and ba back as usual tomorrow (maybe even more since my last exam is on the 16th and I get a few days break now after that trip ;))

Server issues.
Not related to anyone.

actually this time I can't even blam it on the server O.O :P it was some random (as far as I know) corruption in a few mysql tables, that was probably some people were having problems posting a few days ago and then the huge database error. I just had to clean up those tables manually by hand (luckily it wasn't one of the huge tables such as posts) and that seemed to fix the problems, then did (a tiny littly bit) of optimization of the mysql settings and that didn't seem to kill the server either so....... hopefully things will be a bit better now.

[scruie]

gotta say it again luck, nice work. everything does seem a tad quicker for me at least.

[Dark Blaze]

I have to agree with scruie luck, whatever you did to fix it also made it a lot faster for me as well :)

[gil]

Forums are a lot faster here as well.
Maybe we lost a lot of people that still think that the site is down :x

[luck777jojo]

530 people online now total, server still seems to be running fast enough hopefully those mysql optimizations were a good idea

[shockwtF]

Hey, this is shock. It seems as if my account has dissapeared ;o

I am not sure if it has anything to do with the crash but I tried my password 4 times, didn't work, tried to reset it and it didn't work (said my account doesn't exist) so I tried to email the administrators with the problem and this reply (for all emails) :

This is an automatically generated Delivery Status Notification

Delivery to the following recipient failed permanently:

WebMaster@MPCForum.com

Technical details of permanent failure:
PERM_FAILURE: SMTP Error (state 9): 550 <WebMaster@MPCForum.com>: Recipient address rejected: User unknown in virtual alias table


BTW my account was registered under this email address, I have absolutely no idea what happened. I have been using it fine the past couple of weeks, wondering what happened...

thx
-shock

[Diddle]

At the time of the upgrade of vBulletin there were over 70k inactive accounts deleted. It's most likely yours was one of those.

[luck777jojo]

Hey, this is shock. It seems as if my account has dissapeared ;o

I am not sure if it has anything to do with the crash but I tried my password 4 times, didn't work, tried to reset it and it didn't work (said my account doesn't exist) so I tried to email the administrators with the problem and this reply (for all emails) :

This is an automatically generated Delivery Status Notification

Delivery to the following recipient failed permanently:

WebMaster@MPCForum.com

Technical details of permanent failure:
PERM_FAILURE: SMTP Error (state 9): 550 <WebMaster@MPCForum.com>: Recipient address rejected: User unknown in virtual alias table


BTW my account was registered under this email address, I have absolutely no idea what happened. I have been using it fine the past couple of weeks, wondering what happened...

thx
-shock

what was your account name?
webmaster@mpcforum.com doesn't exist therefore the error.

[o({})o]

Right after wooolF left the forums, something just like this happened. I don't remember what was wrong, or if I ever found out what caused the problem to occur... I think it was someone's name actually.... I had to change their name and alter all the posts they made manually in the database to fix the problem since vBB couldn't fix it by itself. I don't think this has anything to do with that, but keep on the lookout for any threads breaking because of funny names, because that is how it started that time before.

[gil]

I don't remember any broken threads. But i'll keep an eye on that.

One weird thing is if you check the Members list, the first name starts with 'E'.
That's because he has a 'space' before the name starts.
But it's been like that for a while now.

[snowcatxx87]

Thought it was just me, few!

[Dark Blaze]

Hopefully it won't reoccur in the near future...

[moka989]

hotle room? hotel :) spelling error!

[luck777jojo]

what do you expect I was pissed, it was late, I was on my laptop and I just spent 2 hours fixing the database, be glad it's readable at all :P

[rought]

good job man...