#3968 [HHQ-3706] Deleting large number of services from resource h

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-3706
To reproduce:

1. Add 1000 file services under and agent


2. Wait till all file services get scheduled and collect at least 1 metric


3. Go to resource hub-> Services


4. Select File Service File filter and view All 1000 services


5. Select all services and click Delete


6. The page gives JBossTransactionRolledbackException after 5 minutes

Note: I see that all 1000 services gets deleted from server but on the agent many of them are still collecting metrics. For example agent was still collecting metric for following file service 30 minutes after it was deleted from server.

2010-02-02 10:45:00,016 DEBUG [ScheduleThread] [ScheduleThread] [3:12039:UTILIZATION] Metric='FileServer File:sigar:Type=FileInfo,Arg=/x2/HQ/files/file431:Size' -> 13 timestamp=1265136300016

Here's top of the stack, details in the attached server/agent log.

2010-02-02 10:06:34,894 ERROR [http-0.0.0.0-7080-6] [org.jboss.ejb.plugins.LogInterceptor@308] TransactionRolledbackLocalException in method: public abstract org.hyperic.util.config.ConfigResponse org.hyperic.hq.appdef.shared.ConfigManagerLocal.getMergedConfigResponse(org.hyperic.hq.authz.server.session.AuthzSubject,java.lang.String,org.hyperic.hq.appdef.shared.AppdefEntityID,boolean) throws org.hyperic.hq.appdef.shared.AppdefEntityNotFoundException,org.hyperic.hq.appdef.shared.ConfigFetchException,org.hyperic.util.config.EncodingException,org.hyperic.hq.authz.shared.PermissionException, causedBy:


org.hibernate.ObjectNotFoundException: No row with the given identifier exists: [org.hyperic.hq.appdef.ConfigResponseDB#11388]


        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.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:111)


        at org.hibernate.proxy.pojo.javassist.JavassistLazyInitializer.invoke(JavassistLazyInitializer.java:166)


        at org.hyperic.hq.appdef.ConfigResponseDB_$$javassist_26.getProductResponse(ConfigResponseDB$$_javassist_26.java)


        at org.hyperic.hq.appdef.server.session.ConfigManagerEJBImpl.getConfigForType(ConfigManagerEJBImpl.java:663)


        at org.hyperic.hq.appdef.server.session.ConfigManagerEJBImpl.getMergedConfigResponse(ConfigManagerEJBImpl.java:333)


        at sun.reflect.GeneratedMethodAccessor998.invoke(Unknown Source)


        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)


        at java.lang.reflect.Method.invoke(Method.java:597)


        at org.jboss.invocation.Invocation.performCall(Invocation.java:359)


        at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:237)


        at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:158)


        at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:169)


        at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java:63)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:572)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:647)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121)


        at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)


        at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNextBoth(HQApp.java:572)


        at org.hyperic.hq.application.HQApp$Snatcher.invokeNext(HQApp.java:647)


        at org.hyperic.txsnatch.TxSnatch.invoke(TxSnatch.java:71)


        at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)


        at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)


        at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:138)


        at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)


        at org.jboss.ejb.Container.invoke(Container.java:960)


        at org.jboss.ejb.plugins.local.BaseLocalProxyFactory.invoke(BaseLocalProxyFactory.java:430)


        at org.jboss.ejb.plugins.local.StatelessSessionProxy.invoke(StatelessSessionProxy.java:103)


        at $Proxy281.getMergedConfigResponse(Unknown Source)


        at org.hyperic.hq.bizapp.server.session.AppdefBossEJBImpl.removeTrackers(AppdefBossEJBImpl.java:1577)