CAIQUM-5746: High memory and CPU utilization in AIQUM due to AIQCASecure database lock issue
Issue
- CPU and memory use are increasing every day in AIQUM
- 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