AIQUMクラスタの監視状態がFAILEDと表示される
環境
- Active IQ Unified Manager（AIQUM）9.13以降
- Windows Server
問題
- AIQUMクラスタの監視状態が「failed」と表示される
- 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)
- 上記のエラーは、SnapMirrorRelationshipテーブルが予期しない結果になっているが、その場所が表示されないことを示しています。そのため、MySQLで一般的なログを有効にして場所を確認する必要があります。
- 一般的なクエリログには、
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