启用 Cloud Agent 时，集群因日志中的重复键条目错误而收集失败

最后更新
另存为PDF

Views:: 35

Visibility:: Public

Votes:: 0

Category:: active-iq-unified-manager

Specialty:: om

Last Updated:

适用于

Active IQ Unified Manager 9.16P2 (AIQUM)
Active IQ Unified Manager 9.18（AIQUM）

问题

当启用 Cloud Agent 收集方式时，Unified Manager 中的集群收集失败。
性能图表显示为平线——未收集到新的性能数据。
查看 ocumserver.log 时会发现 DuplicateKeyException 错误：
2025-11-20 07:56:11,503 ERROR [oncommand] [org.springframework.jms.listener.DefaultMessageListenerContainer#1-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=41092) Duplicate entry '1763639667703-47135' for key 'acquisition_info.PRIMARY'; nested exception is java.sql.SQLIntegrityConstraintViolationException: (conn=41092) Duplicate entry '1763639667703-47135' for key 'acquisition_info.PRIMARY' [...] Caused by: java.sql.SQLIntegrityConstraintViolationException: (conn=41092) Duplicate entry '1763639667703-47135' for key 'acquisition_info.PRIMARY' [...] Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Duplicate entry '1763639667703-47135' for key 'acquisition_info.PRIMARY' [...] Caused by: java.sql.SQLException: Duplicate entry '1763639667703-47135' for key 'acquisition_info.PRIMARY' [...]
其他表（包括 netapp_performance.update_history 和多个 sample_* 表）也可能出现额外的 DuplicateKeyException 错误。
AU 日志（au.log）显示服务器返回大量 HTTP 500 错误。