Database Crash - forum downtime

[bahua]

I had about 17 IMs flashing at me when I got back from lunch. It looks like the host where this forum is hosted had a database crash, and corrupted the message data irreparably. Instead of opening a ticket and waiting for support, I took matters into my own hands and called today's data a loss. When I took control of this forum, I set up a daily process to take a full database backup and store it on my machine at home, and I'm sure glad I did. I imported the data from last night's daily backup, and it appears that we're back in business.

Unfortunately, we've lost all the entries that have been posted since 12:45am.

[LenexatoKCMO]

Cue Cher - If I could turn back time . . .

[chrizow]

HATE

[AllThingsKC]

Here's the message that I got:

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@forum.kcrag.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.


Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.


--------------------------------------------------------------------------------

Apache/1.3.37 Server at forum.kcrag.com Port 80

What I relief that I didn't cause the problem!  I was afraid that I had hit the wrong button on the keyboard, causing the forum to blow up and kill people.   8-[

[DiggityDawg]

HATE

   

I understood like, half of the technical jibbity-jab you were talking about, bahua...carry on, sir.

[LenexatoKCMO]

I can't believe that all of the incredibly wise and insightful comments I made this morning will be lost to posterity!  How will society cope? 

&&

[AllThingsKC]

I can't believe that all of the incredibly wise and insightful comments I made this morning will be lost to posterity!  How will society cope? 

&&

I know!  I was so happy when I had 1,942 posts!  Now, I'm back to just 1,940.   :lol:

[ComandanteCero]

i blame it on 'fumes.

[Tosspot]

It happened again. Everything today was lost.

[WoodDraw]

I thought I was going crazy.  Could have sworn I had made a couple of posts that disappeared.

[chrizow]

HATE

[bahua]

Big meh.

I've submitted a ticket to the host, but I've also taken matter into my own hands, and set up an hourly backup instead of the daily one that we had before. It's going to use a lot of bandwidth(~1GB per day), but those are the breaks when your host can't keep a database from corrupting itself.

[KCMax]

Sorry everyone. I just spent all afternoon deleting everyone's posts because I am an overhanded moderator who has let power go to his head! BWA-HA HA HA HA HA HA!!!

[bahua]

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@forum.kcrag.com and inform them of the time the error occurred, and anything you might have done that may have caused the error
More information about this error may be available in the server error log.


Additionally, a 500 Internal Server Error error was encountered while trying to use an ErrorDocument to handle the request.


--------------------------------------------------------------------------------

Apache/1.3.37 Server at forum.kcrag.com Port 80

This is the page that you saw when I was restoring the database. I renamed the forum directory so that nothing would attempt to be written, restored it, and then renamed it back.

[AllThingsKC]

I'm so glad that none of my wisdom-filled posts were lost, just the stupid ones I made.  


Edit: I have to go change my avatar again, too!   :x   Do you know how hard that is to do?   

[Maitre D]

Sorry everyone. I just spent all afternoon deleting everyone's posts because I am an overhanded moderator who has let power go to his head! BWA-HA HA HA HA HA HA!!!

Lame.


I guess taking 10min at lunch to research a post I had to Powercat was totally worthless, b/c the forum doesn't even work that well.  I can see once in 6 months, but this is 2x in what?  A week or two?  What's the point in posting if you're not even sure it'll be on there later in the day?


Sucks.

[bahua]

As I said, steps have been taken to ensure that a loss like this won't happen again.

Unfortunately, web fora are pretty crappy pieces of software.

[bahua]

FYI: I have uninstalled the tagging system. I suspect it had a hand in the corruption.

[ComandanteCero]

It's God's way of punishing our decadent ways.... he corrupts our forum to show us our own corruption.... Repent!

*picks up plackard and goes back to Plaza corner to continue preaching*

[KCPowercat]

I demand a refund.