Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-9028 Web service api/projects/delete is too slow
  3. SONAR-9326

Rely on project_uuid to delete issues and issue_changes of a project

    XMLWordPrintable

    Details

    • Type: Sub-task
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.5-M1
    • Component/s: Database, Issues
    • Labels:

      Description

      Currently, when deleting a project, deletion of issues and issue changes rely on column ISSUES.COMPONENT_UUID. As a consequence, multiple SQL requests are sent to delete data from tables ISSUES and ISSUES_CHANGES (one for every 1000 components in the project).

      The number of SQL request could be reduced to just 2 (one per table) if we were relying on ISSUES.PROJECT_UUID instead.

      To avoid having data left over in the database with this new method which have been deleted by the old one, a database migration should be added to ensure no issue has inconsistent COMPONENT_UUID and PROJECT_UUID (note: the case of issues relating to a non existent project or component will most likely have to be handled – with a delete?)

        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: