MySQL Bugs: #57593: new 2.3 graphs not visible after svc mgr update to 2.3.0, need to re-import them

Bug #57593	new 2.3 graphs not visible after svc mgr update to 2.3.0, need to re-import them
Submitted:	20 Oct 2010 8:27	Modified:	24 Jan 2011 19:05
Reporter:	Carsten Segieth	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Server	Severity:	S2 (Serious)
Version:	2.3.0.2036	OS:	Any
Assigned to:	Andy Bang	CPU Architecture:	Any

Description:
After a service manager update to 2.3.0.2036 the new graphs (like Cluster*, Disk IO Usage, ...) are not visible.

A re-import of the 2.3.0.2033 advisor/graphs package made them visible.

How to repeat:
- install old version (I tested with both 2.1.2.1163 and 2.2.2.1730)
- update to 2.3.0.2036
- see on "Product Information" version 2.3.0.2033 for the advisors
- check that you don't see "Cluster*" and "Disk IO Usage" graphs in the "edit favorites" selection on main dashboard
- import advisors 2.3.0.2033 (yes, same version, to show that it's not related to the advisor package itself)
- check again the list of graphs in the "edit favorites", see that now the new 2.3.0 graphs are present

Suggested fix:
perform something like a 'silent re-import' during update install

agent@net-qa1 [mem]> select count(*) as "before re-import" from graphs;
+------------------+
| before re-import |
+------------------+
|               33 |
+------------------+
1 row in set (0.34 sec)

agent@net-qa1 [mem]> select count(*) from graphs where title like "%disk%";
+----------+
| count(*) |
+----------+
|        0 |
+----------+
1 row in set (0.34 sec)

agent@net-qa1 [mem]> select count(*) as "after re-import" from graphs; select count(*) from graphs where title like "%disk%";
+-----------------+
| after re-import |
+-----------------+
|              49 |
+-----------------+
1 row in set (1.69 sec)

+----------+
| count(*) |
+----------+
|        2 |
+----------+
1 row in set (1.34 sec)

Josh Sled writes: 
revno: 8234
revision-id: josh.sled@oracle.com-20101025175453-n2ay0q60sqadw4pe
parent: mark.leith@oracle.com-20101025142819-kas7rrqzxsgq6z1p
committer: Josh Sled <josh.sled@oracle.com>
branch nick: 2.3
timestamp: Mon 2010-10-25 13:54:53 -0400
message:
  EM-4990: use the DB-retained bundle version for comparison to the file-system version to determine if we should force an "import" of the bundle on server start.

Andy Bang writes: 
In build 2.3.1.2038.

Added to 2.3.1 change log:

After upgrading the service manager, certain graphs were not
available and had to be re-imported.