Bug #54618 mysql::masterlogs::filesizesum reporting value for mysql::masterlogs::filecount
Submitted: 18 Jun 2010 17:06 Modified: 19 Jul 2010 7:15
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Agent Severity:S3 (Non-critical)
Version:2.2.0.1709 OS:Any
Assigned to: Mark Leith CPU Architecture:Any

[18 Jun 2010 17:06] Mark Leith
Description:
mysql::masterlogs::filesizesum is currently reporting the value for mysql::masterlogs::filecount incorrectly - which means the "Binary Log Space Exceeds Specified Limit" rule is not working correctly.

How to repeat:
Compare the value reported by mysql::masterlogs::filesizesum for a server with binary logging enabled with the actual space used by binary logs. 

Suggested fix:
Report the sum of all binary log files, instead of the file count.
[21 Jun 2010 12:35] Enterprise Tools JIRA Robot
Mark Leith writes: 
Patch pushed to trunk:

1889 Mark Leith	2010-06-21
     Bug#54618 / EM-4610 - fix SHOW MASTER LOGS parsing to properly sum up file sizes

   modified:
     src/job_collect_mysql.c
[21 Jun 2010 15:08] Enterprise Tools JIRA Robot
Mark Leith writes: 
Also pushed to 2.2:

1886 Mark Leith	2010-06-21
     Bug#54618 / EM-4610 - fix SHOW MASTER LOGS parsing to properly sum up file sizes

push message seems to have gone awry, though the commit message made it through:

Generating post-push message                                                                                                                                                                           
Sending post-push message
Bundling 1 revision(s).
Pushed up to revision 1886.
[24 Jun 2010 11:32] Enterprise Tools JIRA Robot
Mark Leith writes: 
Available in build 2.3.0.2016
[24 Jun 2010 16:56] Enterprise Tools JIRA Robot
Mark Leith writes: 
Re-marking patch-pushed for 2.2.3
[7 Jul 2010 21:10] Enterprise Tools JIRA Robot
Andy Bang writes: 
In build 2.2.2.1729.
[15 Jul 2010 12:03] Enterprise Tools JIRA Robot
Diego Medina writes: 
Verified fixed on 2.2.2.1729
[19 Jul 2010 7:15] MC Brown
A note has been added to the 2.2.2 and 2.3.0 changelogs:

        The data reported for the binary log file size (in                                                                                                 
        <literal>mysql::masterlogs::filesizesum</literal>) was                                                                                             
        erroneously reporting the count of the files, not the sum of the                                                                                   
        size of the binary logs.