DB Crash and restore

[DirtyHarry]

Hello all.

As you may have noticed, we have had some problem with the forums and the DB today.

While we were creating a copy of the forum's DB to another DB, because of the high activity in the forums, the server crashed, corrupting the post table. We tried rebuilding it, but it seems like there was not much we could do, even though we have been trying for hours.

We had to restore a backup copy of the DB, done a few hours ago (about 8 hours from the crash). This means that posts done recently are lost. My colleague is trying to recuperate the lost posts from the corrupted DB, but I cannot guarantee its success.

We apologize sincerely to the community, as we should have foreseen this before it happened.

Please report any issues you may have in this thread.

[DAVE30]

I am having a hard time getting scf to load. All other sites are fine but SCF could be me but it has never been like this. Just letting you know.

Dave

[DirtyHarry]

Yes, I see a lot of people connecting at the same time, probably because they were trying to load the server during the timeframe in which it was not available. Google is also browsing the forums aggressively. Things should progressively go back to normal.

There was a huge jump in visitors while we were copying the DB, and it is still effecting the server.

We are investigating the issue.

[cjs-sportscards]

I know you are trying to recoup the lost posts but will you also try restoring the PM's. I am missing a bunch from today.
Thanks,
cj

[DirtyHarry]

Yes we know, the PM table was damaged as well, I am really sorry. Basically, many tables with heavy read/write operations collapsed. How many PMs did you lose?

[cjs-sportscards]

Yes we know, the PM table was damaged as well, I am really sorry. Basically, many tables with heavy read/write operations collapsed. How many PMs did you lose?

My total count says 14 but I only have 6 (3-inbox 3-sent).

[DirtyHarry]

Thanks for reporting this.

We have setup an emergency e-mail at [email protected], which will remain active throughout the upgrade to vB 3.7.0. If you spot more issues let us know at that e-mail address, so that your message will bypass other clients' issue and reach immediately the tech.

[whitesoxrock77]

i have a problem with my pm's it says i have 2 new but when i go to check them it doesent show them but it keeps flashing saying i have them.

[ensbergcollector]

not sure if they are permenantly lost but I lost 3-4 pm's today. Didn't know if you were wanting that kind of info. Not complaining or anything. Thanks for all of your work guys!! I know it is a thankless job.

[gladdyontherise]

i had this show up when i viewed my profile
Warning: Division by zero in /includes/functions.php on line 2114

Warning: Division by zero in /includes/functions.php on line 2162

also it doesnt show any person on my buddy list either, and my recent posts arent on my profile