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

Compute Engine processes analysis report slowly when millions of issues

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.7.3, 7.1
    • Component/s: Database, ElasticSearch
    • Labels:
      None

      Description

      The following SQL request can take dozens of seconds (minutes?) when database contains millions of issues:

      SELECT i.kee,
             i.assignee,
             i.line,
             i.resolution,
             i.severity,
             i.status,
             i.effort,
             i.author_login,
             i.issue_close_date,
             i.issue_creation_date,
             i.issue_update_date,
             r.plugin_name,
             r.plugin_rule_key,
             r.language,
             c.uuid,
             c.module_uuid_path,
             c.path,
             c.scope,
             c.organization_uuid,
             c.project_uuid,
             c.main_branch_project_uuid,
             i.tags,
             i.issue_type
        FROM issues i
             INNER JOIN rules r ON r.id = i.rule_id
             INNER JOIN projects c ON c.uuid = i.component_uuid
         AND c.project_uuid = ?
      

      It is executed when compute engine refreshes the Elasticsearch index of issues.

        Attachments

          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: