Uploaded image for project: 'mod-data-export'
  1. mod-data-export
  2. MDEXP-542

Migration script fails if upgrading from version 4.2.4 to version 4.4.2

    XMLWordPrintable

Details

    • Firebird - Sprint 145
    • 1
    • Firebird
    • Lotus (R1 2022) Hot Fix #3
    • Yes
    • Approved in Slack on Jul, 20
    • TBD

    Description

      Overview:

      io.vertx.pgclient.PgException: {
          "message": "duplicate key value violates unique constraint \"mapping_profiles_pkey\"",
          "severity": "ERROR",
          "code": "<<code>>",
          "detail": "Key (id)=(1ef7d0ac-f0a8-42b5-bbbb-c7e249009c13) already exists.",
          "file": "nbtinsert.c",
          "line": "573",
          "routine": "_bt_check_unique",
          "schema": "<<tenant id>>_mod_data_export",
          "table": "mapping_profiles",
          "constraint": "mapping_profiles_pkey"
      }
      

      Steps to Reproduce:

      1. Run migration script for default mapping profile

      Expected Results:
      Migration script passed successfully.

      Actual Results:
      Error mentioned in Overview.

      Additional Information:
      URL:
      Interested parties:

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                Charniak Siarhei Charniak
                Oleksandr_Bozhko Oleksandr Bozhko
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases