Active IQ Unified Manager 9.7 のポーリングが失敗します
環境
アクティブ IQ Unified Manager 9.7
問題
- Active IQ Unified Manager 9.7 では、クラスタから新しいデータは表示されません。
/var/log/ocum/ocumserver.log
次のエラーが表示されます。
ERROR [oncommand] [org.springframework.jms.listener.DefaultMessageListenerContainer#0-1] [c.n.i.s.r.dao.AcquisitionInfoDao] Data Acquistion Save exception:
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO opm.acquisition_info (time,success,clusterId,analysisDuration,collectionDuration,msgRcvTime,isHistorical) VALUES (?,?,?,?,?,?,?)]; (conn=15) Duplicate entry '1576218002482-1' for key 'PRIMARY'; nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=15) Duplicate entry '1576218002482-1' for key 'PRIMARY'
ERROR [oncommand] [pool-31-thread-1] [c.n.i.s.s.h.d.AggregateHeadroomStatDao] Exception while inserting statistics into netapp_performance.sample_opm_headroom_aggr_1
org.springframework.dao.DuplicateKeyException: PreparedStatementCallback; SQL [INSERT INTO netapp_performance.sample_opm_headroom_aggr_1 (objid,time,`empty`,cOperationalPointAllWorkloads,cOperationalPointInternalWorkloads,isObservationBased,mConfidenceLevel,mOptimalPointLatency,mOptimalPointOps,mOptimalPointUtil,mcOptimalPointLatency,mcOptimalPointOps,mcOptimalPointUtil,oOperationalPointAllWorkloads,oOperationalPointInternalWorkloads,obConfidenceLevel,obOptimalPointLatency,obOptimalPointOps,obOptimalPointUtil,obcOptimalPointLatency,obcOptimalPointOps,obcOptimalPointUtil,serviceTime,cHRoomUsedPercent,cHRoomUsedNoInternalPercent,availableOps) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)]; (conn=15) Duplicate entry '17-1576218002482' for key 'PRIMARY'; nested exception is java.sql.BatchUpdateException: (conn=15) Duplicate entry '17-1576218002482' for key 'PRIMARY