Golfreeze.packetlove.com: Life style of Golfreeze Canon400D Family kammtan.com Jazz Freebsd Unix Linux System Admin guitar Music

All about unix linux freebsd and FAQ for Packetlove.com Web hosting , Mail hosting , VoIP + IP PBX server => Mail issue , problem , configuration => Topic started by: golfreeze on มีนาคม 29, 2015, 12:06:07 PM

Title: NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute
Post by: golfreeze on มีนาคม 29, 2015, 12:06:07 PM
#maillog show amazes log NOTICE about mysql server has gone away.

Mar 29 11:41:42  amavis[3173]: (03173-02) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 117) line 172.
Mar 29 11:41:42 amavis[93285]: (93285-20) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 117) line 172.
Mar 29 11:41:47 amavis[94417]: (94417-19) NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute failed: MySQL server has gone away at (eval 117) line 172, <GEN29>

happened by 1 issues , This is just notice not any error occurred please understand it.
1. when amavis daemon try to connect mysql and mysql have limit for timeout_connection in my.cnf ,
you could tunning my.cnf configure to customized mysql configuration but if would like to ignore this notice you could uncomment line below on my.cnf
SERVER#vi /etc/my.cnf
#interactive_timeout=200
#wait_timeout=200

#/etc/init.d/mysqld reload