Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-20610

Deleting Debian repository after copying the content to different Debian repository results with N/A repository/package type in Storage Summary


    • Type: Bug
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: 6.14.0
    • Fix Version/s: None
    • Component/s: None
    • Labels:


      Problem statement and Impact

      This behavior occurs when creating a Debian repository and copying the deployed content of this repository to a different Debian repository, afterward, triggering “Recalculate Index” on the first repository and deleting it with the “Delete Repository” REST API.

      Steps to reproduce:

      1. Create two Debian repositories “temp” and “main”
      2. Deploy a Debian package to the “temp” repository
      3. “Copy Content” from “temp” repository to “main” repository
      4. Trigger “Recalculate Index” on “temp” repository (wait for it to finish)
      5. Delete the “temp” repository using Delete Repository REST API


      Expected results

      The “temp” repository should be deleted from the “Artifact Repository Browser” and the “Storage Summary”


      Actual results

      The “temp” repository is deleted from the “Artifact Repository Browser”, but displayed in the “Storage Summary” page in Artifactory UI


      As a workaround, you may run the following queries, before proceeding with this workaround, please take a snapshot of the database:


      DELETE FROM stats WHERE node_id IN (SELECT node_id FROM nodes WHERE repo= 'repo-name');

      DELETE FROM watches WHERE node_id IN (SELECT node_id FROM nodes WHERE repo = 'repo-name');

      DELETE FROM node_meta_infos WHERE node_id IN (SELECT node_id FROM nodes WHERE repo = 'repo-name');

      DELETE FROM node_props WHERE node_id IN (SELECT node_id FROM nodes WHERE repo = 'repo-name’);

      DELETE FROM nodes WHERE repo = 'repo-name';




            • Assignee:
              davidp David Pinhas
            • Votes:
              0 Vote for this issue
              2 Start watching this issue


              • Created: