#1386 [HHQ-2009] AI approval for a large queue fails with jdbc loc

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-2009
AI approval using mass plugin for a large queue fails with following error.

The only slow query I see in slow query log is following:

Time: 080421 13:06:19

User@Host: hqadmin[hqadmin] @ [10.0.0.122]

Query_time: 52 Lock_time: 0 Rows_sent: 0 Rows_examined: 0

insert into EAM_CONFIG_RESPONSE (VERSION_COL, PRODUCT_RESPONSE, CONTROL_RESPONSE, MEASUREMENT_RESPONSE, AUTOINVENTORY_RESPONSE, RESPONSE_TIME_RESPONSE, USERMANAGED, VALIDATIONERR, ID) values (0, null, null, null, null, null, 0, null, 16961);

2008-04-21 13:06:20,398 ERROR [http-0.0.0.0-7080-33] [org.hibernate.util.JDBCExceptionReporter] Lock wait timeout exceeded; try restarting transaction


2008-04-21 13:06:20,399 ERROR [http-0.0.0.0-7080-33] [org.hibernate.event.def.AbstractFlushingEventListener] Could not synchronize database state with session


org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update


        at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)


        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)


        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)


        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:253)


        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:92)


        at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)


        at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)


        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2229)


        at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2665)


        at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:60)


        at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)


        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)


        at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:167)


        at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)


        at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)


        at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)


        at org.hyperic.hq.authz.server.session.ResourceDAO.create(ResourceDAO.java:74)


        at org.hyperic.hq.authz.server.session.ResourceManagerEJBImpl.createResource(ResourceManagerEJBImpl.java:260)


        at sun.reflect.GeneratedMethodAccessor339.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:345)


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


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


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


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


        at $Proxy241.createResource(Unknown Source)


        at org.hyperic.hq.appdef.server.session.AppdefSessionEJB.createAuthzResource(AppdefSessionEJB.java:176)


        at org.hyperic.hq.appdef.server.session.ServerManagerEJBImpl.createAuthzServer(ServerManagerEJBImpl.java:1375)


        at org.hyperic.hq.appdef.server.session.ServerManagerEJBImpl.createServer(ServerManagerEJBImpl.java:187)


        at sun.reflect.GeneratedMethodAccessor776.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:345)


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


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


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


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


        at $Proxy234.createServer(Unknown Source)


        at org.hyperic.hq.appdef.server.session.AIQRV_approve.visitServer(AIQRV_approve.java:300)


        at org.hyperic.hq.appdef.server.session.AIQueueManagerEJBImpl._processQueue(AIQueueManagerEJBImpl.java:619)


        at org.hyperic.hq.appdef.server.session.AIQueueManagerEJBImpl.processQueue(AIQueueManagerEJBImpl.java:499)


        at sun.reflect.GeneratedMethodAccessor1217.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:345)


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


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


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


        at org.jboss.webservice.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java:54)


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


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


        at $Proxy222.processQueue(Unknown Source)


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


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:903)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:742)


        at org.codehaus.groovy.runtime.InvokerHelper.invokePojoMethod(InvokerHelper.java:741)


        at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:729)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:165)


        at AutodiscoveryController.processPlatform(AutodiscoveryController:92)


        at AutodiscoveryController.this$3$processPlatform(AutodiscoveryController)


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


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:903)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodOnCurrentN(ScriptBytecodeAdapter.java:75)


        at AutodiscoveryController.approve(AutodiscoveryController:66)


        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:903)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:742)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:677)


        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:903)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:742)


        at org.codehaus.groovy.runtime.InvokerHelper.invokePojoMethod(InvokerHelper.java:741)


        at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:729)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:165)


        at org.hyperic.hq.hqu.rendit.BaseController.invokeMethod(org.hyperic.hq.hqu.rendit.BaseController)


        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:903)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodOnCurrentN(ScriptBytecodeAdapter.java:75)


        at org.hyperic.hq.hqu.rendit.BaseController.dispatchRequest(org.hyperic.hq.hqu.rendit.BaseController:180)


        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:903)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:742)


        at org.codehaus.groovy.runtime.InvokerHelper.invokePogoMethod(InvokerHelper.java:753)


        at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:733)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:165)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethod0(ScriptBytecodeAdapter.java:193)


        at org.hyperic.hq.hqu.rendit.DefaultControllerDispatcher.invoke(DefaultControllerDispatcher.groovy:62)


        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:903)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:742)


        at org.codehaus.groovy.runtime.InvokerHelper.invokePogoMethod(InvokerHelper.java:753)


        at org.codehaus.groovy.runtime.InvokerHelper.invokeMethod(InvokerHelper.java:733)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodN(ScriptBytecodeAdapter.java:165)


        at org.hyperic.hq.hqu.rendit.Dispatcher$_handleRequest_closure4.doCall(dispatcher.groovy:99)


        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:252)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodOnCurrentN(ScriptBytecodeAdapter.java:75)


        at org.hyperic.hq.hqu.rendit.Dispatcher$_handleRequest_closure4.doCall(dispatcher.groovy)


        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)


        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)


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


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


        at org.codehaus.groovy.reflection.CachedMethod.invoke(CachedMethod.java:84)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at org.codehaus.groovy.runtime.metaclass.ClosureMetaClass.invokeMethod(ClosureMetaClass.java:252)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:742)


        at groovy.lang.Closure.call(Closure.java:292)


        at groovy.lang.Closure.call(Closure.java:287)


        at org.codehaus.groovy.runtime.GroovyCategorySupport.use(GroovyCategorySupport.java:167)


        at org.codehaus.groovy.runtime.DefaultGroovyMethods.use(DefaultGroovyMethods.java:318)


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


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


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


        at org.codehaus.groovy.runtime.metaclass.ReflectionMetaMethod.invoke(ReflectionMetaMethod.java:50)


        at org.codehaus.groovy.runtime.metaclass.NewInstanceMetaMethod.invoke(NewInstanceMetaMethod.java:54)


        at org.codehaus.groovy.runtime.MetaClassHelper.doMethodInvoke(MetaClassHelper.java:599)


        at groovy.lang.MetaClassImpl.invokeMethod(MetaClassImpl.java:903)


        at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeMethodOnCurrentN(ScriptBytecodeAdapter.java:75)


        at org.hyperic.hq.hqu.rendit.Dispatcher.handleRequest(dispatcher.groovy:98)


        at org.hyperic.hq.hqu.rendit.PluginWrapper$3.run(PluginWrapper.java:139)


        at org.hyperic.hq.hqu.rendit.PluginWrapper.doInContext(PluginWrapper.java:107)


        at org.hyperic.hq.hqu.rendit.PluginWrapper.handleRequest(PluginWrapper.java:137)


        at org.hyperic.hq.hqu.rendit.RenditServer.handleRequest(RenditServer.java:188)


        at org.hyperic.hq.ui.servlet.RenditServlet.handleRequest(RenditServlet.java:193)


        at org.hyperic.hq.ui.servlet.RenditServlet.doGet(RenditServlet.java:61)


        at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)


        at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)


        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)


        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


        at org.hyperic.hq.ui.RenditFilter.doFilter(RenditFilter.java:60)


        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


        at org.hyperic.hq.ui.AuthenticationFilter.doFilter(AuthenticationFilter.java:151)


        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


        at org.hyperic.hibernate.filter.SessionFilter$1.run(SessionFilter.java:59)


        at org.hyperic.hq.hibernate.SessionManager.runInSessionInternal(SessionManager.java:79)


        at org.hyperic.hq.hibernate.SessionManager.runInSession(SessionManager.java:68)


        at org.hyperic.hibernate.filter.SessionFilter.doFilter(SessionFilter.java:57)


        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


        at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:81)


        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


        at org.hyperic.hq.product.servlet.filter.JMXFilter.doFilter(JMXFilter.java:324)


        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)


        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)


        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)


        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)


        at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalValve.java:39)


        at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:159)


        at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:59)


        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)


        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)


        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)


        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)


        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)


        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)


        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)


        at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWorkerThread.java:112)


        at java.lang.Thread.run(Thread.java:619)


Caused by: java.sql.BatchUpdateException: Lock wait timeout exceeded; try restarting transaction


        at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1213)


        at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:912)


        at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeBatch(CachedPreparedStatement.java:461)


        at org.jboss.resource.adapter.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:487)


        at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:48)


        at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:246)


        ... 245 more