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

Calling `api/user_groups/create` in paralel with same name creates duplicates

    Details

    • Edition:
      Community
    • Production Notes:
      None

      Description

      User creates user groups using web service `api/user_groups/create` in a reaction to an event rather than from UI.

      In some cases same events may come twice in a very short time and two simultaneous calls to API are done, which produce duplicates in a GROUPS table.

      Implementation details:
      For history reasons, when MySQL was still supported, there was a limitation which prevented to set a unique constraint on column >255. Starting from 7.9 that's not the case.

      We can now add a constraint with proper data migration.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Due:
                  Created:
                  Updated: