SonarQube Analysis takes some times too long

SonarQube Server / Community Build
,
2

Hi, there is a purge mechanism that clean up “old” data. It’s run at the end of each analysis. Criteria for rows to purge are timestamp-based. So at some point, there is nothing to purge, and one day later you could have 300 PR & branches eligible for the purge mechanism, which takes time.

You can enable purge profiling to confirm or deny this hypothesis, and maybe help narrow down the issue. Add the sonar.showProfiling=true property to your sonar.properties & restart SonarQube. Next time a purge happen, you should see logs like this in ce.log:

 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] 
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] -------- Profiling for purge: 81ms --------
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] 
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o deleteCeActivityBefore (ce_task_input): 9ms (11%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o deleteCeActivityBefore (ce_scanner_context): 8ms (9%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o deleteCeActivityBefore (ce_task_message): 8ms (9%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o deleteCeActivityBefore (ce_task_characteristics): 8ms (9%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o deleteCeActivityBefore (ce_activity): 8ms (9%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o updatePurgeStatusToOne (snapshots): 3ms (3%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o deleteAnalysisDuplications (duplications_index): 1ms (1%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o purgeDisabledComponents (file_sources): 1ms (1%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] o purgeDisabledComponents (unresolved_issues): 1ms (1%)
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] 
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner] -------- End of profiling for purge --------
 2020.07.31 12:41:07 INFO ce[AXOkdgQP4WBcbHHv1D0Z][o.s.c.t.p.p.ProjectCleaner]
2 Likes