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

IsBlobExist endpoint returns the whole blob info instead of only the content length

    Details

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

      Description

      When docker client sends the "is blob exist" request (in docker push for example) we eventually go to the database and execute a query that returns all fields in order to return an artifact but in fact we only take to content length and returns it to the client.

      the query of get blob globally:

        select distinct  n.repo as itemRepo,n.node_path as itemPath,n.node_name as itemName,n.created as itemCreated,n.modified as itemModified,n.updated as itemUpdated,n.created_by as itemCreatedBy,n.modified_by as itemModifiedBy,n.node_type as itemType,n.bin_length as itemSize,n.node_id as itemId,n.depth as itemDepth,n.sha1_actual as itemActualSha1,n.sha1_original as itemOriginalSha1,n.md5_actual as itemActualMd5,n.md5_original as itemOriginalMd5,n.sha256 as itemSha2  from  nodes n  where (( n.sha256 = 'e617a56c238ed06a0215366a122d19fab0b94b28c1413e2171bbe2f883686e6b' and n.node_type = 1) and(n.repo != 'auto-trashcan' or n.repo is null)) and(n.repo != 'jfrog-support-bundle' or n.repo is null) 

      There are more queries (I think also the query of the heuristics search)

      We would like to return only the content length and repo fields in order the improve performance

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              inbart Inbar Tal
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: