Flyway Migration fails

[jzielke84]

After migrating from Nexus 3.69.x to 3.74.0.05 startup throws the following error:

2024-11-06 19:20:51,983+0100 ERROR [FelixStartLevel] *SYSTEM org.flywaydb.core.internal.command.DbMigrate - Migration of schema "PUBLIC" with repeatable migration "FileBlobStoreMetricsMigrationStep" failed! Please restore backups and roll back database and code!

First I restored a backup and then checked OrientDB first:

java -jar /opt/nexus/nexus-latest/lib/support/nexus-orient-console.jar
Warning: Nashorn engine is planned to be removed from a future JDK release

OrientDB console v.2.2.37 (build a7541e7ceeabf592dd9a7b2928b6c023cbc73193, branch 2.2.x) https://www.orientdb.com
Type 'help' to display all the supported commands.
orientdb> CONNECT PLOCAL:/var/opt/nexus/db/component admin admin

Connecting to database [PLOCAL:/var/opt/nexus/db/component] with user 'admin'...WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.orientechnologies.common.directmemory.OByteBufferPool (file:/opt/nexus/nexus-3.69.0-02/system/com/orientechnologies/orientdb-core/2.2.37/orientdb-core-2.2.37.jar) to method sun.nio.ch.DirectBuffer.cleaner()
WARNING: Please consider reporting this to the maintainers of com.orientechnologies.common.directmemory.OByteBufferPool
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
OK
orientdb {db=component}> REBUILD INDEX *


Rebuilding index(es)...
Rebuilt index(es). Found 1137675 link(s) in 118.641998 sec(s).


Index(es) rebuilt successfully
orientdb {db=component}> REPAIR DATABASE --fix-graph

Repairing database...
- Removing broken links...
-- Done! Fixed links: 0, modified documents: 0
Repair database complete (0 errors)
orientdb {db=component}> REPAIR DATABASE --fix-links

Repairing database...
- Removing broken links...
-- Done! Fixed links: 0, modified documents: 0
Repair database complete (0 errors)
orientdb {db=component}> REPAIR DATABASE --fix-ridbags

Repairing database...
- Removing broken links...
-- Done! Fixed links: 0, modified documents: 0
Repair database complete (0 errors)
orientdb {db=component}> REPAIR DATABASE --fix-bonsai

Repairing database...
- Removing broken links...
-- Done! Fixed links: 0, modified documents: 0
Repair database complete (0 errors)
orientdb {db=component}> disconnect

Disconnecting from the database [component]...OK
orientdb> exit

So OrientDB seems fine. Then I created a new backup by running the task:

2024-11-06 19:14:12,945+0100 INFO  [quartz-10-thread-5]  *SYSTEM org.sonatype.nexus.internal.backup.orient.DatabaseBackupTask - database backup of config starting
2024-11-06 19:14:12,947+0100 INFO  [quartz-10-thread-5]  *SYSTEM org.sonatype.nexus.internal.backup.orient.DatabaseBackupTask - database backup of component starting
2024-11-06 19:14:12,948+0100 INFO  [quartz-10-thread-5]  *SYSTEM org.sonatype.nexus.internal.backup.orient.DatabaseBackupTask - database backup of security starting
2024-11-06 19:14:12,948+0100 INFO  [quartz-10-thread-5]  *SYSTEM org.sonatype.nexus.internal.backup.orient.DatabaseBackupTask - database backup of analytics starting
2024-11-06 19:14:13,114+0100 INFO  [dbbackup-17-thread-3]  *SYSTEM org.sonatype.nexus.internal.backup.orient.DatabaseBackupRunner - database backup of security completed successfully
2024-11-06 19:14:13,194+0100 INFO  [dbbackup-17-thread-1]  *SYSTEM org.sonatype.nexus.internal.backup.orient.DatabaseBackupRunner - database backup of config completed successfully
2024-11-06 19:14:14,596+0100 INFO  [dbbackup-17-thread-4]  *SYSTEM org.sonatype.nexus.internal.backup.orient.DatabaseBackupRunner - database backup of analytics completed successfully
2024-11-06 19:14:19,241+0100 INFO  [dbbackup-17-thread-2]  *SYSTEM org.sonatype.nexus.internal.backup.orient.DatabaseBackupRunner - database backup of component completed successfully

After that I followed the migration guide using nexus-db-migrator-3.70.3-01.jar:

# java -Xmx16G -Xms16G -XX:+UseG1GC -XX:MaxDirectMemorySize=28672M \
-jar nexus-db-migrator-*.jar \
--migration_type=h2
19:18:16 [main] WARN  c.s.n.d.migrator.MigratorApplication - Please ensure any Nexus Repository instance has been gracefully shut down before proceeding.
19:18:16 [main] INFO  c.s.n.d.migrator.MigratorApplication - Do you want to continue [y/n]?
y
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - --content_migration parameter is absent. Setting it to true.
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - Force parameter wasn't found. Setting it to false by default.
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - ------------------------------------------------------------
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - Java version: Azul Systems, Inc. 11.0.25
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - JVM arguments: -Xmx16G -Xms16G -XX:+UseG1GC -XX:MaxDirectMemorySize=28672M
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - Migrator arguments: --migration_type=h2 --content_migration=true --export_json=false --force=false
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - ------------------------------------------------------------
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - Starting MigratorApplication v3.70.3-01 using Java 11.0.25 on artifacts-01 with PID 13677 (/opt/nexus/migration/nexus-db-migrator-3.70.3-01.jar started by root in /opt/nexus/migration)
19:18:18 [main] INFO  c.s.n.d.migrator.MigratorApplication - No active profile set, falling back to 1 default profile: "default"
Warning: Nashorn engine is planned to be removed from a future JDK release
19:18:21 [main] INFO  o.s.b.c.r.s.JobRepositoryFactoryBean - No database type set, using meta data indicating: H2
19:18:21 [main] INFO  c.s.n.d.migrator.MigratorApplication - Started MigratorApplication in 3.141 seconds (JVM running for 4.903)
19:18:21 [main] INFO  o.s.b.a.b.JobLauncherApplicationRunner - Running default command line with: [--migration_type=h2, --content_migration=true, --export_json=false, --force=false]
19:18:21 [main] INFO  c.s.n.d.m.validator.PathValidator - Validating Orient directory contains .bak files: /opt/nexus/migration
19:18:21 [main] INFO  c.s.n.d.m.validator.PathValidator - Validating Orient directory does not contain database files: /opt/nexus/migration
19:18:21 [main] INFO  c.s.n.d.m.validator.PathValidator - Validating Orient directory contains .bak files: /opt/nexus/migration
19:18:21 [main] INFO  c.s.n.d.m.validator.PathValidator - Validating Orient directory does not contain database files: /opt/nexus/migration
19:18:21 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Migration job started at Wed Nov 06 19:18:21 CET 2024
19:18:21 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [startHealthCheckDeciderStep]
19:18:21 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [startHealthCheckDeciderStep] executed in 12ms
19:18:21 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [unzipArchivesStep]
19:18:21 [main] INFO  c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping /opt/nexus/migration/component-2024-11-06-19-15-01-3.69.0-02.bak to /opt/nexus/migration/component
19:18:25 [main] INFO  c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped /opt/nexus/migration/component-2024-11-06-19-15-01-3.69.0-02.bak successfully
19:18:25 [main] INFO  c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping /opt/nexus/migration/config-2024-11-06-19-15-01-3.69.0-02.bak to /opt/nexus/migration/config
19:18:25 [main] INFO  c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped /opt/nexus/migration/config-2024-11-06-19-15-01-3.69.0-02.bak successfully
19:18:25 [main] INFO  c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping /opt/nexus/migration/security-2024-11-06-19-15-01-3.69.0-02.bak to /opt/nexus/migration/security
19:18:25 [main] INFO  c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped /opt/nexus/migration/security-2024-11-06-19-15-01-3.69.0-02.bak successfully
19:18:25 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [unzipArchivesStep] executed in 4s45ms
19:18:25 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [checkModelVersionsStep]
WARNING: An illegal reflective access operation has occurred
WARNING: Illegal reflective access by com.orientechnologies.common.directmemory.OByteBufferPool (file:/opt/nexus/migration/nexus-db-migrator-3.70.3-01.jar) to method sun.nio.ch.DirectBuffer.cleaner()
WARNING: Please consider reporting this to the maintainers of com.orientechnologies.common.directmemory.OByteBufferPool
WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
WARNING: All illegal access operations will be denied in a future release
19:18:26 [main] WARN  c.s.n.d.m.c.SchemaVersionsValidator - Missing some schema configurations. Suspecting Nexus Repository Manager to be an OSS instance.
19:18:26 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [checkModelVersionsStep] executed in 896ms
19:18:26 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [initDatabaseStep]
19:18:26 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [initDatabaseStep] executed in 304ms
19:18:26 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [processFullDatabase]
19:18:26 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateQuartzJobDetailsStep]
19:18:26 [main] INFO  c.s.n.d.m.p.QuartzJobDetailProcessor - Filtered QuartzJobDetail record Rebuild search index for all repository
19:18:26 [main] INFO  c.s.n.d.m.p.QuartzJobDetailProcessor - Filtered QuartzJobDetail record Storage facet cleanup
19:18:26 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateQuartzJobDetailsStep migrated 17 records, skipped 0 records
19:18:26 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateQuartzJobDetailsStep] executed in 138ms
19:18:26 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateQuartzJobTriggersStep]
19:18:26 [main] INFO  c.s.n.d.m.p.QuartzTriggerProcessor - Filtered QuartzTrigger record Rebuild search index for all repository
19:18:26 [main] INFO  c.s.n.d.m.p.QuartzTriggerProcessor - Filtered QuartzTrigger record Storage facet cleanup
19:18:26 [main] INFO  c.s.n.d.m.p.QuartzTriggerProcessor - Filtered QuartzTrigger record MT_1a8onnhp5960i in state BLOCKED
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateQuartzJobTriggersStep migrated 17 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateQuartzJobTriggersStep] executed in 63ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateQuartzJobCalendarsStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateQuartzJobCalendarsStep migrated 0 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateQuartzJobCalendarsStep] executed in 9ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateUsersStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateUsersStep migrated 10 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateUsersStep] executed in 157ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateUserRoleMappingsStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateUserRoleMappingsStep migrated 10 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateUserRoleMappingsStep] executed in 31ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateAnonymousConfigurationStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateAnonymousConfigurationStep migrated 1 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateAnonymousConfigurationStep] executed in 13ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migratePrivilegesStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migratePrivilegesStep migrated 1 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migratePrivilegesStep] executed in 15ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateRolesStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateRolesStep migrated 13 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateRolesStep] executed in 28ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateEmailConfigurationStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateEmailConfigurationStep migrated 1 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateEmailConfigurationStep] executed in 59ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateHttpClientConfigurationStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateHttpClientConfigurationStep migrated 0 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateHttpClientConfigurationStep] executed in 8ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateRealmConfigurationStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateRealmConfigurationStep migrated 1 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateRealmConfigurationStep] executed in 12ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateDeploymentIdentifierStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateDeploymentIdentifierStep migrated 1 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateDeploymentIdentifierStep] executed in 11ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateScriptsStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateScriptsStep migrated 19 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateScriptsStep] executed in 28ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateHealthCheckConfigurationStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateHealthCheckConfigurationStep migrated 4 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateHealthCheckConfigurationStep] executed in 14ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateLdapConfigurationStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateLdapConfigurationStep migrated 2 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateLdapConfigurationStep] executed in 27ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateCapabilitiesStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateCapabilitiesStep migrated 12 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateCapabilitiesStep] executed in 22ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateCleanupPoliciesStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateCleanupPoliciesStep migrated 16 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateCleanupPoliciesStep] executed in 24ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateContentSelectorsStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateContentSelectorsStep migrated 0 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateContentSelectorsStep] executed in 7ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateApiKeysStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateApiKeysStep migrated 13 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateApiKeysStep] executed in 52ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateRepositoriesStep]
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-jboss maven2-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-jboss' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: docker-proxy docker-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'docker-proxy' to format 'docker'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: grc-proxy docker-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'grc-proxy' to format 'docker'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: microsoft-proxy docker-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'microsoft-proxy' to format 'docker'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-nexus2-releases maven2-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-nexus2-releases' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: docker-hosted docker-hosted
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'docker-hosted' to format 'docker'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-nexus2-snapshots maven2-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-nexus2-snapshots' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: docker-group docker-group
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'docker-group' to format 'docker'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: npm-fontawesome npm-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'npm-fontawesome' to format 'npm'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-nexus2-thirdparty maven2-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-nexus2-thirdparty' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: raw-nexus2-maven-site raw-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'raw-nexus2-maven-site' to format 'raw'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: pypi-proxy pypi-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'pypi-proxy' to format 'pypi'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-releases maven2-hosted
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-releases' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: raw-nexus2-releases raw-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'raw-nexus2-releases' to format 'raw'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: pypi-hosted pypi-hosted
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'pypi-hosted' to format 'pypi'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-snapshots maven2-hosted
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-snapshots' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: raw-releases raw-hosted
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'raw-releases' to format 'raw'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: npm-registry npm-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'npm-registry' to format 'npm'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: pypi-group pypi-group
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'pypi-group' to format 'pypi'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-third-party maven2-hosted
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-third-party' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: raw-snapshots raw-hosted
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'raw-snapshots' to format 'raw'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: npm-hosted npm-hosted
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'npm-hosted' to format 'npm'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-central maven2-proxy
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-central' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: mvn-public maven2-group
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'mvn-public' to format 'maven2'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: raw-all raw-group
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'raw-all' to format 'raw'
19:18:27 [main] INFO  c.s.n.d.m.p.RepositoryProcessor - Processing repository: npm-group npm-group
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'npm-group' to format 'npm'
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateRepositoriesStep migrated 26 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateRepositoriesStep] executed in 51ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateRoutingRulesStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateRoutingRulesStep migrated 0 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateRoutingRulesStep] executed in 6ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateBlobStoresStep]
19:18:27 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateBlobStoresStep migrated 17 records, skipped 0 records
19:18:27 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateBlobStoresStep] executed in 211ms
19:18:27 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateBucketsStep]
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-jboss'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'docker' for repository name 'docker-proxy'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'docker' for repository name 'grc-proxy'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'docker' for repository name 'microsoft-proxy'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-nexus2-releases'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'docker' for repository name 'docker-hosted'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-nexus2-snapshots'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'docker' for repository name 'docker-group'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'npm' for repository name 'npm-fontawesome'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-nexus2-thirdparty'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'raw' for repository name 'raw-nexus2-maven-site'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'pypi' for repository name 'pypi-proxy'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-releases'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'raw' for repository name 'raw-nexus2-releases'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'pypi' for repository name 'pypi-hosted'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-snapshots'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'raw' for repository name 'raw-releases'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'npm' for repository name 'npm-registry'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'pypi' for repository name 'pypi-group'
19:18:27 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-third-party'
19:18:28 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'raw' for repository name 'raw-snapshots'
19:18:28 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'npm' for repository name 'npm-hosted'
19:18:28 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-central'
19:18:28 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'mvn-public'
19:18:28 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'raw' for repository name 'raw-all'
19:18:28 [main] INFO  c.s.n.d.m.utils.RepositoryUtils - Getting format 'npm' for repository name 'npm-group'
19:18:28 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateBucketsStep migrated 26 records, skipped 0 records
19:18:28 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateBucketsStep] executed in 143ms
19:18:28 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateComponentsStep]
19:18:31 [main] INFO  c.s.n.d.m.l.ProcessChunkListener - Step progress: 10480 records processed
19:18:32 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateComponentsStep migrated 30461 records, skipped 0 records
19:18:32 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateComponentsStep] executed in 4s983ms
19:18:32 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateAssetsStep]
19:18:41 [main] INFO  c.s.n.d.m.l.ProcessChunkListener - Step progress: 35040 records processed
19:18:51 [main] INFO  c.s.n.d.m.l.ProcessChunkListener - Step progress: 80010 records processed
19:19:01 [main] INFO  c.s.n.d.m.l.ProcessChunkListener - Step progress: 122010 records processed
19:19:03 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateAssetsStep migrated 136531 records, skipped 0 records
19:19:03 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateAssetsStep] executed in 30s931ms
19:19:03 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateDockerForeignLayersStep]
19:19:03 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateDockerForeignLayersStep migrated 0 records, skipped 0 records
19:19:03 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateDockerForeignLayersStep] executed in 6ms
19:19:03 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateDeletedBlobIndexStep]
19:19:03 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateDeletedBlobIndexStep migrated 0 records, skipped 0 records
19:19:03 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateDeletedBlobIndexStep] executed in 4ms
19:19:03 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateKeyStoreStep]
19:19:03 [main] INFO  c.s.n.d.m.l.ProcessRecordStepListener - migrateKeyStoreStep migrated 2 records, skipped 0 records
19:19:03 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [migrateKeyStoreStep] executed in 9ms
19:19:03 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [processFullDatabase] executed in 37s160ms
19:19:03 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [createRebuildRepositoryTasksStep]
19:19:03 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [createRebuildRepositoryTasksStep] executed in 4ms
19:19:03 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [resetTableSequencesStep]
19:19:04 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [resetTableSequencesStep] executed in 43ms
19:19:04 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [finalDatabaseStep]
19:19:04 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [finalDatabaseStep] executed in 1ms
19:19:04 [main] INFO  o.s.batch.core.job.SimpleStepHandler - Executing step: [checkUserDirectoryStep]
19:19:04 [main] WARN  c.s.n.d.m.t.CheckUserDirectoryTasklet - You must move the H2 database created by the db-migrator to the $data-dir/db directory before starting Nexus Repository Manager.
19:19:04 [main] INFO  o.s.batch.core.step.AbstractStep - Step: [checkUserDirectoryStep] executed in 1ms
19:19:04 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Migration job finished at Wed Nov 06 19:19:04 CET 2024
19:19:04 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Migration job took 42 seconds to execute
19:19:04 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - 167206 records were processed
19:19:04 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - 5 records were filtered
19:19:04 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - 0 records were skipped
19:19:04 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - 167201 records were migrated
19:19:04 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Created 'Rebuild repository browse' and 'Rebuild repository search' tasks. They will automatically one-time run after starting your Nexus Repository instance.
19:19:04 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Migrated the following formats: [APT, COCOAPODS, CONAN, CONDA, DOCKER, GITLFS, GO, HELM, MAVEN2, NPM, NUGET, P2, PYPI, R, RAW, RUBYGEMS, YUM]

But when I startup Nexus with the latest version I get this error. So what's hapening here?

[jzielke84]

Additional Info: Had to run Nexus 3.70.x first, then update to 3.74.x to avoid this bug. This is not mentioned in the migration docs.

[DerBunman]

Additional Info: Had to run Nexus 3.70.x first, then update to 3.74.x to avoid this bug. This is not mentioned in the migration docs.

Thank you very much. This info saved my day!

[lisadurant]

Hello! It seems like you may have missed that Nexus Repository release 3.71.0 introduced major breaking changes that made upgrade paths a little more complex to get to 3.71.0+. We created specific upgrade documentation to help folks get to 3.71.0; those upgrade paths can be found in our help site.

I think you would've needed to use these specific upgrade instructions for those on a pre-3.70.x version using OrientDB. I'm glad that you were ultimately able to upgrade your instance!