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

"My profile" page cannot be displayed when notifications are set on projects that no longer exists

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 4.2
    • Component/s: Notifications
    • Labels:
      None

      Description

      For some reasons, there could be some notifications set on projects that no longer exists. Notifications were not deleted while deleting a project in older versions of SonarQube? Caused by the Backup/Restore feature?

      Anyway, the "My profile" page should be displayed even if such a discrepancy is present.
      Moreover a database migration script should run the following query to do some clean up:

      DELETE FROM PROPERTIES WHERE RESOURCE_ID IS NOT NULL AND RESOURCE_ID NOT IN (SELECT ID FROM PROJECTS)
      

        Attachments

          Activity

            People

            Assignee:
            julien.lancelot Julien Lancelot
            Reporter:
            racodond David Racodon
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: