Every day, I get a mail from the cron daemon that the logrotate script for mysql failed to run:
/etc/cron.daily/logrotate:
/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
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.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
[mysqld_safe]
syslog
MySQLVarLibDirListing: ['debian-5.1.flag', 'ibdata1', 'b98228_newsticker', 'debian-5.0.flag', 'growingdb', 'decidrdb', 'ib_logfile0', 'gb', 'mysql_upgrade_info', 'info', 'abihome', 'b98228_website', 'ib_logfile1', 'mysql_upgrade.info', 'mysql']
Package: mysql-server 5.1.37-1ubuntu5
PackageArchitecture: all
ProcEnviron:
SHELL=/bin/bash
PATH=(custom, user)
LANG=de_DE.UTF-8
LANGUAGE=
ProcVersionSignature: Ubuntu 2.6.31-18.55-generic
SourcePackage: mysql-dfsg-5.1
Uname: Linux 2.6.31-18-generic i686
XsessionErrors:
(polkit-gnome-authentication-agent-1:2574): GLib-CRITICAL **: g_once_init_leave: assertion `initialization_value != 0' failed
(firefox:2570): GLib-WARNING **: g_set_prgname() called multiple times
(firefox:2570): GLib-WARNING **: g_set_prgname() called multiple times
On Wed, Jan 27, 2010 at 08:00:50AM -0000, reini wrote:
> 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
--
Mathias Gug
Ubuntu Developer http://