Re: MySQL goes away?

[Rico Secada <coolzone@it.dk>]

On Sun, 31 Aug 2008 16:05:39 +0100
kj <koffiejunkielistlurker@koffiejunkie.za.net> wrote:

> 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.

Thanks kj, makes sense!
 
> --kj
> 
> 
> -- 
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org 
> with a subject of "unsubscribe". Trouble? Contact
> listmaster@lists.debian.org
> 
>