Hi,
Thanks for the reply. However I do not know what to make of that, I can’t guess which indexes are needed by Nexus. So this remains a little bit of black box magic to me. Nothing can be found on github repo as well, so did some further research and only found this post: Restoring Component db lost all indexes, Nexus oss 3.22.0 - #3 by my.ravisoni
Which shows what indexes should be there (which is for version 3.22, so could be different from 3.33. But taking a little leap of faith here)
Then I found a command to show existing indexes (so that I can compare those 2 lists): select expand(indexes) from metadata:indexmanager
After comparison I found that following indexes are missing (which I will create later on today)
create index bucket_repository_name_idx on bucket (repository_name collate default) UNIQUE
create index component_bucket_name_version_idx on component (bucket, name, version) NOTUNIQUE
create index component_ci_name_ci_idx on component (ci_name collate ci) NOTUNIQUE
create index docker_foreign_layers_digest_idx on docker_foreign_layers (digest collate default) UNIQUE
And showed me these unmentioned indexes (should I remove them? For now I’m going to leave these be. Being too afraid of wrecking my data)
- deleted_blob_index
- ___exportImportRIDMap
- dictionary
Going to try to upgrade later today, and will post the outcome here.