On Sun, 31 Aug 2008 04:37:04 +0000 Tzafrir Cohen <[EMAIL PROTECTED]> wrote:
> On Sat, Aug 30, 2008 at 09:53:42PM +0200, Rico Secada wrote: > > On Sat, 30 Aug 2008 09:14:37 -0400 > > Miles Fidelman <[EMAIL PROTECTED]> wrote: > > > > > Rico Secada wrote: > > > > 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? > > > > > > > > > > > well, just a guess, but it looks like your mysql daemon has died > > > > > > take a look at your mysql log files, and then restart the daemon - > > > see what happens > > > > That's the problem mysql isn't dead. > > How can you tell that? Please post here the output of the relevant > shell commands you tested with. Tzafrir you can tell that in a number of ways, here are two: # ps aux | grep mysql root 2384 0.0 0.0 10108 1516 ? S Aug21 0:00 /bin/sh /usr/bin/mysqld_safe mysql 2421 0.0 0.3 147496 24028 ? Sl Aug21 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --skip-external-locking --port=3306 --socket=/var/run/mysqld/mysqld.sock root 2422 0.0 0.0 2636 532 ? S Aug21 0:00 logger -p daemon.err -t mysqld_safe -i -t mysqld # /etc/init.d/mysql status /usr/bin/mysqladmin Ver 8.41 Distrib 5.0.32, for pc-linux-gnu on x86_64 Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.0.32-Debian_7etch6-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/run/mysqld/mysqld.sock Uptime: 9 days 21 hours 4 min 57 sec > -- > Tzafrir Cohen | [EMAIL PROTECTED] | VIM is > http://tzafrir.org.il | | a Mutt's > [EMAIL PROTECTED] | | best > ICQ# 16849754 | | friend > > > -- > 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]
