#4541 [HHQ-4500] Duplicate entry for key 'PRIMARY' on inserting i

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-4500
No Specific steps to reproduce. This error happened while agent was adding VMs in Hyperic inventory after a vCenter Server with 950 vms was configures in Hyperic.

2010-12-07 02:02:24,521 WARN [AgentScheduler2] [org.hibernate.util.JDBCExceptionReporter@77] SQL Error: 1062, SQLState: 23000


2010-12-07 02:02:24,550 ERROR [AgentScheduler2] [org.hibernate.util.JDBCExceptionReporter@78] Duplicate entry '14873-1' for key 'PRIMARY'


2010-12-07 02:02:24,552 ERROR [AgentScheduler2] [org.hibernate.event.def.AbstractFlushingEventListener@301] Could not synchronize database state with session


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


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


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


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


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


        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.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)


        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)


        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)


        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)


        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)


        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:412)


        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)


        at $Proxy69.incrementSrn(Unknown Source)


        at org.hyperic.hq.measurement.server.session.MeasurementProcessorImpl.scheduleMeasurements(MeasurementProcessorImpl.java:247)


        at org.hyperic.hq.measurement.server.session.MeasurementProcessorImpl.scheduleEnabled(MeasurementProcessorImpl.java:222)


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


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


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


        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)


        at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)


        at org.hyperic.hq.monitor.aop.aspects.PerformanceMonitor.monitorServiceMethod(PerformanceMonitor.java:84)


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


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


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


        at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:622)


        at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:611)


        at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)


        at $Proxy77.scheduleEnabled(Unknown Source)


        at org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer$SchedulerThread$1.run(AgentScheduleSynchronizer.java:313)


        at org.hyperic.hq.hibernate.SessionManager$1.doInHibernate(SessionManager.java:86)


        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)


        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)


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


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


        at org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer$SchedulerThread.runSchedule(AgentScheduleSynchronizer.java:305)


        at org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer$SchedulerThread.syncMetrics(AgentScheduleSynchronizer.java:292)


        at org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer$SchedulerThread.run(AgentScheduleSynchronizer.java:257)


        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)


        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)


        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)


        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)


        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)


        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)


        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)


        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)


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


Caused by: java.sql.BatchUpdateException: Duplicate entry '14873-1' for key 'PRIMARY'


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


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


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


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


        ... 58 more


2010-12-07 02:02:24,589 ERROR [AgentScheduler2] [org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer@260] org.springframework.orm.hibernate3.HibernateSystemException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into EAM_SRN (VERSION_COL, SRN, INSTANCE_ID, APPDEF_TYPE) values (?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.HibernateException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into EAM_SRN (VERSION_COL, SRN, INSTANCE_ID, APPDEF_TYPE) values (?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update


org.springframework.orm.hibernate3.HibernateSystemException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into EAM_SRN (VERSION_COL, SRN, INSTANCE_ID, APPDEF_TYPE) values (?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update; nested exception is org.hibernate.HibernateException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into EAM_SRN (VERSION_COL, SRN, INSTANCE_ID, APPDEF_TYPE) values (?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update


        at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:679)


        at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)


        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:411)


        at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)


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


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


        at org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer$SchedulerThread.runSchedule(AgentScheduleSynchronizer.java:305)


        at org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer$SchedulerThread.syncMetrics(AgentScheduleSynchronizer.java:292)


        at org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer$SchedulerThread.run(AgentScheduleSynchronizer.java:257)


        at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441)


        at java.util.concurrent.FutureTask$Sync.innerRunAndReset(FutureTask.java:317)


        at java.util.concurrent.FutureTask.runAndReset(FutureTask.java:150)


        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$101(ScheduledThreadPoolExecutor.java:98)


        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.runPeriodic(ScheduledThreadPoolExecutor.java:181)


        at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:205)


        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)


        at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)


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


Caused by: org.hibernate.HibernateException: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into EAM_SRN (VERSION_COL, SRN, INSTANCE_ID, APPDEF_TYPE) values (?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update


        at org.hyperic.hq.hibernate.SessionManager$1.doInHibernate(SessionManager.java:88)


        at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)


        ... 15 more


Caused by: org.springframework.dao.DataIntegrityViolationException: Could not execute JDBC batch update; SQL [insert into EAM_SRN (VERSION_COL, SRN, INSTANCE_ID, APPDEF_TYPE) values (?, ?, ?, ?)]; constraint [null]; nested exception is org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update


        at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:637)


        at org.springframework.orm.hibernate3.HibernateTransactionManager.convertHibernateAccessException(HibernateTransactionManager.java:793)


        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:664)


        at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:754)


        at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:723)


        at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:412)


        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)


        at $Proxy69.incrementSrn(Unknown Source)


        at org.hyperic.hq.measurement.server.session.MeasurementProcessorImpl.scheduleMeasurements(MeasurementProcessorImpl.java:247)


        at org.hyperic.hq.measurement.server.session.MeasurementProcessorImpl.scheduleEnabled(MeasurementProcessorImpl.java:222)


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


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


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


        at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)


        at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:80)


        at org.hyperic.hq.monitor.aop.aspects.PerformanceMonitor.monitorServiceMethod(PerformanceMonitor.java:84)


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


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


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


        at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:622)


        at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:611)


        at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:65)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:108)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)


        at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)


        at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)


        at $Proxy77.scheduleEnabled(Unknown Source)


        at org.hyperic.hq.measurement.server.session.AgentScheduleSynchronizer$SchedulerThread$1.run(AgentScheduleSynchronizer.java:313)


        at org.hyperic.hq.hibernate.SessionManager$1.doInHibernate(SessionManager.java:86)


        ... 16 more


Caused by: org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update


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


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


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


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


        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.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338)


        at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106)


        at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:656)


        ... 50 more


Caused by: java.sql.BatchUpdateException: Duplicate entry '14873-1' for key 'PRIMARY'


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


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


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


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


        ... 58 more