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)