Re: MySQL goes away?
- From: Rico Secada <coolzone@xxxxx>
- Date: Sun, 31 Aug 2008 18:51:56 +0200
On Sun, 31 Aug 2008 16:05:39 +0100
kj <koffiejunkielistlurker@xxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx
with a subject of "unsubscribe". Trouble? Contact
listmaster@xxxxxxxxxxxxxxxx
--
To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx
with a subject of "unsubscribe". Trouble? Contact listmaster@xxxxxxxxxxxxxxxx
- References:
- MySQL goes away?
- From: Rico Secada
- Re: MySQL goes away?
- From: kj
- MySQL goes away?
- Prev by Date: Re: LiloCan't Boot vmlinuz-2.6.26-1-amd64
- Next by Date: Re: Sound volume user specific?
- Previous by thread: Re: MySQL goes away?
- Next by thread: Lenny's debian-installer installs Lilo when using lvm
- Index(es):
Relevant Pages
|
