Re: MySQL goes away?
On Sun, 31 Aug 2008 04:37:04 +0000
Tzafrir Cohen <tzafrir@cohens.org.il> 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 <mfidelman@meetinghouse.net> 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 | tzafrir@jabber.org | VIM is
> http://tzafrir.org.il | | a Mutt's
> tzafrir@cohens.org.il | | best
> ICQ# 16849754 | | friend
>
>
> --
> To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact
> listmaster@lists.debian.org
>
>
Reply to: