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

    Details

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

      Description

      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';

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated: