We have seen in the field that there are instances where many threads make the same expensive query to build the same feed. This can result in exceptions which appear in the nexus.log file similar to the following:
2020-05-31 05:18:34,978+0000 ERROR [qtp2005006583-2386 <command>sql.select from asset where (bucket=#15:0 or bucket=#15:35 or bucket=#15:41 or bucket=#15:67 or bucket=#16:60 or bucket=#15:70 or bucket=#15:72) GROUP BY name ORDER BY attributes.nuget.download_count DESC, component.ci_name ASC, component.version ASC LIMIT 40</command>] *UNKNOWN com.orientechnologies.orient.core.storage.impl.local.paginated.OLocalPaginatedStorage - Exception `38F25406` in storage `plocal:/nexus/nexus-data/db/component`: 2.2.36 (build d3beb772c02098ceaea89779a7afd4b7305d3788, branch 2.2.x) java.lang.OutOfMemoryError: Java heap space
- is related to
-
NEXUS-18749 Nuget V2 group slow performance
-
- Closed
-