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

Failing migrating from 7.9 in migration #3607

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 8.4
    • Fix Version/s: 8.9.9
    • Component/s: Database
    • Labels:
      None
    • Edition:
      Community
    • Production Notes:
      None

      Description

      Steps to reproduce:

      1. Start SQ 7.9 with PostgreSQL
      2. Insert any orphan into the "groups_users" table
      3. Migrate SQ to 8.9
      4. Error occurred

      (I was not able to reproduce orphans in a database by user actions)

      Workaround:
      Manually delete orphans in a database and re-run migration.

      Query to find orphans:

      select gu.user_id, gu.group_id from groups_users gu left outer join groups g on gu.group_id = g.id where g.id is null and gu.group_id is not null
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jacek.poreda Jacek Poreda
              Reporter:
              jacek.poreda Jacek Poreda
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: