simonecarlax
commented
4 days ago Same here.
Command line:
java -Xmx16G -Xms16G -XX:+UseG1GC -XX:MaxDirectMemorySize=28672M -jar nexus-db-migrator-3.70.2-01.jar --migration_type=h2 --content_migration=false --shutdown_compact=falseOutput logs:
12:55:05 [main] WARN c.s.n.d.migrator.MigratorApplication - Please ensure any Nexus Repository instance has been gracefully shut down before proceeding.
12:55:05 [main] INFO c.s.n.d.migrator.MigratorApplication - Do you want to continue [y/n]?
12:55:13 [main] INFO c.s.n.d.migrator.MigratorApplication - Force parameter wasn't found. Setting it to false by default.
12:55:13 [main] INFO c.s.n.d.migrator.MigratorApplication - ------------------------------------------------------------
12:55:13 [main] INFO c.s.n.d.migrator.MigratorApplication - Java version: Azul Systems, Inc. 11.0.22
12:55:13 [main] INFO c.s.n.d.migrator.MigratorApplication - JVM arguments: -Xmx16G -Xms16G -XX:+UseG1GC -XX:MaxDirectMemorySize=28672M
12:55:13 [main] INFO c.s.n.d.migrator.MigratorApplication - Migrator arguments: --migration_type=h2 --content_migration=false --shutdown_compact=false --export_json=false --force=false
12:55:13 [main] INFO c.s.n.d.migrator.MigratorApplication - ------------------------------------------------------------
12:55:13 [main] INFO c.s.n.d.migrator.MigratorApplication - Starting MigratorApplication v3.70.2-01 using Java 11.0.22 on denver with PID 4572 (F:\ExportDB250924\nexus-db-migrator-3.70.2-01.jar started by abonacci.ita in F:\ExportDB250924)
12:55:13 [main] INFO c.s.n.d.migrator.MigratorApplication - No active profile set, falling back to 1 default profile: "default"
12:55:15 [main] INFO o.s.b.c.r.s.JobRepositoryFactoryBean - No database type set, using meta data indicating: H2
12:55:15 [main] INFO c.s.n.d.migrator.MigratorApplication - Started MigratorApplication in 2.017 seconds (JVM running for 10.225)
12:55:15 [main] INFO o.s.b.a.b.JobLauncherApplicationRunner - Running default command line with: [--migration_type=h2, --content_migration=false, --shutdown_compact=false, --export_json=false, --force=false]
12:55:15 [main] INFO c.s.n.d.m.validator.PathValidator - Validating Orient directory contains .bak files: F:\ExportDB250924
12:55:15 [main] INFO c.s.n.d.m.validator.PathValidator - Validating Orient directory does not contain database files: F:\ExportDB250924
12:55:15 [main] INFO c.s.n.d.m.validator.PathValidator - Validating Orient directory contains .bak files: F:\ExportDB250924
12:55:15 [main] INFO c.s.n.d.m.validator.PathValidator - Validating Orient directory does not contain database files: F:\ExportDB250924
12:55:15 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Migration job started at Wed Sep 25 12:55:15 CEST 2024
12:55:15 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [startHealthCheckDeciderStep]
12:55:15 [main] INFO o.s.batch.core.step.AbstractStep - Step: [startHealthCheckDeciderStep] executed in 8ms
12:55:15 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [unzipArchivesStep]
12:55:15 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping F:\ExportDB250924\component-2024-09-25-10-11-13-3.70.2-01.bak to F:\ExportDB250924\component
12:55:19 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped F:\ExportDB250924\component-2024-09-25-10-11-13-3.70.2-01.bak successfully
12:55:19 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping F:\ExportDB250924\config-2024-09-25-10-11-13-3.70.2-01.bak to F:\ExportDB250924\config
12:55:20 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped F:\ExportDB250924\config-2024-09-25-10-11-13-3.70.2-01.bak successfully
12:55:20 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipping F:\ExportDB250924\security-2024-09-25-10-11-13-3.70.2-01.bak to F:\ExportDB250924\security
12:55:20 [main] INFO c.s.n.d.m.t.UnzipArchivesTasklet - Unzipped F:\ExportDB250924\security-2024-09-25-10-11-13-3.70.2-01.bak successfully
12:55:20 [main] INFO o.s.batch.core.step.AbstractStep - Step: [unzipArchivesStep] executed in 4s621ms
12:55:20 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [checkModelVersionsStep]
12:55:21 [main] WARN c.s.n.d.m.c.SchemaVersionsValidator - Missing some schema configurations. Suspecting Nexus Repository Manager to be an OSS instance.
12:55:21 [main] INFO o.s.batch.core.step.AbstractStep - Step: [checkModelVersionsStep] executed in 1s298ms
12:55:21 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [initDatabaseStep]
12:55:21 [main] INFO o.s.batch.core.step.AbstractStep - Step: [initDatabaseStep] executed in 58ms
12:55:21 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [processFullDatabase]
12:55:21 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateQuartzJobDetailsStep]
12:55:21 [main] INFO c.s.n.d.m.p.QuartzJobDetailProcessor - Filtered QuartzJobDetail record Statistics - recalculate vulnerabilities statistics
12:55:21 [main] INFO c.s.n.d.m.p.QuartzJobDetailProcessor - Filtered QuartzJobDetail record Storage facet cleanup
12:55:21 [main] INFO c.s.n.d.m.p.QuartzJobDetailProcessor - Filtered QuartzJobDetail record Cleanup service
12:55:21 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateQuartzJobDetailsStep migrated 13 records, skipped 0 records
12:55:21 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateQuartzJobDetailsStep] executed in 135ms
12:55:21 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateQuartzJobTriggersStep]
12:55:21 [main] INFO c.s.n.d.m.p.QuartzTriggerProcessor - Filtered QuartzTrigger record Statistics - recalculate vulnerabilities statistics
12:55:21 [main] INFO c.s.n.d.m.p.QuartzTriggerProcessor - Filtered QuartzTrigger record Cleanup service
12:55:21 [main] INFO c.s.n.d.m.p.QuartzTriggerProcessor - Filtered QuartzTrigger record Storage facet cleanup
12:55:21 [main] INFO c.s.n.d.m.p.QuartzTriggerProcessor - Filtered QuartzTrigger record MT_189fm64j8e5bp in state BLOCKED
12:55:21 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateQuartzJobTriggersStep migrated 13 records, skipped 0 records
12:55:21 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateQuartzJobTriggersStep] executed in 42ms
12:55:21 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateQuartzJobCalendarsStep]
12:55:21 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateQuartzJobCalendarsStep migrated 0 records, skipped 0 records
12:55:21 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateQuartzJobCalendarsStep] executed in 9ms
12:55:21 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateUsersStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateUsersStep migrated 3 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateUsersStep] executed in 428ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateUserRoleMappingsStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateUserRoleMappingsStep migrated 5 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateUserRoleMappingsStep] executed in 15ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateAnonymousConfigurationStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateAnonymousConfigurationStep migrated 1 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateAnonymousConfigurationStep] executed in 8ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migratePrivilegesStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migratePrivilegesStep migrated 0 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migratePrivilegesStep] executed in 4ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateRolesStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateRolesStep migrated 18 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateRolesStep] executed in 18ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateEmailConfigurationStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateEmailConfigurationStep migrated 1 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateEmailConfigurationStep] executed in 65ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateHttpClientConfigurationStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateHttpClientConfigurationStep migrated 1 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateHttpClientConfigurationStep] executed in 12ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateRealmConfigurationStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateRealmConfigurationStep migrated 1 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateRealmConfigurationStep] executed in 8ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateDeploymentIdentifierStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateDeploymentIdentifierStep migrated 1 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateDeploymentIdentifierStep] executed in 7ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateScriptsStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateScriptsStep migrated 0 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateScriptsStep] executed in 4ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateHealthCheckConfigurationStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateHealthCheckConfigurationStep migrated 14 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateHealthCheckConfigurationStep] executed in 14ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateLdapConfigurationStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateLdapConfigurationStep migrated 1 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateLdapConfigurationStep] executed in 19ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateCapabilitiesStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateCapabilitiesStep migrated 10 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateCapabilitiesStep] executed in 13ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateCleanupPoliciesStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateCleanupPoliciesStep migrated 0 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateCleanupPoliciesStep] executed in 4ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateContentSelectorsStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateContentSelectorsStep migrated 0 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateContentSelectorsStep] executed in 5ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateApiKeysStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateApiKeysStep migrated 81 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateApiKeysStep] executed in 78ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateRepositoriesStep]
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: npm-hosted npm-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'npm-hosted' to format 'npm'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: npm-proxy npm-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'npm-proxy' to format 'npm'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: maven-releases maven2-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'maven-releases' to format 'maven2'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: nuget.org-proxy nuget-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'nuget.org-proxy' to format 'nuget'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: maven2-central maven2-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'maven2-central' to format 'maven2'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: bower-proxy bower-proxy
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Filtered bower-proxy Repository record RepositoryRecord(name=bower-proxy, recipeName=bower-proxy, online=true, routingRuleId=null, attributes={proxy={contentMaxAge=1440.0, remoteUrl=https://registry.bower.io, metadataMaxAge=1440.0}, negativeCache={timeToLive=1440.0, enabled=true}, cleanup={policyName=[None]}, storage={strictContentTypeValidation=true, blobStoreName=bower-proxy}, bower={rewritePackageUrls=true}, httpclient={blocked=false, connection={useTrustStore=false}, autoBlock=true}, routingRules={routingRuleId=null}}), Reason - Unsupported format
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding filtered repository name 'bower-proxy'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: pypi-proxy pypi-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'pypi-proxy' to format 'pypi'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: composer-proxy composer-proxy
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Filtered composer-proxy Repository record RepositoryRecord(name=composer-proxy, recipeName=composer-proxy, online=true, routingRuleId=null, attributes={proxy={contentMaxAge=1440.0, remoteUrl=https://packagist.org/, metadataMaxAge=1440.0}, negativeCache={timeToLive=1440.0, enabled=true}, storage={strictContentTypeValidation=true, blobStoreName=composer-proxy}, httpclient={blocked=false, connection={useTrustStore=true}, autoBlock=true}}), Reason - Unsupported format
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding filtered repository name 'composer-proxy'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: nuget.org-proxy-v3 nuget-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'nuget.org-proxy-v3' to format 'nuget'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: clojure-release maven2-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'clojure-release' to format 'maven2'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: devops-docker-hosted docker-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'devops-docker-hosted' to format 'docker'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: docker-hosted docker-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'docker-hosted' to format 'docker'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: maven-snapshot maven2-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'maven-snapshot' to format 'maven2'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: nuget-hosted nuget-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'nuget-hosted' to format 'nuget'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: bower-hosted bower-hosted
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Filtered bower-hosted Repository record RepositoryRecord(name=bower-hosted, recipeName=bower-hosted, online=true, routingRuleId=null, attributes={cleanup={policyName=[None]}, storage={strictContentTypeValidation=true, writePolicy=ALLOW, blobStoreName=bower-hosted}}), Reason - Unsupported format
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding filtered repository name 'bower-hosted'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: pypi-hosted pypi-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'pypi-hosted' to format 'pypi'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: conda-forge-proxy conda-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'conda-forge-proxy' to format 'conda'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: composer-hosted composer-hosted
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Filtered composer-hosted Repository record RepositoryRecord(name=composer-hosted, recipeName=composer-hosted, online=true, routingRuleId=null, attributes={component={proprietaryComponents=false}, storage={strictContentTypeValidation=true, writePolicy=ALLOW, blobStoreName=composer-hosted}}), Reason - Unsupported format
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding filtered repository name 'composer-hosted'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: nuget-group-v3 nuget-group
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'nuget-group-v3' to format 'nuget'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: clojure-snapshot maven2-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'clojure-snapshot' to format 'maven2'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: devops-maven-hosted maven2-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'devops-maven-hosted' to format 'maven2'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: nuget-group nuget-group
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'nuget-group' to format 'nuget'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: bower-group bower-group
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Filtered bower-group Repository record RepositoryRecord(name=bower-group, recipeName=bower-group, online=true, routingRuleId=null, attributes={storage={strictContentTypeValidation=true, blobStoreName=bower-group}, group={memberNames=[bower-proxy, bower-hosted]}}), Reason - Unsupported format
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding filtered repository name 'bower-group'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: raw-hosted raw-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'raw-hosted' to format 'raw'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: pypi-group pypi-group
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'pypi-group' to format 'pypi'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: anaconda-proxy conda-proxy
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'anaconda-proxy' to format 'conda'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: composer-group composer-group
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Filtered composer-group Repository record RepositoryRecord(name=composer-group, recipeName=composer-group, online=true, routingRuleId=null, attributes={storage={strictContentTypeValidation=true, blobStoreName=composer-group}, group={memberNames=[composer-proxy, composer-hosted]}}), Reason - Unsupported format
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding filtered repository name 'composer-group'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: clojure-public maven2-group
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'clojure-public' to format 'maven2'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: devops-npm-hosted npm-hosted
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'devops-npm-hosted' to format 'npm'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: maven-public maven2-group
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'maven-public' to format 'maven2'
12:55:22 [main] INFO c.s.n.d.m.p.RepositoryProcessor - Processing repository: npm-group npm-group
12:55:22 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Adding repository name 'npm-group' to format 'npm'
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateRepositoriesStep migrated 25 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateRepositoriesStep] executed in 81ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateRoutingRulesStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateRoutingRulesStep migrated 0 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateRoutingRulesStep] executed in 4ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateBlobStoresStep]
12:55:22 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateBlobStoresStep migrated 32 records, skipped 0 records
12:55:22 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateBlobStoresStep] executed in 82ms
12:55:22 [main] INFO o.s.batch.core.job.SimpleStepHandler - Executing step: [migrateBucketsStep]
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'npm' for repository name 'npm-hosted'
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'npm' for repository name 'npm-proxy'
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'maven-releases'
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'nuget' for repository name 'nuget.org-proxy'
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'maven2-central'
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'null' for repository name 'bower-proxy'
12:55:23 [main] INFO c.s.n.d.m.p.c.ContentRepositoryProcessor - Filtered bower-proxy ContentRepository record ContentRepositoryRecord(repositoryName=bower-proxy, attributes={}), Reason - Unsupported format or already filtered repository
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'pypi' for repository name 'pypi-proxy'
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'null' for repository name 'composer-proxy'
12:55:23 [main] INFO c.s.n.d.m.p.c.ContentRepositoryProcessor - Filtered composer-proxy ContentRepository record ContentRepositoryRecord(repositoryName=composer-proxy, attributes={}), Reason - Unsupported format or already filtered repository
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'nuget' for repository name 'nuget.org-proxy-v3'
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'maven2' for repository name 'clojure-release'
12:55:23 [main] INFO c.s.n.d.m.utils.RepositoryUtils - Getting format 'npm' for repository name 'npm-hosted'
12:55:23 [main] ERROR o.s.batch.core.step.AbstractStep - Encountered an error executing step migrateBucketsStep in job migrationFromOrientNoExportJSONJob
org.springframework.retry.ExhaustedRetryException: Retry exhausted after last attempt in recovery path, but exception is not skippable.; nested exception is org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO pypi_content_repository (repository_id, config_repository_id, attributes)
VALUES (?, ?, stringtoutf8(?));
]; nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "PYPI_CONTENT_REPOSITORY" not found; SQL statement:
INSERT INTO pypi_content_repository (repository_id, config_repository_id, attributes)
VALUES (?, ?, stringtoutf8(?));
[42102-224]
at org.springframework.batch.core.step.item.FaultTolerantChunkProcessor$5.recover(FaultTolerantChunkProcessor.java:429)
at org.springframework.retry.support.RetryTemplate.handleRetryExhausted(RetryTemplate.java:539)
at org.springframework.retry.support.RetryTemplate.doExecute(RetryTemplate.java:387)
at org.springframework.retry.support.RetryTemplate.execute(RetryTemplate.java:255)
at org.springframework.batch.core.step.item.BatchRetryTemplate.execute(BatchRetryTemplate.java:217)
at org.springframework.batch.core.step.item.FaultTolerantChunkProcessor.write(FaultTolerantChunkProcessor.java:444)
at org.springframework.batch.core.step.item.SimpleChunkProcessor.process(SimpleChunkProcessor.java:217)
at org.springframework.batch.core.step.item.ChunkOrientedTasklet.execute(ChunkOrientedTasklet.java:77)
at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:407)
at org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:331)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140)
at org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:273)
at org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:82)
at org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:375)
at org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)
at org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:145)
at org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:258)
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208)
at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:152)
at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:68)
at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:68)
at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169)
at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144)
at org.springframework.batch.core.job.flow.FlowStep.doExecute(FlowStep.java:92)
at org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:208)
at org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:152)
at org.springframework.batch.core.job.flow.JobFlowExecutor.executeStep(JobFlowExecutor.java:68)
at org.springframework.batch.core.job.flow.support.state.StepState.handle(StepState.java:68)
at org.springframework.batch.core.job.flow.support.SimpleFlow.resume(SimpleFlow.java:169)
at org.springframework.batch.core.job.flow.support.SimpleFlow.start(SimpleFlow.java:144)
at org.springframework.batch.core.job.flow.FlowJob.doExecute(FlowJob.java:139)
at org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:320)
at org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:149)
at org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)
at org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:140)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:128)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:220)
at com.sun.proxy.$Proxy62.run(Unknown Source)
at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.execute(JobLauncherApplicationRunner.java:199)
at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.executeLocalJobs(JobLauncherApplicationRunner.java:173)
at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.launchJobFromProperties(JobLauncherApplicationRunner.java:160)
at org.springframework.boot.autoconfigure.batch.JobLauncherApplicationRunner.run(JobLauncherApplicationRunner.java:155)
at com.sonatype.nexus.db.migrator.config.MigratorJobLauncherApplicationRunner.run(MigratorJobLauncherApplicationRunner.java:38)
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:773)
at org.springframework.boot.SpringApplication.callRunners(SpringApplication.java:763)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:314)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306)
at com.sonatype.nexus.db.migrator.MigratorApplication.main(MigratorApplication.java:117)
Caused by: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [INSERT INTO pypi_content_repository (repository_id, config_repository_id, attributes)
VALUES (?, ?, stringtoutf8(?));
]; nested exception is org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "PYPI_CONTENT_REPOSITORY" not found; SQL statement:
INSERT INTO pypi_content_repository (repository_id, config_repository_id, attributes)
VALUES (?, ?, stringtoutf8(?));
[42102-224]
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:239)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:70)
at org.springframework.jdbc.core.JdbcTemplate.translateException(JdbcTemplate.java:1541)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:667)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:691)
at org.springframework.jdbc.core.JdbcTemplate.batchUpdate(JdbcTemplate.java:1034)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.batchUpdate(NamedParameterJdbcTemplate.java:373)
at org.springframework.batch.item.database.JdbcBatchItemWriter.write(JdbcBatchItemWriter.java:182)
at com.sonatype.nexus.db.migrator.writer.ContentRepositoryWriter.writeByFormat(ContentRepositoryWriter.java:54)
at com.sonatype.nexus.db.migrator.writer.ContentRepositoryWriter.write(ContentRepositoryWriter.java:48)
at org.springframework.batch.item.support.ClassifierCompositeItemWriter.write(ClassifierCompositeItemWriter.java:69)
at org.springframework.batch.core.step.item.SimpleChunkProcessor.writeItems(SimpleChunkProcessor.java:193)
at org.springframework.batch.core.step.item.SimpleChunkProcessor.doWrite(SimpleChunkProcessor.java:159)
at org.springframework.batch.core.step.item.FaultTolerantChunkProcessor$3.doWithRetry(FaultTolerantChunkProcessor.java:348)
at org.springframework.retry.support.RetryTemplate.doExecute(RetryTemplate.java:329)
... 54 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table "PYPI_CONTENT_REPOSITORY" not found; SQL statement:
INSERT INTO pypi_content_repository (repository_id, config_repository_id, attributes)
VALUES (?, ?, stringtoutf8(?));
[42102-224]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:514)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:489)
at org.h2.message.DbException.get(DbException.java:223)
at org.h2.message.DbException.get(DbException.java:199)
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8064)
at org.h2.command.Parser.getTableOrViewNotFoundDbException(Parser.java:8035)
at org.h2.command.Parser.readTableOrView(Parser.java:8024)
at org.h2.command.Parser.readTableOrView(Parser.java:7990)
at org.h2.command.Parser.parseInsert(Parser.java:1540)
at org.h2.command.Parser.parsePrepared(Parser.java:719)
at org.h2.command.Parser.parse(Parser.java:592)
at org.h2.command.Parser.parse(Parser.java:564)
at org.h2.command.Parser.prepareCommand(Parser.java:483)
at org.h2.engine.SessionLocal.prepareLocal(SessionLocal.java:639)
at org.h2.engine.SessionLocal.prepareCommand(SessionLocal.java:559)
at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1166)
at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:93)
at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:316)
at com.zaxxer.hikari.pool.ProxyConnection.prepareStatement(ProxyConnection.java:337)
at com.zaxxer.hikari.pool.HikariProxyConnection.prepareStatement(HikariProxyConnection.java)
at org.springframework.jdbc.core.JdbcTemplate$SimplePreparedStatementCreator.createPreparedStatement(JdbcTemplate.java:1645)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:649)
... 65 common frames omitted
12:55:23 [main] INFO c.s.n.d.m.l.ProcessRecordStepListener - migrateBucketsStep migrated 0 records, skipped 0 records
12:55:23 [main] INFO o.s.batch.core.step.AbstractStep - Step: [migrateBucketsStep] executed in 639ms
12:55:23 [main] INFO o.s.batch.core.step.AbstractStep - Step: [processFullDatabase] executed in 1s778ms
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Migration job finished at Wed Sep 25 12:55:23 CEST 2024
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Migration job took 7 seconds to execute
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - 264 records were processed
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - 15 records were filtered
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - 0 records were skipped
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - 220 records were migrated
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - ------------------------------------------------------------
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Migration job finished with status FAILED.
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - Detailed message:
12:55:23 [main] INFO c.s.n.d.m.l.ProvidingJobInfoListener - ------------------------------------------------------------
Trying to migrate our database from OrientDB to H2DB is failing on APT tables. I'm using
nexus-db-migrator-3.70.2-01.jarCommand line:
Output logs: