Page 8 of 9

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 11:07 am
by bahua
Now *that* was a major database crash.

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 11:54 am
by loftguy
I got drunk, how about you?

Okay, everyone still alive out there? Let's see a show of hands.

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 12:09 pm
by AllThingsKC
I can't believe how much happened while the forum was down. 

The Royals won the World Series, the Chiefs won back-to-back Super Bowls, Funkhouser's plan for light rail was the greatest thing to hit KC, and my great grand children just graduated from college.

It's great to see you guys again.  Those that have passed ways will be missed.

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 12:12 pm
by grovester
appreciate the personal message!

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 12:38 pm
by ignatius
bahus, have you considered running the board under a vmware or xen image?  it would let you copy the entire board as an OS image and kick it back up if original crashes... handles the OS/software side, not the db of course.

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 1:02 pm
by bahua
The problems we've always had have been either database-related(which can only be mitigated with backups, which i do take), and server-related. My account is one of many on this server, and forum software is laughably unstable to begin with.

I think this forum's uptime is actually pretty impressive.

To run an OS image, I would need an entire colocated box and connection to myself, which would cost hundreds per month. So far, this site has generated about thirty dollars in ad revenue, over a period of about six years.

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 1:04 pm
by KCKev
That was the longest 1 minute upgrade I've seen in a longtime. Guess it proves there is some kind of life without the KCRAG.
I got so much done yesterday, I have nothing left to do the rest of this week  :shock:

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 1:11 pm
by bahua
I made this webpage to be the standard redirect, but this piece of shit forum software won't do any self-repairing(which took roughly 16 hours) if any files are not exactly as they're supposed to be.

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 1:15 pm
by loftguy
Bahau, a sincere thank you.

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 1:16 pm
by coreyo
bahua wrote: The problems we've always had have been either database-related(which can only be mitigated with backups, which i do take), and server-related. My account is one of many on this server, and forum software is laughably unstable to begin with.

I think this forum's uptime is actually pretty impressive.

To run an OS image, I would need an entire colocated box and connection to myself, which would cost hundreds per month. So far, this site has generated about thirty dollars in ad revenue, over a period of about six years.
It's hilarious but some enterprises still use software like this one and vBulletin to run their forums.... Seriously limits what you can do and like you said, stability issues are galore.  A lot of the clients I work with have been looking to JIVE for their next generation forums.

Re: Database Crash - forum downtime

Posted: Thu Apr 16, 2009 2:07 pm
by NDTeve
Did anyone else fear that they were going the way of MD and Chef? Guilty conscience I guess.  :D

Save the "I wish" emails... :lol:

Re: Database Crash - forum downtime

Posted: Thu Apr 23, 2009 9:52 am
by AJoD
Uh, what happened to yesterday?

Re: Database Crash - forum downtime

Posted: Thu Apr 23, 2009 9:56 am
by loftguy
AJoD wrote: Uh, what happened to yesterday?
It didn't happen.

Re: Database Crash - forum downtime

Posted: Thu Apr 23, 2009 10:06 am
by grovester
Is this an episode of "Lost"?

Re: Database Crash - forum downtime

Posted: Thu Apr 23, 2009 12:06 pm
by bahua
We had another crash and I had to restore to the backup from the previous night. I've just about had it with SMF. I'm currently investigating other forum software.

Re: Database Crash - forum downtime

Posted: Thu Apr 23, 2009 12:37 pm
by ignatius
Everything has been fine for years, or appeared to be. Are newer versions unstable?  What are you using for data store, MySQL?  Could it be that?

Check out Web Wiz Forums.  I think it might be Windows only though.

Re: Database Crash - forum downtime

Posted: Thu Apr 23, 2009 1:59 pm
by Tosspot
Weird that it didn't come back for me until just now. Browser cache I guess.

Re: Database Crash - forum downtime

Posted: Thu Apr 23, 2009 2:07 pm
by bahua
ignatius wrote: Everything has been fine for years, or appeared to be. Are newer versions unstable?  What are you using for data store, MySQL?  Could it be that?

Check out Web Wiz Forums.  I think it might be Windows only though.
It's been unstable from the get-go. Usually the problems weren't big enough to cause outages though.

Re: Database Crash - forum downtime

Posted: Tue Apr 28, 2009 8:54 am
by PumpkinStalker
Couldn't get into the forum for a bit...

Got this message:

Database Error: MySQL server has gone away
File: /home6/bahua/www/forum/Sources/Security.php
Line: 279Database Error: MySQL server has gone away
File: /home6/bahua/www/forum/Sources/Load.php
Line: 2036

Re: Database Crash - forum downtime

Posted: Thu Apr 30, 2009 10:57 pm
by AllThingsKC
I expect a full refund, and 1 year of KC Rag for FREE!

Edit: While the forum was down, I got bored.  So, I made a twitter for KC Rag so we can use it when the forum is down. - For those of us who need our daily dose of the Rag.