Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Won't Fix
-
Affects Version/s: 2.14.5
-
Fix Version/s: None
-
Component/s: NuGet
-
Labels:
-
Story Points:2
Description
Newer versions of NuGet make queries with a "NormalizedVersion" field.
https://github.com/NuGet/NuGetGallery/issues/2944
Example:
127.0.0.1 - - [10/Aug/2017:08:18:49 +0100] "GET /nexus/service/local/nuget/barclays-nuget-read/Packages?$filter=(tolower(Id)%20eq%20'microsoft.aspnetcore.razor')%20and%20(NormalizedVersion%20eq%20'1.1.2') HTTP/1.1" 400 238 2744
When Nexus 2.x receives one of these queries it results in an error:
2017-08-10 08:18:49,249+0100 INFO [qtp1368710677-27545] 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 ((LOWER(P.ID) = 'microsoft.aspnetcore.razor') AND (P.NORMALIZEDVERSION = '1.1.2')) ORDER BY P.DOWNLOADCOUNT DESC,P.ID,P.VERSION LIMIT 40
The query is then re-issued by NuGet.exe with just "version", so this isn't visible to the end user. But it creates a ton of log noise, and no doubt slows builds down.
Attachments
Issue Links
- is related to
-
NEXUS-14059 Support Nuget "NormalizedVersion" queries
-
- Refine
-
- mentioned in
-
Page Loading...