mySQL server has gone away No connection.

Next topic

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. ;-)

eZ debug

Timing:	Jan 18 2025 15:17:07
Script start
Timing:	Jan 18 2025 15:17:07
Module start 'layout'
Timing:	Jan 18 2025 15:17:07
Module start 'content'
Timing:	Jan 18 2025 15:17:08
Module end 'content'
Timing:	Jan 18 2025 15:17:08
Script end

Main resources:

Total runtime	1.0163 sec
Peak memory usage	4,096.0000 KB
Database Queries	60

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0074	589.1875	152.6406
Module start 'layout'	0.0074	0.0029	741.8281	39.4766
Module start 'content'	0.0103	1.0043	781.3047	540.5000
Module end 'content'	1.0146	0.0017	1,321.8047	12.1250
Script end	1.0163		1,333.9297

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0033	0.3207	16	0.0002
Check MTime	0.0014	0.1337	16	0.0001
Mysql Total
Database connection	0.0009	0.0866	1	0.0009
Mysqli_queries	0.9610	94.5594	60	0.0160
Looping result	0.0007	0.0736	58	0.0000
Template Total	0.9735	95.8	2	0.4868
Template load	0.0020	0.1966	2	0.0010
Template processing	0.9715	95.5948	2	0.4858
Template load and register function	0.0002	0.0180	1	0.0002
states
state_id_array	0.0024	0.2357	1	0.0024
state_identifier_array	0.0021	0.2023	2	0.0010
Override
Cache load	0.0016	0.1619	26	0.0001
Sytem overhead
Fetch class attribute can translate value	0.0011	0.1128	2	0.0006
Fetch class attribute name	0.0016	0.1585	5	0.0003
XML
Image XML parsing	0.0007	0.0693	2	0.0004
class_abstraction
Instantiating content class attribute	0.0000	0.0011	5	0.0000
General
dbfile	0.0009	0.0895	16	0.0001
String conversion	0.0000	0.0008	4	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded
1	node/view/full.tpl	full/forum_topic.tpl	extension/sevenx/design/simple/override/templates/full/forum_topic.tpl
4	content/datatype/view/ezxmltext.tpl	<No override>	extension/community_design/design/suncana/templates/content/datatype/view/ezxmltext.tpl
5	content/datatype/view/ezxmltags/paragraph.tpl	<No override>	extension/ezwebin/design/ezwebin/templates/content/datatype/view/ezxmltags/paragraph.tpl
1	content/datatype/view/ezxmltags/line.tpl	<No override>	design/standard/templates/content/datatype/view/ezxmltags/line.tpl
1	content/datatype/view/ezimage.tpl	<No override>	extension/sevenx/design/simple/templates/content/datatype/view/ezimage.tpl
1	print_pagelayout.tpl	<No override>	extension/community/design/community/templates/print_pagelayout.tpl
Number of times templates used: 13 Number of unique templates used: 6

Time used to render debug report: 0.0001 secs