High memory and CPU utilization in AIQUM due to AIQCASecure database lock issue
Applies to
- Active IQ Unified Manager(AIQUM) 9.12 and above
- All OS platforms
- AIQCASecure
Issue
- CPU and memory use are increasing every day.
- OpenJDK Platform Binary process has high memory usage in the case of Windows
- ConfigAdvisorCLI processes are stuck.
- False ActiveIQ Events are triggered. For example: "Verify That Intercluster Peering Is Up"
/var/log/ocie/recording/AIQCASecureData/collected_log/ConfigAdvisorAIDE/Logs/JobLogs/XXXXXXXXX.log
shows error:Collection from <ONTAP_IP>_<AIQUM>_202311251252.0.files Failed with error - database is locked' Traceback (most recent call last): File "peewee.py", line 3237, in execute_sql sqlite3.OperationalError: database is locked