Uploaded image for project: 'Dev - Nexus Repo'
  1. Dev - Nexus Repo
  2. NEXUS-32494

fail fast when migrating database from OrientDB which has incompatible schemas

    Details

    • Notability:
      3

      Description

      A customer was migrating a large Orient Database using DB migrator 3.39.0 against an orient database that was used with Nexus Repository 3.38.0. Their intent was to use the latest features of 3.39.0 migrator. Upgrading their Nexus Repository instance to 3.39.0 had too much risk and too big of a lift to do that first.

      The migrator starts, exports all databases and then 67 minutes into the migration reports ERRORs about the schema versions being incompatible.

      19:10:59 [main] INFO  c.s.n.d.migrator.MigratorApplication - Starting MigratorApplication v3.39.0-01 using Java 1.8.0_332 on fubar.example.com with PID 100861 (/proj/appnexus/psql-migration/nexus-db-migrator-3.39.0-01.jar started by nexus-user in /proj/appnexus/psql-migration)
      
      20:18:31 [main] INFO  c.s.n.db.migrator.reader.FileReader - Current migration type is postgres.
      20:18:31 [main] ERROR o.s.batch.core.step.AbstractStep - Encountered an error executing step readFileStep in job migrationFromOrientJob
      com.sonatype.nexus.db.migrator.exception.WrongSchemaVersionException: Occurring schema versions that are not supported:
      Upgrade ModelVersions{config='1.9', security='1.3', component='1.15', healthCheck='1.1', userToken='1.2', tags='1.1'}
      Supported schema versions:
      Upgrade ModelVersions{config='1.10', security='1.3', component='1.16', healthCheck='1.1', userToken='1.2', tags='1.1'}
      Your OrientDB schemas are not supported by the current migrator version. Please update your Nexus Repository to the 3.39.0 version and use latest migrator version.
      
      20:18:31 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - ------------------------------------------------------------
      20:18:31 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Migration job finished with status FAILED.
      20:18:31 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - Detailed message: com.sonatype.nexus.db.migrator.exception.WrongSchemaVersionException: Occurring schema versions that are not supported:
      Upgrade ModelVersions{config='1.9', security='1.3', component='1.15', healthCheck='1.1', userToken='1.2', tags='1.1'}
      Supported schema versions:
      Upgrade ModelVersions{config='1.10', security='1.3', component='1.16', healthCheck='1.1', userToken='1.2', tags='1.1'}
      Your OrientDB schemas are not supported by the current migrator version. Please update your Nexus Repository to the 3.39.0 version and use latest migrator version.
      20:18:31 [main] INFO  c.s.n.d.m.l.ProvidingJobInfoListener - ------------------------------------------------------------
      

      Expected

      Do not fail after a lengthy period of time has passed when schema versions are not compatible. Instead fail early - within a couple minutes or less - so that a user is not wasting precious hours only to have the migration fail in this way.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            plynch Peter Lynch
            Last Updated By:
            Michael Oliverio Michael Oliverio
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:

                tigCommentSecurity.panel-title