Server has gone away

[JulianD]

Well.. i'm sure it's a server related problem, but you guys might know something about...


I'm running vb 2.2.4 on a shared server and today I got a mysql error saying Server has gone away...


The error it's not very common, and if you reload all comes back to normality.


But i'm just curious about that.. do you know what might be causing the error?

[nuno]

is your hard drive full?

[JulianD]

I just checked the stats, and no, there are plenty of space on the server.

[nuno]

well, that's the only thing i can think of :rolleyes:
one more thing, you should restore Jelsoft copyright notice, that goes in footer template :)

[JulianD]

Uhmm sorry about that.... One question, i use vbportal, should the copyright notices also go in the vbportal pages? or just on the forums?

[nuno]

only the forums :)

[JulianD]

Alright nuno... done :)

[nuno]

gr8 Julian ;)
about that error, what kinda error is reported?

[JulianD]

Here's the complete error:

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT eventid, subject, event, eventdate, public
FROM calendar_events
WHERE eventdate
LIKE '%-03-24' AND ((userid = '1' AND public = 0) OR (public = 1)) mysql error: MySQL server has gone away

mysql error number: 2006

In this case, the error eas produced with vbportal, but the first time I got the error, it was on the forums...

[nuno]

does vbportal require calendar.php file code hacking?

[JulianD]

No, calendar.php is not hacked by vbportal.

[nuno]

ok
around line 89 calendar.php you should see this:

// Load the events for the month!
$events=$DB_site->query("SELECT eventid, subject, eventdate, public
FROM calendar_events
WHERE eventdate
LIKE '$year-$doublemonth-%' AND ((userid = '$bbuserinfo[userid]' AND public = 0) OR (public = 1))");
// Figure out how many days are in this month

[JulianD]

I will keep an eye on it.

[Dave#]

Originally posted by JulianD
Here's the complete error:

Database error in vBulletin 2.2.4:

Invalid SQL: SELECT eventid, subject, event, eventdate, public
FROM calendar_events
WHERE eventdate
LIKE '%-03-24' AND ((userid = '1' AND public = 0) OR (public = 1)) mysql error: MySQL server has gone away

mysql error number: 2006

In this case, the error eas produced with vbportal, but the first time I got the error, it was on the forums...

looks like youe server was maxed out and mysql couldn't complete the transaction

[JulianD]

Well, today I received another error... This time it wasn't 'Server has gone away'... but here's the error:

Link-ID == false, connect failed
mysql error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

mysql error number: 2002


So far, I have received 3 errors of mysql. The odd thing, is that all the errors were produced at o'clock hours.... See:

First error: Wednesday 20th of March 2002 12:00:07 AM
Second: Sunday 24th of March 2002 06:00:09 PM
Third: Tuesday 26th of March 2002 12:00:07 AM


You see? It seems like my mysql server is killing all the connections on this hours... 6PM and 12AM... I really don't think it's a coincidence... what do you think?

[Dave#]

Originally posted by JulianD
Well, today I received another error... This time it wasn't 'Server has gone away'... but here's the error:




So far, I have received 3 errors of mysql. The odd thing, is that all the errors were produced at o'clock hours.... See:

First error: Wednesday 20th of March 2002 12:00:07 AM
Second: Sunday 24th of March 2002 06:00:09 PM
Third: Tuesday 26th of March 2002 12:00:07 AM


You see? It seems like my mysql server is killing all the connections on this hours... 6PM and 12AM... I really don't think it's a coincidence... what do you think?

Does your server run logfile analysis or anything similar at that time?

[JulianD]

Well, I really don't know.. Maybe that's the problem. I will ask to my server admin. Thanks for all the help guys :)

[Steve Machol]

Yep, it looks like your host is restarting MySQL on a regular basis.