We use Nexus Repository Manager OSS 3.19.0.1 and face the following error messages when trying to browse any repository with the web browser:
2019-10-28 11:09:28,387+0100 ERROR [qtp1282256464-68] org.sonatype.nexus.extdirect.internal.ExtDirectExceptionHandler - Failed to invoke action method: coreui_Browse.read, java-method: org.sonatype.nexus.coreui.BrowseComponent.read
com.orientechnologies.orient.core.exception.OCommandExecutionException: Error on execution of command: sql.select from browse_node where (repository_name=:repository_name and parent_path=:base_path) limit 10000
DB name=“component”
Our users currently do not complain. Maybe they do not use the “browse”-ability frequently. There seems to be something wrong with the database.
Do you have any suggestions? Is there a way to rebuild the DB “component”?
Thank you.
Regards
APetersen
When starting Nexus OSS the following errors occur:
2019-10-28 13:27:21,856+0100 WARN [quartz-3-thread-2] *SYSTEM org.sonatype.nexus.repository.browse.internal.BrowseNodeManager - Problem generating browse nodes for Asset{metadata=AttachedEntityMetadata{schema=asset, document=#135:45047{bucket:#90:4,format:maven2,last_updated:Mon Oct 28 11:39:33 CET 2019,attributes:[5],component:null,name:de/xxxxx/xxxxx/xxxxx/maven-metadata.xml.sha1,size:40,content_type:text/plain,created_by:system,created_by_ip:system,blob_ref:default@593E0E8D-E37C02BE-8796B0EA-91F578AE-B7EAAF87:1a9a1f27-bf88-4b09-83aa-25e30281ff08,last_downloaded:Wed Mar 20 18:27:40 CET 2019,blob_created:Wed Mar 20 18:27:40 CET 2019,blob_updated:Mon Oct 28 11:39:33 CET 2019} v3}, name=de/xxxxx/xxxxx/xxxxx/maven-metadata.xml.sha1}
com.orientechnologies.orient.core.storage.ORecordDuplicatedException: Cannot index record #83:66315: found duplicated key ‘#135:45047’ in index ‘browse_node_asset_id_idx’ previously assigned to the record #82:66