Uploaded image for project: 'Dev - Nexus Repo'
  1. Dev - Nexus Repo
  2. NEXUS-30997

"GET /nexus/service/extdirect/poll/rapture_State_get" takes longer when roles have many permissions

    Details

      Description

      SYMPTOM:

      With NXRM 3.37 + PostgreSQL, seeing long rapture_State_get elapsed times.

      REPRODUCE STEPS:

      Didn't reproduce with newly installed Nexus, but if a user belongs to many roles and each role has hundreds of permissions, observed Nexus queried "SELECT * FROM privilege WHERE id = ?;" about 1500 times in one rapture_State_get request.
      Also, almost all queries were repeatedly executed with same parameters.

      EXPECTATION:

      Expecting the rapture_State_get completes within a few seconds.
      In one user request, Nexus should cache and reuse the same result, which would avoid unnecessary opening / closing JDBC connections.

      ACTUAL RESULT:

      Similar to NEXUS-15085, org.sonatype.nexus.selector.SelectorManager#browseActive does not use any cache and close the JDBC connection (which might be intentional to always get the latest result from DB though).

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              mshevelov Mykyta Shevelov
              Reporter:
              hosako Hajime Osako
              Last Updated By:
              Hardeep Nagra Hardeep Nagra
              Team:
              NXRM - Sentinels
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response:

                  tigCommentSecurity.panel-title