Automic SaaS: High System Load and Long-Running Queries During Database Maintenance.

Products

• Automic SaaS
• Automic Automation

Issue/Introduction

 

• Users may observe that their Automic SaaS instances become heavily loaded, accompanied by high CPU utilization.

• System logs reveal time-critical database calls with severely extended execution times.

• Specifically, a SELECT COUNT query running against the OH table is observed executing for over 10 to 11 minutes.

• Under normal circumstances, these database queries should complete in milliseconds.

 

Environment

 

• Automic Automation SaaS

• Version: V24.6 HF5

 

Cause

 

• The heavy load and extended query durations are directly related to the automated database maintenance processes.

• These long-running queries are typically seen triggering daily around 5 AM UTC when DB maintenance tasks such as DB archive, reorg, and Unload are initiated.

• The high database CPU utilization is caused by queries lacking specific optimizations for these maintenance conditions.

 

Resolution

• Temporary Relief: The immediate system load and performance degradation will naturally resolve once the database reorganization and maintenance processes have finished.

• Permanent Fix: Engineering has identified the root cause in DE203720 and implemented a permanent code change to address this defect. Database optimizations have been introduced and validated to ensure the maintenance queries complete in milliseconds.

Component: Utilities

Automic Automation 26.1.0 - TBA