Database problems - 10/07/2010

Today pretty much sucked. Getting more database errors and for a while the site was completely dead. Rebooting the server took about two and a half hours to recover from. And I don't have any warm fuzzy feeling at all that the cause of the problems have been fixed at all.

If I get even a hint of database problems showing up, I'm going to lock this site to keep people from getting frustrated when a backup file has to be reloaded again and losing everying from the past 24 hours. The site will just have to stay closed until the server management people can FIX this problem instead of just putting a temporary patch over the symptoms.

I just got finished running an internal repair and optimize routine on the database on recommendation from my server admin people. Hopefully this will help, but I will still close down the site at the hint of any further database problems. When that happens you should see a notice displayed about what is going on when you try to visit the site.

Good luck getting this sorted out!

I just got another database error... it was down for about 5 mins this time before coming back. I was in my PM's when it happend.

Yeah, I'm sure we aren't out of the woods yet. As far as I know, the server guys never really found a smoking gun for the failures, so more are likely. Therefore I asked them to set it up so backups of the database are being done hourly. This may slow things down when the backups are taking place, but at least nothing more than an hour old when a failure takes place is likely to get lost.

thanks Rich on the hourly. When it went down this last time.. I thought we were gonna have to out someone all over again.

I Just got a bunch of data base errors before the site would finally load. If your already aware it is still happening then I apoligize.

I just received this Database error in the BHB bad guy thread clicking on page 13 from page 12. http://www.faunaclassifieds.com/foru...211323&page=13

Maybe I copied the wrong url but it was like the previous problems.

i received some database problems after clicking on "Mythical Dragonz" "ads" button. (dont have a screen shot as it happened last night and forgot to get some)

Yeah, I got a couple myself over the last several days. Appears to be random, as it was never the same place, time, nor function twice.

When I see a slow spell with a low number of members logged on, I'll try to remember to run some cleanup routines on the database. I'm still doing nightly backups, though, just in case.