-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Parked
-
Affects Version/s: 3.4.0
-
Fix Version/s: None
-
Component/s: Database, Scheduled Tasks
-
Labels:
-
Story Points:8
-
Notability:3
Publishing maven indexes against a large repository can run very slowly.
The OrientDb profiler emits a warning when the task is run indicating that the query being run is returning a result set that is too large:
2018-02-23 08:20:16,493-0700 INFO [Thread-41067] *SYSTEM com.orientechnologies.common.profiler.OProfilerStub - $ANSI{green {db=component}} [TIP] Query 'SELECT last_updated AS lastModified, component.group AS groupId, component.name AS artifactId, component.attributes.maven2.baseVersion AS version, component.attributes.maven2.packaging AS packaging, component.attributes.maven2.pom_name AS pom_name, component.attributes.maven2.pom_description AS pom_description, attributes.maven2.classifier AS classifier, name AS path, attributes.content.last_modified AS contentLastModified, size AS contentSize, attributes.checksum.sha1 AS sha1 FROM asset WHERE bucket = #129:1 AND attributes.maven2.asset_kind = "ARTIFACT" AND component IS NOT NULL' returned a result set with more than 10000 records. Check if you really need all these records, or reduce the resultset by using a LIMIT to improve both performance and used RAM