MySQL logrotate script returns with error when server isn't running
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL Server |
New
|
Unknown
|
|||
mysql-dfsg-5.1 (Ubuntu) |
Fix Released
|
Low
|
Unassigned | ||
Bug Description
Every day, I get a mail from the cron daemon that the logrotate script for mysql failed to run:
/etc/cron.
/usr/bin/
error: 'Can't connect to local MySQL server through socket '/var/run/
Check that mysqld is running and that the socket: '/var/run/
I don't know what the little telephone is supposed to imply, but the mail is hugely annoying in the long run.
I only use mysql as a database for some projects I'm developing and therefore rarely need to run it. Since this is a laptop, I prefer to keep it inactive unless I need it. The logrotate script therefore usually can't connect to a running mysql daemon.
I would expect the script to silently do nothing, since this is not an error.
ProblemType: Bug
Architecture: i386
Date: Wed Jan 27 08:52:55 2010
DistroRelease: Ubuntu 9.10
MySQLConf.
[mysqld_safe]
syslog
MySQLVarLibDirL
Package: mysql-server 5.1.37-1ubuntu5
PackageArchitec
ProcEnviron:
SHELL=/bin/bash
PATH=(custom, user)
LANG=de_DE.UTF-8
LANGUAGE=
ProcVersionSign
SourcePackage: mysql-dfsg-5.1
Uname: Linux 2.6.31-18-generic i686
XsessionErrors:
(polkit-
(firefox:2570): GLib-WARNING **: g_set_prgname() called multiple times
(firefox:2570): GLib-WARNING **: g_set_prgname() called multiple times
Changed in mysql-dfsg-5.1 (Ubuntu): | |
status: | Confirmed → Fix Committed |
Changed in mysql-server: | |
status: | Unknown → New |
Changed in mysql-server: | |
status: | New → Fix Released |
Changed in mysql-server: | |
status: | Fix Released → New |
On Wed, Jan 27, 2010 at 08:00:50AM -0000, reini wrote: daily/logrotate : mysqladmin: connect to server at 'localhost' failed mysqld/ mysqld. sock' (2)' mysqld/ mysqld. sock' exists!
> Public bug reported:
>
> Every day, I get a mail from the cron daemon that the logrotate script
> for mysql failed to run:
>
> /etc/cron.
> /usr/bin/
> error: 'Can't connect to local MySQL server through socket '/var/run/
> Check that mysqld is running and that the socket: '/var/run/
>
>
> I don't know what the little telephone is supposed to imply, but the mail is hugely annoying in the long run.
> I only use mysql as a database for some projects I'm developing and therefore rarely need to run it. Since this is a laptop, I prefer to keep it inactive unless I need it. The logrotate script therefore usually can't connect to a running mysql daemon.
>
> I would expect the script to silently do nothing, since this is not an
> error.
>
Well - this is an edge use case. Most of the systems that have mysql-server
installed are running mysqld as a daemon and expect it to be running all the
time. If the daemon is not running, it may be a good thing that a notice is
sent. I don't know whether it should be a message from logrotate though.
importance low
status confirmed
-- www.ubuntu. com
Mathias Gug
Ubuntu Developer http://