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@xxxxxxxxxxxxxxx
(MSN) clifford@xxxxxxxxxxxxxxx
(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.

Relevant Pages