AIQUM集群监控状态显示failed
适用场景
- Active IQ Unified Manager (AIQUM) 9.13及更高版本
- Windows Server
问题描述
- AIQUM集群监控状态显示"失败"
- 在ocumserver.log中出现错误
2024-08-01 12:53:43,987 ERROR [oncommand] [reconciliation-6] [10.10.130.56(incremental@13:48:47.640)] [c.n.dfm.collector.OcieJmsListener] Inventory change listener error org.springframework.orm.hibernate5.HibernateOptimisticLockingFailureException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update SnapMirrorRelationship set lastSuccessfulTransferDuration=?, lastSuccessfulTransferEndTimestamp=?, lastSuccessfulTransferSize=? where id=? and lastSuccessfulTransferDuration=? and lastSuccessfulTransferEndTimestamp=? and lastSuccessfulTransferSize=?; nested exception is org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update SnapMirrorRelationship set lastSuccessfulTransferDuration=?, lastSuccessfulTransferEndTimestamp=?, lastSuccessfulTransferSize=? where id=? and lastSuccessfulTransferDuration=? and lastSuccessfulTransferEndTimestamp=? and lastSuccessfulTransferSize=?
at deployment.dfm-app.war//org.springframework.orm.hibernate5.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:254)
....
Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: update SnapMirrorRelationship set lastSuccessfulTransferDuration=?, lastSuccessfulTransferEndTimestamp=?, lastSuccessfulTransferSize=? where id=? and lastSuccessfulTransferDuration=? and lastSuccessfulTransferEndTimestamp=? and lastSuccessfulTransferSize=?
at deployment.dfm-app.war//org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:67)
- 上面的错误显示SnapMirirorRelationship表是具有意外结果的表，但它不显示位置，因此我们必须在myql中启用常规日志以查看位置。
- 常规查询日志显示：
2024-09-03T17:08:06.338903Z 14663 Query update SnapMirrorRelationship set lastSuccessfulTransferDuration=33, lastSuccessfulTransferEndTimestamp='2024-09-03 09:30:33', lastSuccessfulTransferSize=3912360 where id=40285 and lastSuccessfulTransferDuration=8 and lastSuccessfulTransferEndTimestamp='2024-06-19 09:30:08' and lastSuccessfulTransferSize=343705