Author Topic: NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute  (Read 4845 times)

golfreeze

  • Administrator
  • Hero Member
  • *****
  • Posts: 2141
    • View Profile
    • นั่งสมาธิ สติปัฏฐานสี่ พาเที่ยววัด แนะนำวัด แจกcd ธรรมะฟรี
    • Email
NOTICE: reconnecting in response to: err=2006, HY000, DBD::mysql::st execute
« 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