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

Intermittent Nuget "Illegal argument" errors resulting in 400 response

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 2.14.4, 2.14.10
    • Fix Version/s: None
    • Component/s: NuGet
    • Story Points:
      0
    • Notability:
      3

      Description

      Seeing Intermittent failures from Nuget calls which results in 400 response

      2018-01-22 21:52:26,218+0100 INFO [qtp383736885-1059] anonymous com.sonatype.nexus.plugins.nuget.rest.NugetGalleryResource - Illegal argument: Problem preparing SQL: SELECT P.*,(P.VERSION=L.AV) AS ISABSOLUTELATESTVERSION,(P.VERSION=L.V) AS ISLATESTVERSION FROM (SELECT ID,MAX_VERSION(VERSION) AS AV,MAX_VERSION(CASEWHEN(ISPRERELEASE,'',VERSION)) AS V FROM PACKAGES WHERE LOCATE(CONCAT(CONCAT(':',REPOSITORYID),':'),?1) GROUP BY ID) AS L INNER JOIN PACKAGES AS P ON L.ID=P.ID WHERE LOCATE(CONCAT(CONCAT(':',REPOSITORYID),':'),?1) AND P.ID = 'Core.Tests.Common' AND (P.DOWNLOADCOUNT < 0 OR (P.DOWNLOADCOUNT = 0 AND (P.ID > 'Core.Tests.Common' OR P.ID = 'Core.Tests.Common' AND P.VERSION > '5.7.160-snapshot'))) ORDER BY P.DOWNLOADCOUNT DESC,P.ID,P.VERSION LIMIT 40

       

      Below is the call related to the above error. It returned a 400 response:

      x.x.x.x - - [22/Jan/2018:21:52:26 +0100] "GET /nexus/service/local/nuget/nuget-all/FindPackagesById?id=%27Core.Tests.Common%27&$orderby=DownloadCount+desc&$skiptoken=0%2C%27Core.Tests.Common%27%2C%275.7.160-snapshot%27 HTTP/1.1" 400 238 34376

      We can also see it working two seconds before. This came from the same IP address. Not seeing any difference with the call above.

      x.x.x.x - - [22/Jan/2018:21:52:24 +0100] "GET /nexus/service/local/nuget/nuget-all/FindPackagesById?id=%27Core.Tests.Common%27&$orderby=DownloadCount+desc&$skiptoken=0%2C%27Core.Tests.Common%27%2C%275.7.160-snapshot%27 HTTP/1.1" 200 101152 32692

      Majority of the call all work fine. These intermittent failures cause issues in automated builds.

       

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            msurani Mahendra Surani
            Last Updated By:
            Rich Seddon Rich Seddon
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Date of First Response:

                tigCommentSecurity.panel-title