Postrotate script goes wrong

[Kurt Agius]

I get this email every day:

/etc/cron.daily/logrotate:
error: error running shared postrotate script for '/var/log/mysql.log /var/log/mysql/mysql.log /var/log/mysql/mysql-slow.log '
run-parts: /etc/cron.daily/logrotate exited with return code 1

I checked the user and pass in: /etc/mysql/debian.cnf everything is correct.

I checked the source in: /etc/logrotate.d/mysql-server and i see the comment: "If this occurs and is not a error please report a bug." so that's what i'm doing.

Does anybody have the same problem ?

ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: mysql-server-5.5 5.5.29-0ubuntu0.12.04.2
ProcVersionSignature: Ubuntu 3.2.0-36.57-generic 3.2.35
Uname: Linux 3.2.0-36-generic x86_64
ApportVersion: 2.0.1-0ubuntu17.1
Architecture: amd64
Date: Sun Mar 10 20:36:43 2013
Logs.var.log.daemon.log:

Logs.var.log.kern.log:

MarkForUpload: True
MySQLConf.etc.mysql.conf.d.mysqld.safe.syslog.cnf:
 [mysqld_safe]
 syslog
MySQLVarLibDirListing: False
ProcEnviron:
 LANGUAGE=en_US:
 TERM=xterm
 PATH=(custom, no user)
 LANG=en_US
 SHELL=/bin/bash
SourcePackage: mysql-5.5
UpgradeStatus: No upgrade log present (probably fresh install)

[Yolanda Robla (yolanda.robla)]

Thanks for reporting this
Can you take a look at this post? http://ubuntuforums.org/showthread.php?t=1418987

[Kurt Agius (kurteknikk)]

I'm sorry but that doesn't solve my issue. (I did check out: http://www.lornajane.net/posts/2008/Logrotate-Error-on-Ubuntu)

I already checked the user and password and all privileges and everything is correct.

There must be something else wrong. I tried every step of the: /etc/logrotate.d/mysql-server manually and everything seems correct.

[Kurt Agius (kurteknikk)]

Hi again...

Sorry but looks like that i'm not having these errors anymore for the last 2 days.
Which is very strange because i haven't changed anything, apart from removing mysql.log.[3-7].gz files from /var/log.

I think this issue is fixed for now, i will try to investigate further how this was solved.