[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

Re: MySQL goes away?



On Saturday 30 August 2008 12:26:06 Rico Secada wrote:
> Hi,
>
> I keep getting this from Amavis about MySQL:
>
> **Unmatched Entries**
> NOTICE: reconnecting in response to: err=2006, S1000, DBD::mysql::st
> execute failed: MySQL server has gone away at (eval 40) line 153,
> <GEN27> line 3.: 2 Time(s)
> NOTICE: reconnecting in response to: err=2006, S1000, DBD::mysql::st
> execute failed: MySQL server has gone away at (eval 40) line 153,
> <GEN32> line 3.: 2 Time(s)
>
> Does anyone know what exactly this means?
>
> Best regards.

Have a look at the following:
  http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

I have had this issue in the past, although I can't remember what /i did to 
fix it.

You could check the following:
	- firewall rules
	- restart mysql and see if it still happens
	- check how many connections you have:
		- sudo netstat -tapn | grep mysql
		- mysqladmin processlist

You might have too many clients connected but iirc that would be a different 
error...

HTH
-- 
Thank you,

Clifford W. Hansen
PHP Developer / Linux Administrator

(Cell)    +27 82 883 8677
(Fax)     +27 86 503 0634
(E-Mail)  clifford@nighthawk.co.za
(MSN)     clifford@nighthawk.co.za
(GPG)     0x936D6C19

"We have seen strange things today!"

()  ascii ribbon campaign - against html e-mail 
/\  www.asciiribbon.org   - against proprietary attachments

Attachment: signature.asc
Description: This is a digitally signed message part.


Reply to: