Summary

The 'Harness Overview Page' failed to load intermittently in the Prod-2 cluster while the critical functionality remained unaffected.

Timeline

Resolution

The high CPU-intensive queries were terminated in the backend database to resume normal operations.

RCA

The Overview dashboard failed to retrieve data from the backend database as the CPU utilisation reached critical levels resulting in significant delays in processing regular queries. We have isolated configurations within the database which in combination with the application’s retry mechanism lead to undue load on the database server leading to an unhealthy state.

Action Items

1. We have modified the database configurations which shows significant promise as per initial observations.
2. We are in the process of moving the queries to horizontally scaled database nodes.
3. More database optimizations are being planned for the application calls