MySQL server has gone away (event log)

Read 5581 times
Hey guys,

I´m using suphp, debian 6, standard debian packages. cronjob centova ok, and using daemon mode.

My Mysql Finetune:

max_connections=50
query_cache_type=1
query_cache_limit=8M
query_cache_size=32M
interactive_timeout=100
wait_timeout=15
connect_timeout=10
table_cache=512
thread_cache=32
key_buffer=256M
thread_concurrency=2


This error appers randomically on restart icecast services.
===============================================================================
Error: Could not execute query
File: /home/centovacast/system/class_EventLog.php:0
Query: INSERT INTO eventlog (`accountid`,`summary`,`details`,`caller`,`eventdate`) VALUES ('3','Servidor parado','','pid:30711-cli:/home/centovacast/system/runascc/../ccmanage.php daemon a1rj restart --nopasswordprompt\n',NOW())
Reason: MySQL server has gone away
Call: $sql->insert_query()
===============================================================================
===============================================================================
Error: Could not execute query
File: /home/centovacast/system/class_AccountControl.php:0
Query: UPDATE accounts SET expectedstate='up',expectedsourcestate='up',outagenotified=0 WHERE username='a1rj'
Reason: MySQL server has gone away
Call: $sql->misc_query()
=================================================================
=================================================================
Error: Could not execute query
File: /home/centovacast/system/class_EventLog.php:0
Query: INSERT INTO eventlog (`accountid`,`summary`,`details`,`caller`,`eventdate`) VALUES ('3','Servidor iniciado com sucesso','','pid:30711-cli:/home/centovacast/system/runascc/../ccmanage.php daemon a1rj restart --nopasswordprompt\n',NOW())
Reason: MySQL server has gone away
Call: $sql->insert_query()
=================================================================

Same Thing:
http://topwebhostingoffers.com/minor-centovacast-server-error-fix/
http://www.webhostingtalk.com/showthread.php?t=1014109

Any sugestions?
Regards.
Already answered this in your helpdesk ticket.  "MySQL server has gone away" means your MySQL server has closed the connection.  That is, by definition, an issue with your MySQL server.

You didn't mention in your ticket that you'd dramatically altered the MySQL timeouts.  If your server is heavily loaded, 15sec may not be enough and that's probably your issue.  The default is 28800.

Either way, this is definitely not a Centova Cast issue.