 |
|
|
Thread Tools |
|
#1
15 May 2008, 15:15
|
|||
|
|||
|
MySQL Error : MySQL server has gone away
I moved to a dedicated server and have been getting TONES of these. Another weird thing is if you login sometimes it says not logged in but if you click a sub cat it shows you logged in. Or if you click to go to the main forum it logs you out but you're not logged out.
Getting ~50 errors a day +. Please help! Database error in vBulletin 3.6.4: Invalid SQL: UPDATE session SET lastactivity = 1210815504, location = '/forum/forumdisplay.php?f=6', inforum = 6, inthread = 0, incalendar = 0, badlocation = 0 WHERE sessionhash = 'b2566c7eae44bfcf85f26341d25c14ba'; MySQL Error : MySQL server has gone away Error Number : 2006 Date : Wednesday, May 14th 2008 @ 08:38:57 PM Script : http://www.bloggeries.com/forum/forumdisplay.php?f=6 Referrer : http://www.bloggeries.com/forum/ No members have liked this post.
|
|
#2
15 May 2008, 15:21
|
||||
|
||||
|
Contact your host as it looks like MySQL is being reset or rebooted.
No members have liked this post.
|
|
#3
15 May 2008, 15:50
|
|||
|
|||
|
More likely is that the timeout for MySQL is set too low.
See this post for the possible causes of a lost connection error: http://www.vbulletin.com/forum/showt...265#post310265
__________________
Marco van Herwaarden Ex vBulletin.org Coordinator No members have liked this post.
|
|
#4
15 May 2008, 16:19
|
||||
|
||||
|
That is most likely what is going on. I was just going by what happened to me on my old host.
No members have liked this post.
|
|
#5
15 May 2008, 17:30
|
|||
|
|||
|
I've been discussing this with the host.
Not sure about rebooting or reset; it is on a dedicated server so I don' tknow. Regarding Timeouts I received this from the host. I've increased the time outs on your MySQL configuration from 20 to 60... this should help. Any other thoughts? Cheers, No members have liked this post.
Last edited by Bloggeries : 15 May 2008 at 20:02. Reason: Auto-Merged DoublePost
|
|
#6
15 May 2008, 21:24
|
||||
|
||||
|
Originally Posted by Bloggeries
20 is very low, that was probably it. You might need to increase it a bit more than you did to completely eliminate the problem. 90 works for me.
No members have liked this post.
|
|
#7
18 May 2008, 16:26
|
||||
|
||||
|
Post a server optimization request on www.vbulletin.com/forum/ and implement the MYSQL settings recommended there, I am sure it would fix the issue.
No members have liked this post.
|
|
«
Previous Thread
|
Next Thread
»
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
| Thread Tools | |
|
|
| New To Site? | Need Help? |
All times are GMT. The time now is 00:46.