Forums / Install & configuration / mySQL server has gone away No connection.

mySQL server has gone away No connection.

Author Message

Tony Stark

Friday 04 July 2008 8:15:41 am

Hi,

Anyone seen an intermittent problem with their installs where, in the logs, you get the following:

ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect...
Connection id: 1
Current database: *** NONE ***

or

Query error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

This is on MySQL 4.1.20

As noted, it is intermittent and when it happens you either get a small X in the AdminGUI when you try to access one of the siteaccess or on the websites themselves you get a Kernel 1, Kernel 4, or Kernel 50 error (this one tends to happen on the AdminGUI).

It seems to indicate a Database connectivitiy issue but I cnanot see why it would suddenly happen after X months of use.

Anyone seen/heard of know of a solution?

Thanks

Björn Dieding@xrow.de

Friday 04 July 2008 9:00:07 am

the mysql server is down or the path to the socket is wrong.

I would call your host....

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Tony Stark

Friday 04 July 2008 11:02:46 am

yep, they reckon it is a corrupt database/btree which they can fix with backup/restore. I will keep you posted on my results!

Tony Stark

Monday 07 July 2008 12:47:59 pm

OK,

The resolution was to drop the database, recreate and the restore. Whatever happened with the database was pretty bad and we think it was down to adding multiple locations (by clicking multiple locations at one time). It ruined a page or index in teh DB which meant it would bomb out all the time.

Anyway, drop, recreate and restore sorted it.

;-)