Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-11095

Performance hotspot when background task sends issue notifications

    Details

    • Edition:
      Community
    • Production Notes:
      None

      Description

      The step named "Send issue notifications" in Compute Engine can be very long when processing an analysis report. Duration can be displayed in logs/ce.log by enabling DEBUG logs (set sonar.log.level.ce=DEBUG in conf/sonar.properties). Example of log :

      2018.07.26 10:22:59 DEBUG ce[AWTVrwb-KZf9YbDx-laU][o.s.s.c.t.s.ComputationStepExecutor] Send issue notifications | time=2ms
      

      Hotspot comes from repeated executions of a slow SQL request. Fixing the algorithm is out-of-scope of this ticket, however the SQL request can be much improved (from 2 seconds to few ms).

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                simon.brandhof Simon Brandhof
                Reporter:
                simon.brandhof Simon Brandhof
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: