# Upgrade from 3.30.0-01 to 3.34.1 fails

**URL:** <https://community.sonatype.com/t/upgrade-from-3-30-0-01-to-3-34-1-fails/7437>\
**Category:** Sonatype Nexus Repository\
**Tags:** upgrade\
**Created:** [October 7, 2021, 12:58pm UTC](https://community.sonatype.com/t/upgrade-from-3-30-0-01-to-3-34-1-fails/7437 "2021-10-07T12:58:37Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![marco.dekrijger](https://avatars.discourse-cdn.com/v4/letter/m/6a8cbe/32.png) [@marco.dekrijger](https://community.sonatype.com/u/marco.dekrijger)\
**Post date:** [October 11, 2021, 10:50am UTC](https://community.sonatype.com/t/upgrade-from-3-30-0-01-to-3-34-1-fails/7437/8 "2021-10-11T10:50:48Z")

</div>

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](http://community.sonatype.com/t/restoring-component-db-lost-all-indexes-nexus-oss-3-22-0/4767/3)  
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)

```auto
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.

---

_[View the full topic](https://community.sonatype.com/t/upgrade-from-3-30-0-01-to-3-34-1-fails/7437)._