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?
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
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
