集群采集耗时较长、并且间歇性轮询处于"失败"状态
适用场景
Active IQ Unified Manager 9.12 (AIQUM)虚拟设备
问题描述
- ONTAP集群采集耗时较长且间歇性的集群轮询状态显示"失败"
- 在ocumserver.log中找到集群的错误
ERROR [oncommand] [reconciliation-0] [<cluster>(baseline@04:00:00.001)] [c.n.dfm.collector.OcieJmsListener] Inventory change listener error
org.springframework.dao.PessimisticLockingFailureException: could not execute batch; 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=?]; nested exception is org.hibernate.PessimisticLockException: could not execute batch
at deployment.dfm-app.war//org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:207)
at deployment.dfm-app.war//org.springframework.orm.hibernate5.SessionFactoryUtils.flush(SessionFactoryUtils.java:120)
Caused by: org.hibernate.PessimisticLockException: could not execute batch
at deployment.dfm-app.war//org.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:547)
at deployment.dfm-app.war//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37)
... 15 common frames omitted
Caused by: java.sql.BatchUpdateException: (conn=43296) Lock wait timeout exceeded; try restarting transaction
at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:323)
at org.mariadb//org.mariadb.jdbc.ClientSidePreparedStatement.executeBatch(ClientSidePreparedStatement.java:301)
at deployment.dfm-app.war//com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:131)
at deployment.dfm-app.war//com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)
at deployment.dfm-app.war//org.hibernate.engine.jdbc.batch.internal.BatchingBatch.performExecution(BatchingBatch.java:125)
... 28 common frames omitted
Caused by: java.sql.SQLTransientConnectionException: (conn=43296) Lock wait timeout exceeded; try restarting transaction
at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
at org.mariadb//org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:153)
at org.mariadb//org.mariadb.jdbc.MariaDbStatement.executeBatchExceptionEpilogue(MariaDbStatement.java:319)
... 32 common frames omitted