Bug #50916 Trying to remove a server that has QUAN inventory, but purged data, fails
Submitted: 4 Feb 2010 15:14 Modified: 29 Mar 2010 10:39
Reporter: Mark Leith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Enterprise Monitor: Server Severity:S3 (Non-critical)
Version:2.1.1.1138 OS:Any
Assigned to: CPU Architecture:Any
Tags: windmill

[4 Feb 2010 15:14] Mark Leith
Description:
Trying to remove a server that has QUAN inventory relating to purged data (it seems), fails:

2010-02-02 13:14:14,404 INFO [http-80-19:com.mysql.replication] Removing server-01 from ReplicationManager
2010-02-02 13:14:14,404 INFO [http-80-19:com.mysql.group] Removing server-01 from GroupManager
2010-02-02 13:14:14,605 INFO [http-80-19:com.mysql.group] Removing server-01 from group group-01
...
2010-02-02 13:14:16,325 DEBUG [http-80-19:com.mysql.timing.accessLog.action] /DeleteServer.action 2003 ms {"request":{"delta":2003,"pctg":100,"start":1265112854322,"stop":1265112856325,"remainder":6,"children":[
{"validateUserInput":{"delta":42,"pctg":2.0968547179231156,"start":1265112854326,"stop":1265112854368}},
{"executeInner":{"delta":1955,"pctg":97.60359460808787,"start":1265112854368,"stop":1265112856323}},
{"renderJson":{"delta":0,"pctg":0,"start":1265112856323,"stop":1265112856323}}]}}
2010-02-02 13:14:16,330 INFO [delete-server-server-01:com.mysql.graph] Removing bc17bprdb-01 from GraphManager
2010-02-02 13:14:16,622 INFO [delete-server-server-01:com.mysql.advisor] Removing bc17bprdb-01 from RuleManager
2010-02-02 13:14:19,363 INFO [delete-server-server-01:com.mysql.inventory] Deleting inventory {mysql}.{StatementSummary}.{02f9fa10-991e-4a7f-88c7-2f4d738b6f49.bp.e046d864c4db7270b3dc4032753aba5e}
2010-02-02 13:14:19,408 ERROR [delete-server-server-01:com.mysql.infra.com.mysql.merlin.server.ReportingRunnable] running command com.mysql.etools.monitor.bo.Manager$2
org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [com.mysql.etools.monitor.pom.hib.HibStatementSummary#557144]
at org.hibernate.impl.SessionFactoryImpl$1.handleEntityNotFound(SessionFactoryImpl.java:377)
at org.hibernate.proxy.AbstractLazyInitializer.checkTargetState(AbstractLazyInitializer.java:79)
at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:68)
at org.hibernate.Hibernate.initialize(Hibernate.java:306)
at com.mysql.etools.monitor.pom.hib.HibPersistence$54.execute(HibPersistence.java:1916)
at com.mysql.etools.monitor.pom.hib.HibPersistence$54.execute(HibPersistence.java:1911)
at com.mysql.etools.monitor.pom.hib.HibernateExecutor.asTransaction(HibernateExecutor.java:164)
at com.mysql.etools.monitor.pom.hib.SchemaMaintenanceExecutor.asTransaction(SchemaMaintenanceExecutor.java:194)
at com.mysql.etools.monitor.pom.hib.HibPersistence.getStatementSummary(HibPersistence.java:1922)
at com.mysql.etools.monitor.pom.hib.HibPersistence.clearDataAndListeners(HibPersistence.java:459)
at com.mysql.etools.monitor.pom.hib.HibPersistence.access$200(HibPersistence.java:101)
at com.mysql.etools.monitor.pom.hib.HibPersistence$9.execute(HibPersistence.java:416)
at com.mysql.etools.monitor.pom.hib.HibPersistence$CacheGetModeHibernateAction.execute(HibPersistence.java:2124)
at com.mysql.etools.monitor.pom.hib.HibernateExecutor.asTransaction(HibernateExecutor.java:188)
at com.mysql.etools.monitor.pom.hib.SchemaMaintenanceExecutor.asTransaction(SchemaMaintenanceExecutor.java:194)
at com.mysql.etools.monitor.pom.hib.HibPersistence.asTransaction(HibPersistence.java:504)
at com.mysql.etools.monitor.pom.hib.HibPersistence.remove(HibPersistence.java:450)
at com.mysql.etools.monitor.pom.hib.HibInventoryObject.delete(HibInventoryObject.java:669)
at com.mysql.etools.monitor.pom.InvObj.delete(InvObj.java:94)
at com.mysql.etools.monitor.pom.InvObj.deleteHierarchy(InvObj.java:102)
at com.mysql.etools.monitor.pom.InvObj.deleteHierarchy(InvObj.java:100)
at com.mysql.etools.monitor.bo.Server.deleteInventory(Server.java:927)
at com.mysql.etools.monitor.bo.Manager$2.run(Manager.java:564)
at com.mysql.merlin.server.ReportingRunnable.run(ReportingRunnable.java:65)
at java.lang.Thread.run(Unknown Source)
2010-02-02 13:14:19,409 ERROR [delete-server-server-01:com.mysql.infra.com.mysql.merlin.server.ReportingRunnable] Tue Feb 02 13:14:19 CET 2010 [ FAILED ] Duration: 00:00:03.080 com.mysql.etools.monitor.bo.Manager$2@2b2ad95d

How to repeat:
Delete a server that has QUAN inventory with no associated data collection. 

Suggested fix:
Do not cancel the delete on this error.
[5 Feb 2010 16:13] Enterprise Tools JIRA Robot
Diego Medina writes: 
See this related bug as well
https://repoman.mysql.com/jira/browse/EM-3703
[5 Feb 2010 20:54] Enterprise Tools JIRA Robot
Mark Matthews writes: 
Pushed to 2.1 and trunk.
[9 Feb 2010 19:46] Enterprise Tools JIRA Robot
Keith Russell writes: 
Patch installed in versions => 2.1.2.1149.
[26 Mar 2010 14:46] Enterprise Tools JIRA Robot
Diego Medina writes: 
Verified fixed on 2.1.2.1149.
[29 Mar 2010 10:39] MC Brown
A note has been added to the 2.1.2 changelog