AIQUM cluster monitoring state shows failed
- Views:
- 97
- Visibility:
- Public
- Votes:
- 0
- Category:
- active-iq-unified-manager
- Specialty:
- OM
- Last Updated:
- 10/14/2024, 3:27:15 PM
Applies to
- Active IQ Unified Manager (AIQUM) 9.13+
- Windows Server
Issue
- AIQUM cluster monitoring state shows "failed"
- Error seen in 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)
- Error above shows SnapMirrorRelationship table is the one that is having unexpected result but it doesn't show where, so we have to enable general log in mysql to see where.
- General query log shows:
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