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::stexecute failed: MySQL server has gone away at (eval 40) line 153, <GEN32> line 3.: 2 Time(s) Does anyone know what exactly this means?
Your program leaves the connection open, and the connection times out. It's a bit like this:
mysql> show variables like 'wait%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 28800 | +---------------+-------+ 1 row in set (0.00 sec) mysql> set wait_timeout = 60; Query OK, 0 rows affected (0.00 sec) mysql> show variables like 'wait%'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 60 | +---------------+-------+ 1 row in set (0.00 sec) and then, after more than a minute: mysql> show variables like 'wait%'; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 35716 Current database: *** NONE *** +---------------+-------+ | Variable_name | Value | +---------------+-------+ | wait_timeout | 28800 | +---------------+-------+ 1 row in set (0.00 sec) Close your connections or set your wait_timeout higher. --kj