Uploaded image for project: 'RH-SSO'
  1. RH-SSO
  2. RHSSO-2520

MySQL / MariaDB: DELETE user api uses inefficient SQL queries while deleting data from OFFLINE_CLIENT_SESSION

    XMLWordPrintable

Details

    Description

      See https://github.com/keycloak/keycloak/issues/12523 which was fixed for Keycloak 21.

      On MariaDB / MySQL Upon DELETE USER api is used to delete a user, it looks like following SQL query is executed to delete offline session details from OFFLINE_CLIENT_SESSION table.

      This issue is caused by MySQL / MariaDB way of treating subselects, and the Keycloak / RHSSO fix is a workaround specifically for this case.

      Attachments

        Activity

          People

            hmlnarik@redhat.com Hynek Mlnařík
            hmlnarik@redhat.com Hynek Mlnařík
            Hynek Mlnařík
            Votes:
            1 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: