freshserverの後にserver.logでStaleStateExceptionが見つかりました
環境
AIQUM 9.x
問題
stalestateexception
見つかった場所 jboss\server.log
[stderr] (pool-16-thread-342) Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update Event set acknowledgedBy=?, acknowledgedTimestamp=?, assignedTimestamp=?, assignedTo=?, cluster_id=?, clusterNode_id=?, encodedArguments=?, impactArea=?, isChecked=?, isContinuous=?, lastObservedTime=?, maintenance=?, notesCount=?, objVersion=?, obsoleteCause=?, obsoleteCauseEncodedArguments=?, obsoleteCauseEvent_id=?, obsoleteCauseValue_id=?, obsoleteTimestamp=?, resolvedBy=?, resolvedTimestamp=?, source_id=?, source_type=?, source_fullName=?, source_resourceKey=?, source_resourceType=?, state=?, subType=?, targetId=?, targetType=?, thresholdPolicyId=?, eventTimestamp=?, uuid=?, value_id=?, vserver_id=? where id=? and objVersion=?
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:67)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:54)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.engine.jdbc.batch.internal.BatchingBatch.checkRowCounts(BatchingBatch.java:155)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:130)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.engine.jdbc.batch.internal.BatchingBatch.doExecuteBatch(BatchingBatch.java:110)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.execute(AbstractBatchImpl.java:153)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.executeBatch(JdbcCoordinatorImpl.java:198)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:633)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478)
[stderr] (pool-16-thread-342) at java.base/java.util.LinkedHashMap.forEach(LinkedHashMap.java:684)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1407)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1394)
[stderr] (pool-16-thread-342) at jdk.internal.reflect.GeneratedMethodAccessor194.invoke(Unknown Source)
[stderr] (pool-16-thread-342) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
[stderr] (pool-16-thread-342) at java.base/java.lang.reflect.Method.invoke(Method.java:566)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//com.netapp.dfm.persist.hibernate.HibernateSessionProxyFactoryBean$HibernateSessionInvocationHandler.invoke(HibernateSessionProxyFactoryBean.java:93)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//com.sun.proxy.$Proxy405.flush(Unknown Source)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//com.netapp.dfm.entity.platform.event.EventEntityManager.createAndSaveEventsFromResolvedEventSpecs(EventEntityManager.java:1512)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//com.netapp.dfm.entity.platform.event.EventEntityManager.createAndSaveEventsFromResolvedEventSpecs(EventEntityManager.java:1492)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//com.netapp.dfm.entity.platform.event.EventEntityManager.createAndSaveEventWithSession(EventEntityManager.java:1377)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//com.netapp.dfm.entity.platform.event.EventEntityManager.createAndSaveEvent(EventEntityManager.java:1307)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//com.netapp.dfm.entity.platform.event.EventEntityManager$$FastClassBySpringCGLIB$$f2a1c54.invoke(<generated>)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:793)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:763)
[stderr] (pool-16-thread-342) at deployment.dfm-app.war//org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:137)
[stderr] (pool-16-thread-342) ... 30 more
(pool-16-thread-341) HHH000315: Exception executing batch [java.sql.BatchUpdateException: (conn=14383) Deadlock found when trying to get lock; try restarting transaction], SQL: update Event set acknowledgedBy=?, acknowledgedTimestamp=?, assignedTimestamp=?, assignedTo=?, cluster_id=?, clusterNode_id=?, encodedArguments=?, impactArea=?, isChecked=?, isContinuous=?, lastObservedTime=?, maintenance=?, notesCount=?, objVersion=?, obsoleteCause=?, obsoleteCauseEncodedArguments=?, obsoleteCauseEvent_id=?, obsoleteCauseValue_id=?, obsoleteTimestamp=?, resolvedBy=?, resolvedTimestamp=?, source_id=?, source_type=?, source_fullName=?, source_resourceKey=?, source_resourceType=?, state=?, subType=?, targetId=?, targetType=?, thresholdPolicyId=?, eventTimestamp=?, uuid=?, value_id=?, vserver_id=? where id=? and objVersion=?
(pool-16-thread-341) (conn=14383) Deadlock found when trying to get lock; try restarting transaction