Re: MySQL goes away?
- From: kj <koffiejunkielistlurker@xxxxxxxxxxxxxxxxxxx>
- Date: Sun, 31 Aug 2008 16:05:39 +0100
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 debian-user-REQUEST@xxxxxxxxxxxxxxxx with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx
- Follow-Ups:
- Re: MySQL goes away?
- From: Rico Secada
- Re: MySQL goes away?
- References:
- MySQL goes away?
- From: Rico Secada
- MySQL goes away?
- Prev by Date: Accessing mesa's OpenGL 2.1 features
- Next by Date: Re: Sound volume user specific?
- Previous by thread: Re: MySQL goes away?
- Next by thread: Re: MySQL goes away?
- Index(es):
Relevant Pages
|
