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

NuGet FindPackagesById queries may perform slowly possibly leading to general non-responsiveness

    XMLWordPrintable

    Details

    • Story Points:
      3
    • Sprint:
      Formats Team - Sprint 96

      Description

      Below example shows that the NuGet query is taking nearly 5 minutes to respond.

      request.log

      X.X.X.X - - [18/Apr/2017:16:56:44 -0600] "GET /nexus/repository/nuget-group/FindPackagesById()?id='Lds.Stack' HTTP/1.1" 200 11773 289974 "NuGet Client V3/4.1.0 (Microsoft Windows NT 10.0.14393.0, VS Enterprise/15.0)"
      

      nexus.log

      2017-04-18 16:52:01,389-0600 INFO [qtp28210637-2666] *UNKNOWN com.orientechnologies.common.profiler.OProfilerStub - $ANSI{green {db=component}} [TIP] Query 'SELECT FROM asset WHERE (LOWER(component.name) = "lds.stack" ) AND (bucket = #11:0 OR bucket = #11:1 OR bucket = #11:47 ) ORDER BY attributes.nuget.download_count DESC, id ASC, version ASC LIMIT 40' fetched more than 50000 records: to speed up the execution, create an index or change the query to use an existent index
      

      With many of theses type of request, causes Nexus hang and requires restart to recover. This issue is related to NEXUS-12337 where a fix is included in Nexus 3.3. Unfortunately it has not resolved this issue.

      Cause

      The internal database queries backing the NuGet queries are being slowed down by the lowercasing of the Nuget package name, bypassing some important database indexes.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jstephens Joseph Stephens
              Reporter:
              msurani Mahendra Surani
              Last Updated By:
              Peter Lynch
              Team:
              Nexus - Formats
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response:

                  tigCommentSecurity.panel-title