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

Deadlock faced on GROUP_ROLES table

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 5.0, 5.1
    • Fix Version/s: 5.6
    • Component/s: Database
    • Labels:
    • Environment:
      MySQL 5.6.25

      Description

      ### Error updating database.  Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
      ### The error may involve org.sonar.core.user.RoleMapper.insertGroupRole-Inline
      ### The error occurred while setting parameters
      ### SQL: INSERT INTO group_roles (group_id, resource_id, role)     VALUES (?, ?, ?)
      ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              simon.brandhof Simon Brandhof (Inactive)
              Reporter:
              jean-denis.coffre Jean-Denis Coffre
              Votes:
              1 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Due:
                Created:
                Updated:
                Resolved: