View Full Version : MYSQL servers down? Please POST here.
HalfaBee
2-13-04, 07:51 PM
If you have MYSQL server problems please post here.
Updates will be forthcoming.
HalfaBee
As of this moment the infamous mysql05 is down on my site. It's been up and down since yesterday (when I understand they were working on the problem). Even when it's up it's been very very sluggish (taking 8 to 10 seconds to load a page on my forums).
Well since no one else was complaining of a mysql05 outage I figured this one must be on my end only and it was. Turns out my database was corrupt and after trying a few different repair functions I got my forums back up.
Here's where I want to make a little complaint....I just installed my website's vbulletin discussion board about 3 weeks ago (on unreliable mysql05 it turns out). Not only am I dealing with a totally foreign software package for the forums and struggling to learn how it works, I've got outages of mysql05 to deal with. I've learned the hard way that when your mysql goes in fits and starts that the stoppages can cause corruptions to your database. This is the SECOND time I've had to repair a corrupt database caused no doubt by the failure of mysql05.
I just want to repeat that it's very difficult when you're trying to set up a forum and dealing with all kinds of issues to suddenly have to learn how to repair a corrupt database because your server is not performing with any degree of reliability.
There. I had my say.
Hey halfabee.... What ever happened to your signature image that showed the status of mysql servers? Guess it would have been a while ago when you had it, but it was kinda handy to reference. Remeber the one I'm talking about?
mysql05.powweb.com is DOWN AGAIN! This is ANNOYING!
Im workin on my site. Adding a really critical section to it and now i cannot test anything im doing.
If i go to phpmyadmin.powweb.com and than select mysql05.powweb.com it says "#2003 - Can't connect to MySQL server on 'mysql05.powweb.com' (61)"
So thats how i know it isnt a client side thing.
This is ANNOYING!
LOL now its up again... what the heck is up with this 05
YAY! They moved mysql to a new machine, should not be having problems anymore! thanks powweb!
They moved it to a new machine, should be no more troubles now!
That's great that they moved it to a new machine! I'm pleased to hear that!
I wonder if I should run a repair on my forums since anytime msql is taken down and restarted it corrupts my files. Guess it wouldn't hurt.
is the Mysql04 server down? i get the 500 internal server error on both of my websites =\
fmgt1999
2-15-04, 07:55 PM
Nevermind, I'm working now... Thanks Halfabee :D
tbonekkt
2-15-04, 07:57 PM
Did you two check permissions?
alphadesk
2-15-04, 07:59 PM
KyleReason is I found thunderbirds don't some back out of the snow on there own.This one is working fine ... ?
And I'm in phpmyadmin now on mysql04 ... no problem.
permissions on my servers are fine.....or so they were. I've left them untouched since the day i got them working ok.
HalfaBee
2-15-04, 08:02 PM
It is not a mysql problem.
If your domain has a hyphen ( - ) in it , it will be having a few problems until a slight apache problem is fixed.
If you put the actual file you are trying access in will probably work.
eg
www.my-site.com/index.php
Originally posted by HalfaBee
It is not a mysql problem.
If your domain has a hyphen ( - ) in it , it will be having a few problems until a slight apache problem is fixed.
If you put the actual file you are trying access in will probably work.
eg
www.my-site.com/index.php
not mine;
www.xhammertime.com/forum/
www.gr8dbznet.com/forum/
alphadesk
2-15-04, 08:09 PM
Hammer
Sure they will ... as halfabee said it's not mysql problem.
The admins are aware and will get this fixed soon.
http://www.xhammertime.com/forum/index.php
http://www.gr8dbznet.com/forum/index.php
oh err thanks
i can litterly feel someone knocking on my head sayin "hello McFly! Anybody home?!"
HalfaBee
2-15-04, 08:15 PM
Hammer,
I have reported your problem as well.
Funny thing is, my domain has a - in it but the main index.html page is fine.
It is just the forums that are not working.
Wiz
Typing in index.php works.
Wiz
I'm having the same problem...
http://musicnw.net/bands/13/
didn't touch a thing.
We are also having the same problems...
www.splbassx.com/forums/
Any idea when this will be fixed?
heavymetalcoil
2-15-04, 09:00 PM
Get around it :
http://forum.powweb.com/showthread.php?s=&threadid=33099
Posted a fix there .
HalfaBee
2-15-04, 09:06 PM
It is being worked on while you type.
Shouldn't be too long.
heavymetalcoil
2-15-04, 09:09 PM
You See me getting frustrated ? .
As I Said technical problems are here to stay , Nobody is Tech Problems free , You Can only invest in fixing the problem quickly , No-one can prevent Technical Problems .
Pitty you havent posted a Msg on the Outage Forum and i have to Press the Refresh on Forums posting the Fix .
We are back as of this morning with no problems....
Fatal error: Call to undefined function: themeheader() in /www/n/netepic/htdocs/INCOMING/html/header.php on line 47
I keep getting this error - is the MySQL server still down, or has my themes folder got corrupted when MySQL05 was taken offline? Is anyone familiar with phpNuke errors?
heavymetalcoil
2-17-04, 12:59 PM
My Advice , Go see what the header file does on that line .
If It Selects something from the database i'd advice you to run REPAIR TABLE command using the phpmyadmin .
After the Restore of MySQL05 I Had some Tables corrupted mostly because during the time the server went down and up the forum users tried to write to the database causing Tables to have blank lines and such .
Just Checkout the Error and what it does , Repairing is an Easy Task and takes a sec todo even for a MySQL Novice .
I keep getting this error when ever I try anything.
DB Error, could not list tables MySQL Error: User 'netepic' has exceeded the 'max_questions' resource (current value: 72000)
What is this max_questions resource? I run a PHP_Nuke site, so our MySQL usage is fairly extensive but not as bad someone with a forum....
tbonekkt
2-17-04, 01:17 PM
We're allowed 72,000 queries/user per hour. It'll reset within an hour. In the meantime, you can implement the rotating users script floating around to triple your limits.
The problem is still occuring five a bit hours later, any idea where I can find this script?
HalfaBee
2-17-04, 05:10 PM
Have a look in the STICKY thread at the top, it has a link to peoples solutions.
Cheers! Applied the fix and all is working fine now :)
vBulletin v3.6.0, Copyright ©2000-2009, Jelsoft Enterprises Ltd.