PDA

View Full Version : What does this mean?


AmbitiousOne
04 May 2008, 06:09
I've been averaging a lot of database errors lately, in the last month. I consistently get this message -

Database error in vBulletin :

mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11)
/home/mysite/public_html/mysite/forums/includes/class_core.php on line 274

MySQL Error :
Error Number :
Date : Wednesday, April 30th 2008 @ 08:35:19 PM
Script : http://mysite.com/misc.php?do=cybstats
Referrer : http://mysite.com/misc.php?do=cybstats
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : vB_Database


Not sure what it means, I blocked out some of the info just in case it would be bad to know my site or the ip address (person who recieved the error).

Well yea, I've been getting a lot of database error messages through email.


Here's another one. Now I'm not running any queries or anything, does the server, vb run queries on its own...because I'm getting kinda scared if someone is manually running queries and it's not me doing it.

Database error in vBulletin 3.6.9:

Invalid SQL:

SELECT *
FROM vb_session
WHERE sessionhash = 'f245e72410c445375109a5de4cae3bb4'
AND lastactivity > 1209607989
AND idhash = 'cd2b5af35d4a3cbbcf91f302da06ef9c';

MySQL Error : Lost connection to MySQL server during query
Error Number : 2013
Date : Wednesday, this date @ 08:32:57 PM
Script : mysite.com
Referrer :
IP Address : IP address xxxx.x.xx.xx.x
Username :
Classname : vB_Database

royo
04 May 2008, 06:30
You can do some reading about it here: http://dev.mysql.com/doc/refman/5.0/en/gone-away.html.
My guess is, your server is too stressed out from usage, but it could be a lot of things.

motowebmaster
04 May 2008, 16:40
vb does do many queries.

I've experienced several "mysql gone away" error situations, that ended up being linked to either improper code or something that didn't function properly after an upgrade or chance.

Print out the page that lists your installed plugins, and then start disabling/un-installing them one by one until the errors stop. Since the first error message is associated with the cybstats plugin I'd start there.

Keep disabling until the error messages stop. The culprit could be an improper configuration, or something that requires additional server configuration to properly support.

Hope this helps,

ssslippy
04 May 2008, 18:57
Cyb has some of the best/well programed plugins here. I doubt its his. Your probally on a shared server or a mis configured dedicated server.

If you are on a shared server its either overloaded or you just have way to many plugins/mods running.

If you are on a dedicated server ask for a server optimization over at vb.com

AmbitiousOne
05 May 2008, 05:06
I only have 9 mods.

My host is - bluehost.com

--------------- Added 1209964053 at 1209964053 ---------------

vb does do many queries.

I've experienced several "mysql gone away" error situations, that ended up being linked to either improper code or something that didn't function properly after an upgrade or chance.

Print out the page that lists your installed plugins, and then start disabling/un-installing them one by one until the errors stop. Since the first error message is associated with the cybstats plugin I'd start there.

Keep disabling until the error messages stop. The culprit could be an improper configuration, or something that requires additional server configuration to properly support.

Hope this helps,

Thanks, I'll look into it.

SEOvB
05 May 2008, 05:11
Chances are good that the host is experiencing problems and its out of your hands.

You can either sit there and take crappy hosting, or you can go find a hosting company that works.

Dismounted
05 May 2008, 07:14
http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway
http://www.vbulletin.com/docs/html/cantconnect

snunhuck
14 May 2008, 00:01
Use an IP address (127.0.0.1) in config.php instead of localhost if database is on same server

Paul M
14 May 2008, 00:07
The first error almost certainly means mysql was not running, so vb could not connect to it.

The second error could be a low timeout setting in mysql.