MySQL Bugs: #29623: Advisor info doesn't accurately reflect the number of rules in the database

Bug #29623	Advisor info doesn't accurately reflect the number of rules in the database
Submitted:	7 Jul 2007 23:55	Modified:	22 Jul 2008 13:26
Reporter:	Andy Bang	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Server	Severity:	S3 (Non-critical)
Version:	1.2.0.6467	OS:	Any
Assigned to:	Darren Oldag	CPU Architecture:	Any

Description:
The information on the Advisors->Check For Updates page does not accurately reflect how many rules and graphs are actually in the database and available to the user.

How to repeat:
1) Import a Platinum bundle.  You'll see:

     Version
     1.2.0.6471
     Number of Rules
     89
     Number of Graphs
     17

2) If you SELECT COUNT(*) FROM merlin.monitors you'll get 89, so all is well.
3) Import a Gold bundle.  Now you'll see:

     Version
     1.2.0.6471
     Number of Rules
     60
     Number of Graphs
     11

4) This shows how many rules and graphs were imported from that bundle.  However, if you SELECT COUNT(*) FROM merlin.monitors you'll still get 89 because it hasn't deleted the old ones -- they're still there and available for use.

select count from monitor_version;
select graph_count from monitor_version;

Note that these numbers reflect the inaccurate count. This is a server issue rather than UI issue and our logic around modifying the version meta info needs to be updated.

Eric, I think you misunderstand this bug. It's not about removing the other rules, it's about having accurate summary information on the rules. When we get the rule count, we're not counting the rules, we're getting the meta-info from monitor_version. If those values can be fixed, this bug goes away.

By the way, we definitely don't want to remove the old bundle when importing a new one or we preclude the use of customer bundles.

been fixed in 2.0 trunk for a while.

An entry was added to the 2.0 changelog:

The information on the Advisors, Check For Updates page did not accurately reflect how many rules and graphs were actually in the database and available to the user.