Support Migration Notice: To update migrated JIRA cases click here to open a new case use | vFabric Hyperic 5.7.0 is Now Available

Hyperic HQ

Metric Default schedule update gives BatchUpdateException: Statement cancelled due to timeout or client request


  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Major Major
  • Resolution: Deferred
  • Affects Version/s: 4.5
  • Fix Version/s: None
  • Component/s: Core Monitoring
  • Case Links:
  • Regression:
  • Tags:


To reproduce:

In this specific case we have an environment with following inventory

Platforms (126) |
Servers (1493) |
Services (30201)
Metrics inserts / minute = 165136

User goes to changed Measurement Default for a few (5) metrics under a service template
The collection is changed from 1 minute to 5 minutes for the 5 selected metrics to reduce metric insert load
UI spins for 15 minutes and then times out with following error. None of the agents receive updated schedule, the schedule is not even updated on server side.

2010-08-30 19:47:26,941 ERROR [tomcat-http--327] [org.hibernate.event.def.AbstractFlushingEventListener@301] Could not synchronize database state with session
org.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(
at org.hibernate.exception.SQLStateConverter.convert(
at org.hibernate.exception.JDBCExceptionHelper.convert(
at org.hibernate.jdbc.AbstractBatcher.executeBatch(
at org.hibernate.engine.ActionQueue.executeActions(
at org.hibernate.engine.ActionQueue.executeActions(
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(
at org.hibernate.impl.SessionImpl.flush(
at org.hyperic.hq.dao.HibernateDAO.flushSession(
at org.hyperic.hq.measurement.server.session.TemplateManagerImpl.updateTemplateDefaultInterval(
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(
at org.hyperic.hq.monitor.aop.aspects.PerformanceMonitor.monitorServiceMethod(
at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
Caused by: java.sql.BatchUpdateException: Statement cancelled due to timeout or client request
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(
at com.mysql.jdbc.PreparedStatement.executeBatch(
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(
at org.hibernate.jdbc.AbstractBatcher.executeBatch(
... 111 more


Yoav Epelman added a comment -

Bulk change to new components

Yoav Epelman added a comment - Bulk change to new components


Vote (0)
Watch (0)


  • Created:
    Last comment:
    2 years, 40 weeks, 2 days ago