On Sun, 31 Aug 2008 16:05:39 +0100 kj <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] > with a subject of "unsubscribe". Trouble? Contact > [EMAIL PROTECTED] > > -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]