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

Missing index on nodes_repo_path_checksum

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Affects Version/s: 7.18.3, 7.19.4
    • Fix Version/s: 7.18.8, 7.19.9
    • Component/s: None
    • Labels:
      None
    • Location:
      External

      Description

      We have a scenario where the "nodes_repo_path_checksum" is missing.
      This is critical starting version 7.18 after internal optimizations were done.

      Steps to reproduce:
      1. Install Artifactory 5.4.6 with MySQL.
      2. Upgrade to 5.6.2.
      3. Upgrade to 6.5.9.
      4. Upgrade to 6.8.7.
      5. list the indexes and see "nodes_repo_path_checksum" is missing:

      mysql> SHOW INDEX FROM nodes;
      +-------+------------+--------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
      | Table | Non_unique | Key_name                 | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
      +-------+------------+--------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
      | nodes |          0 | PRIMARY                  |            1 | node_id     | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
      | nodes |          1 | nodes_repo_path_name_idx |            1 | repo        | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
      | nodes |          1 | nodes_repo_path_name_idx |            2 | node_path   | A         |           4 |      255 | NULL   |      | BTREE      |         |               |
      | nodes |          1 | nodes_repo_path_name_idx |            3 | node_name   | A         |           4 |     NULL | NULL   |      | BTREE      |         |               |
      | nodes |          1 | nodes_node_path_idx      |            1 | node_path   | A         |           2 |      255 | NULL   |      | BTREE      |         |               |
      | nodes |          1 | nodes_node_name_idx      |            1 | node_name   | A         |           2 |     NULL | NULL   |      | BTREE      |         |               |
      | nodes |          1 | nodes_sha1_actual_idx    |            1 | sha1_actual | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
      | nodes |          1 | nodes_md5_actual_idx     |            1 | md5_actual  | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
      | nodes |          1 | nodes_sha256_idx         |            1 | sha256      | A         |           2 |     NULL | NULL   | YES  | BTREE      |         |               |
      +-------+------------+--------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
      9 rows in set (0.00 sec)
      

        Attachments

          Activity

              People

              Assignee:
              Unassigned
              Reporter:
              arielk Ariel Kabov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Sync Status

                  Connection: RTFACT Sync
                  RTMID-26030 -
                  ERROR
                  • Last Sync Date: