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

Fix performance hotspot when loading changelog of issues to support reopening of issues

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.5
    • Component/s: Compute Engine
    • Labels:
    • Edition:
      Community
    • Production Notes:
      None

      Description

      Loading of issue changelog is required to be able to reopen closed issues to their relevant previous status and resolution.

      However, the current implementation seem to be causing Out of Memory errors due to a design which loads all the change log of all the closed issue of a component at once (see INFRA-2444 and INFRA-2454 for OOM stacktrace samples).

      Several possibles axis of improvement (which could be combined):

      • stream changelog data from DB instead of loading them all in memory (see ..)
      • do not load the changelog of all closed issues (maybe only a subset we could identify is required)
      • do not load all the change log of each issue: we only care about some types of changelog entries and the latest ones of those

        Attachments

          Activity

            People

            Assignee:
            sebastien.lesaint Sebastien Lesaint
            Reporter:
            sebastien.lesaint Sebastien Lesaint
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: