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

Instance ID is not preserved during postgres migration.

    Details

    • Story Points:
      3
    • Sprint:
      NXRM Immortals Sprint 42, NXRM Immortals Sprint 43
    • Notability:
      2
    • InvestmentLayer:
      support-escalated
    • Aha Concept:
      non-concept

      Description

      The Nexus Repo instance ID is not preserved during a migration from OrientDb to Postgres.

      Reproduce steps:

      1. Fire up Nexus Repo 3.41.1 with Orientdb, then shut it down.
      2. Connect to the orientdb console for the config database
      3. Run this query to get the instance ID:
      select * from deploymentidentifier;
      

      Now migrate to Postgres.

      Observe that after migration the "node_id" table does not exist by running;

      select * from node_id:
      

      Start up Nexus Repo against Postgres.

      Observe that now "node_id" has a new ID by running:

      select * from node_id:

      Expected: Preserving the instance ID is critical, if it is not preserved it breaks Nexus Firewall. The linkage between the repositories and their reports in IQ Server is broken.

      This can be shown by enabling audit and quarantine on a repository before migrating to Postgres. After migration a brand new report tied to a different instance ID will be created. The Nexus Repo instance will no longer be linked to the original repository report.

       

       

       

        Attachments

          Activity

            People

            Assignee:
            leonardor Leonardo Ruiz
            Reporter:
            rseddon Rich Seddon
            Last Updated By:
            Denise Chang Denise Chang
            Team:
            NXRM - Optimus
            Owner:
            Andrii Osadchuk Andrii Osadchuk
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Date of First Response:

                tigCommentSecurity.panel-title