[Bug 513135] [NEW] MySQL logrotate script returns with error when server isn't running

[reini]

Public bug reported:

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

** Affects: mysql-dfsg-5.1 (Ubuntu)
     Importance: Undecided
         Status: New


** Tags: apport-bug i386

-- 
MySQL logrotate script returns with error when server isn't running
https://bugs.launchpad.net/bugs/513135
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in ubuntu.