I was hoping I could get some help diagnosing why our SonarQube 8.4.2 Enterprise Edition background task times have suddenly and dramatically increased. Analyses that usually take less than a few minutes have blown out to in excess of 1 hour in some cases. Looking at the compute engine logs indicates the problem is DB-related and in particular the
Purge db log entry is the only one with a noticeably large duration against it e.g.
2021.01.04 09:37:16 INFO ce[AXbMjBcJeNd-A9z1ul4C][o.s.c.t.s.ComputationStepExecutor] Purge db | status=SUCCESS | time=2175105ms ... 2021.01.04 09:00:01 INFO ce[AXbMd_g_eNd-A9z1ul3t][o.s.c.t.s.ComputationStepExecutor] Purge db | status=SUCCESS | time=2451414ms
We are running using an AWS RDS PostgreSQL database. The DB is large, though has an adequate instance type allocated. It would be great if you could provide any advice as to what steps we should take to try and further diagnose and resolve the issue.
Thanks in advance,