PDA

View Full Version : Did they implement new mySQL connections?


LongIslandJam
8-7-04, 10:23 AM
This past week was the first week of getting errors of the following:

Database error in vBulletin :

Link-ID == false, connect failed
mysql error:

mysql error number: 0

Date: Friday 06th of August 2004 07:10:32 PM
Script: http://www.racerhub.com/forum/showthread.php?t=4242
Referer: http://www.racerhub.com/forum/forumdisplay.php?f=14
IP Address: 162.84.135.88


Before this week, I've never gotten this error and traffic has been lighter this week... What's up?

Pig
8-7-04, 04:15 PM
Probably someone on your server running bad queries. Resource abusers are typically caught quickly.

LongIslandJam
8-7-04, 07:42 PM
What's a bad query. Educate me please in case some others are wondering, because its occuring a lot at times and we never had this trouble before and we are garnering the same amount of traffic as usual.

Thanks. :)

Pig
8-7-04, 09:06 PM
When someone requests data from the sql server, it is supposed to be well formed. it is possible to write a query that returns too many results, or possibly confuses the server. since the servers are shared, other's actions affect you, even though you did nothing.

LongIslandJam
8-7-04, 10:59 PM
Ahh so its possible that someone else on the server is causing me to get these errors?

Pig
8-7-04, 11:09 PM
Correct.

LongIslandJam
8-8-04, 05:54 PM
So when is PowWeb going to fix this. My database is on space.powweb.com . I'm getting a few dozen of these every day. Anybody else getting errors on that server?

LongIslandJam
8-9-04, 02:30 PM
77 error messages in the last minute!

WhiteKnight
8-9-04, 05:08 PM
I'm having the same problem. I'm getting about the same amount of database errors each day from my vbulletin board. In addition, I can't do backups or re-indexing without getting a 500 internal error. Could these issues be related? If so, what can be done to fix them?