OSS "A Database Error Occurred" when trying to browse a repository

thank you for having me here.

We use Nexus Repository Manager OSS 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.

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

Partially the browse-function seems to work again:

  • I performed a full restore
  • I added a delete task which deletes old entries from our “snapshot”-repository
  • I deleted some “proxy”-repos and recreated them on a new blobstore (prior all repositories were stored in the “default”-blobstore)

The error messages “ORecordDuplicatedException” still remain.

This is a community forum… seems like it would be more appropriate for this to file a bug at https://issue.sonatype.org in the “dev - nexus” project?