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

Performance hotspot when background task sends issue notifications

    XMLWordPrintable

    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 (Inactive)
              Reporter:
              simon.brandhof Simon Brandhof (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: