Uploaded image for project: 'Dev - Nexus Repo'
  1. Dev - Nexus Repo
  2. NEXUS-34552

Maven2ComponentDAO.deleteComponent can issue slow query during staging move operation

    Details

    • Sprint:
      NXRM Immortals Sprint 40, NXRM Immortals Sprint 41, NXRM Immortals Sprint 42
    • InvestmentLayer:
      customer-driven

      Description

      A staging move operation was made to move a tagged GA maven component to a new repository. The total time of the staging move operation was 33 seconds.

      25 of those seconds were performing operations inside Maven2ComponentDAO.deleteComponent

      2022-08-04 05:43:12,424+0000 DEBUG [qtp1130856736-405152]  example org.sonatype.nexus.content.maven.store.Maven2ComponentDAO.deleteComponent - ==> Parameters: 4667761(Integer)
      2022-08-04 05:43:13,759+0000 DEBUG [periodic-4-thread-1]  *SYSTEM org.sonatype.nexus.content.maven.store.Maven2ComponentDAO.readComponent - ==>  Preparing: SELECT * FROM maven2_component WHERE component_id = ? ;
      2022-08-04 05:43:13,759+0000 DEBUG [periodic-4-thread-1]  *SYSTEM org.sonatype.nexus.content.maven.store.Maven2ComponentDAO.readComponent - ==> Parameters: 4667761(Integer)
      2022-08-04 05:43:13,761+0000 DEBUG [periodic-4-thread-1]  *SYSTEM org.sonatype.nexus.content.maven.store.Maven2ComponentDAO.readComponent - <==      Total: 1
      2022-08-04 05:43:13,761+0000 DEBUG [periodic-4-thread-1]  *SYSTEM org.sonatype.nexus.content.maven.store.Maven2AssetDAO.browseComponentAssets - ==>  Preparing: SELECT * FROM maven2_asset WHERE component_id = ?;
      2022-08-04 05:43:13,762+0000 DEBUG [periodic-4-thread-1]  *SYSTEM org.sonatype.nexus.content.maven.store.Maven2AssetDAO.browseComponentAssets - ==> Parameters: 4667761(Integer)
      2022-08-04 05:43:13,763+0000 DEBUG [periodic-4-thread-1]  *SYSTEM org.sonatype.nexus.content.maven.store.Maven2AssetDAO.browseComponentAssets - <==      Total: 0
       
      ????????????????
       
      2022-08-04 05:43:38,306+0000 DEBUG [qtp1130856736-405152]  example org.sonatype.nexus.content.maven.store.Maven2ComponentDAO.deleteComponent - <==    Updates: 1
      

      Expected

      A delete of a single component and its assets should be extremely fast.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              orudyk Oleksii Rudyk
              Reporter:
              plynch Peter Lynch
              Last Updated By:
              Rich Seddon Rich Seddon
              Team:
              NXRM - Optimus
              Owner:
              Oleksii Rudyk Oleksii Rudyk
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:
                Date of First Response:

                  tigCommentSecurity.panel-title