Bug #29379 mysql-service-agent logfile not rotated
Submitted: 27 Jun 2007 9:00 Modified: 10 Jun 2008 12:10
Reporter: Kristian Koehntopp Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:1.1.0.4876 OS:Any
Assigned to: Kay Roepke CPU Architecture:Any
Tags: mer 121, mysql-service-agent log rotate

[27 Jun 2007 9:00] Kristian Koehntopp
Description:
[root@mc01crondb-01 log]# ls -lh
total 42M
-rw-rw----  1 root root 32M Jun 27 10:56 mysql-service-agent-dw.log
-rw-rw----  1 root root 11M Jun 21 11:49 mysql-service-agent.log
[root@mc01crondb-01 log]# pwd
/opt/mysql/network/agent/log

That log is not cycled.

How to repeat:
Run merlin agent. Wait 3 months. Check log size.

Suggested fix:
Drop in /etc/logrotate.d/mysql-service-agent on installation

/opt/mysql/network/agent/log/mysql-service-agent* {
    notifempty
    daily
    rotate 3
    missingok
    compress
    postrotate
        for i in /etc/init.d/mysql-service-agent*
        do
          test -x $i && $i restart > /dev/null 2>&1
        done
    endscript
}

Note that we need to be able to handle more than one instance.
[27 Jun 2007 9:04] Kristian Koehntopp
The restart should be a SIGHUP, but cannot be at the moment.
[27 Jun 2007 9:08] Kristian Koehntopp
jan asked me to put the sighup request into a separate bug report. See http://bugs.mysql.com/bug.php?id=29380
[22 Aug 2007 12:20] Kristian Koehntopp
It must be

/opt/mysql/network/agent/log/mysql-service-agent*.log {

or we rotate rotated log files.

Also, currently copytruncate does work ok and we do not need the restart then.
[22 Aug 2007 15:26] Jan Kneschke
the logrotate file was added [7232] to trunk/ 

Keith has to add it to the install into the right location on Linux after it is merged to 1.2.0
[22 Aug 2007 22:02] Jan Kneschke
merged into 1.2.0 in [7237]
[17 Oct 2007 20:19] Peter Lavin
Documented as a known issue.
[2 May 2008 5:23] Gary Whizin
Re-opening and clearing priority (was P3) to force bug triage :)
[10 Jun 2008 12:10] Kay Roepke
handled in http://bugs.mysql.com/29380