#1355 [HHQ-1987] Duplicate entry 'Sendmail' on create resource

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-1987
After upgrade on server start I see following error. Still investigating if I had a sendmail resource pending in my AIQueue before the upgrade.

2008-04-16 09:22:59,826 ERROR [main] [org.hibernate.util.JDBCExceptionReporter] Duplicate entry 'Sendmail' for key 2


2008-04-16 09:22:59,828 ERROR [main] [org.hibernate.event.def.AbstractFlushingEventListener] 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.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.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.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.AppdefSessionEJB.createAuthzResource(AppdefSessionEJB.java:157)


        at org.hyperic.hq.appdef.server.session.ServerManagerEJBImpl.updateServerTypes(ServerManagerEJBImpl.java:1330)


        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.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.updateServerTypes(Unknown Source)


        at org.hyperic.hq.appdef.server.session.ConfigManagerEJBImpl.updateAppdefEntities(ConfigManagerEJBImpl.java:629)


        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.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 $Proxy231.updateAppdefEntities(Unknown Source)


       at $Proxy231.updateAppdefEntities(Unknown Source)


        at org.hyperic.hq.product.server.session.ProductManagerEJBImpl.deploymentNotify(ProductManagerEJBImpl.java:336)


        at sun.reflect.GeneratedMethodAccessor481.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 $Proxy323.deploymentNotify(Unknown Source)


        at org.hyperic.hq.product.server.mbean.ProductPluginDeployer.deployPlugin(ProductPluginDeployer.java:533)


        at org.hyperic.hq.product.server.mbean.ProductPluginDeployer.handleNotification(ProductPluginDeployer.java:200)


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


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


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


        at org.jboss.mx.notification.NotificationListenerProxy.invoke(NotificationListenerProxy.java:138)


        at $Proxy221.handleNotification(Unknown Source)


        at org.jboss.mx.util.JBossNotificationBroadcasterSupport.handleNotification(JBossNotificationBroadcasterSupport.java:112)


        at org.jboss.mx.util.JBossNotificationBroadcasterSupport.sendNotification(JBossNotificationBroadcasterSupport.java:93)


        at org.jboss.system.server.ServerImpl.sendNotification(ServerImpl.java:879)


        at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:468)


        at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)


        at org.jboss.Main.boot(Main.java:187)


        at org.jboss.Main$1.run(Main.java:438)


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


Caused by: java.sql.BatchUpdateException: Duplicate entry 'Sendmail' for key 2


        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)


        ... 141 more