[Forum] MySQL server has gone away

[Mopar1973Man]

I'm randomly getting this error message. I've already called my provider and they can't seem to duplicate the problem. So is there coding issue that has occured in 4.1.2? Being that 4.1.0 worked fine for months till the update to 4.1.2...

=====================================================

Database error in vBulletin 4.1.2:

Invalid SQL:

INSERT IGNORE INTO subscribethread (userid, threadid, emailupdate, folderid, canview)

VALUES (10730, 3908, 1, 0, 1);

MySQL Error : MySQL server has gone away

Error Number : 2006

Request Date : Thursday, April 7th 2011 @ 10:42:48 AM

Error Date : Thursday, April 7th 2011 @ 10:43:54 AM

Script : http://forum.mopar1973man.com/newrep...streply&t=3908

Referrer : http://forum.mopar1973man.com/newrep...3392&noquote=1

IP Address : x.x.x.x

Username : (username)

Classname : vB_Database

MySQL Version :

=====================================================

[Jack.D]

contact your host this is not a error with vbulletin your mysql server is not working probally it is most likely down

[Trevor Hannant]

This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

Also from the MySQL site:

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

[Mopar1973Man]

This is a server issue. You'll need to contact your host about this. Here are the reasons for the MySQL server going away:

http://www.vbulletin.com/forum/showthread.php?s=&postid=310265#post310265

Also from the MySQL site:

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

That's funny the same link (2nd link) was sent to me by my provider and they are saying there server is fine you might want to contact you software (vBulletin) provider for a fix... So who is right? (Scratchin' head)

[George L]

The problem is server related and can happen for many reasons, I updated my post that Trevor linked to with more updated explanation at http://vbtechsupport.com/433/. Each forum would have a different optimal wait_timeout value and can change due to changes in traffic/loads as well. If you have control panel like whm/cpanel and these errors occur at same time each day, also look at the whm/cpanel update cronjob schedule time as it could be set to run at peak traffic times causing the momentarily error message.

[Mopar1973Man]

That's the catch I don't have any access to MySQL server or HTML server at all for configuration... So I'll give the provider a call and point the finger back there way... Thanks...

[bszopi]

The problem is server related and can happen for many reasons, I updated my post that Trevor linked to with more updated explanation at http://vbtechsupport.com/433/. Each forum would have a different optimal wait_timeout value and can change due to changes in traffic/loads as well. If you have control panel like whm/cpanel and these errors occur at same time each day, also look at the whm/cpanel update cronjob schedule time as it could be set to run at peak traffic times causing the momentarily error message.

If only I could figure out how to edit the cron jobs! I almost always get a db error at 8am, but have ignored it for so long. I bet there is a cron job running at that time.