Uploaded image for project: 'Keycloak'
  1. Keycloak
  2. KEYCLOAK-8183

Database is repeatedly queried for resource server if client has authz not enabled

    XMLWordPrintable

    Details

    • Sprint:
      Keycloak Sprint 11
    • Story Points:
      1
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      Description

      When accessing user list in admin GUI, there is as many following queries as there are returned users:

          select
              resourcese0_.ID as ID1_64_0_,
              resourcese0_.ALLOW_RS_REMOTE_MGMT as ALLOW_RS2_64_0_,
              resourcese0_.POLICY_ENFORCE_MODE as POLICY_E3_64_0_
          from
              RESOURCE_SERVER resourcese0_
          where
              resourcese0_.ID=?
      

      Reason is that subclasses of org.keycloak.models.cache.infinispan.authorization.StoreFactoryCacheSession do not distinguish between state "model not found" and "model not yet searched for" in findById methods. That means that even after the model is searched for, and not found, it is searched for again upon next querying.

      Reference: KEYCLOAK-8150, http://lists.jboss.org/pipermail/keycloak-dev/2018-August/011183.html

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  hmlnarik Hynek Mlnařík
                  Reporter:
                  hmlnarik Hynek Mlnařík
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: