Re: MySQL goes away?

On Sun, 31 Aug 2008 04:37:04 +0000
Tzafrir Cohen <tzafrir@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxx | VIM is
http://tzafrir.org.il | | a Mutt's
tzafrir@xxxxxxxxxxxxx | | best
ICQ# 16849754 | | friend


--
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

Relevant Pages

  • Re: lost mysql root password
    ... On Friday 03 March 2006 02:20 pm, Matt Price wrote: ... Now I'm back to configuring some programs that use mysql, ... | hash 1 ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)
  • [UNIX] Multiple MySQL Vulnerabilities (COM_TABLE_DUMP, COM_CHANGE_USER, read_rows, read_one_row)
    ... used by any MySQL user to crash the server. ... SIGSEGV handler we strongly believe this bug can only be used for denial ... The MySQL challenge response ...
    (Securiteam)
  • RE: [SLE] so OT it hurts...Merry Christmas!
    ... flames and one rather inane response that left me wondering if that was the ... I also didn't get a response to one question in *MY* rather heated original ... PLEASE don't unsubscribe due to my personal lapse in discipline here, ... > Fuck You, Fuck Your Mother and Fuck the Hole you and your subhuman ...
    (SuSE)
  • Re: [PHP] php cli and mysql
    ... James Tu wrote: ... Why is the CLI looking for it at /var/myslq/mysql.sock? ... Do I change the mysql settings so that mysql.sock is at ... To unsubscribe, visit: http://www.php.net/unsub.php ...
    (php.general)
  • Re: Getting started with Postgres or MySQL
    ... statement has begun executing. ... MySQL with the MyISAM data store is *exactly* what you describe. ... To UNSUBSCRIBE, email to debian-user-REQUEST@xxxxxxxxxxxxxxxx ...
    (Debian-User)