Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Explained
    • Affects Version/s: 3.1.0.Final
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None
    • Steps to Reproduce:
      Hide

      My test to reproduce the issue basically spins up 10 threads and each thread will create a realm and then immediately delete that realm. It does this via the admin rest API.

      The test currently does that create/delete cycle 50 times but it's always only 10 active threads at a time.

      You don't actually need the fifty times as (at least for me) it starts happening when the first ten hit the server.

      Show
      My test to reproduce the issue basically spins up 10 threads and each thread will create a realm and then immediately delete that realm. It does this via the admin rest API. The test currently does that create/delete cycle 50 times but it's always only 10 active threads at a time. You don't actually need the fifty times as (at least for me) it starts happening when the first ten hit the server.
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      Description

      If I have multiple realms being created or deleted at the same time via API I am getting a bunch of deadlocks reported by the JDBC driver which causes the requests to fail.

      I've attached both the wildfly log that shows the JDBC errors and a SQL Server Profiler trace that has capture the deadlocks. Almost all the deadlocks are in KEYCLOAK_ROLE. The last couple appear to be in COMPONENT_CONFIG but I'm not sure if that's actually an issue or a side affect of the previous issues.

      I've tested this with Postgres and I don't run into any deadlock issues there so it seems to be strictly an MSSQL problem.

      I also looked at KEYCLOAK-3210 but flipping the parameter doesn't have any affect

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  hmlnarik Hynek Mlnařík
                  Reporter:
                  dbarentine Dane Barentine
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: