Uploaded image for project: 'RH-SSO'
  1. RH-SSO
  2. RHSSO-764

Migration - applying genareted sql script fails with SQLIntegrityConstraintViolationException

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Critical Critical
    • RH-SSO-7.1.0.CR2
    • RH-SSO-7.1.0.CR1
    • None
    • None

      There is error when generated sql script for manual migration is applied for all databases.
      It throws something like java.sql.SQLIntegrityConstraintViolationException: Duplicate entry '4dd39136-ae1f-4cb7-b769-ce97e1865aa6' for key 'PRIMARY' when executing line "INSERT INTO $DBSCHEMA.COMPONENT (ID, REALM_ID, PARENT_ID, NAME, PROVIDER_ID, PROVIDER_TYPE) VALUES ('4dd39136-ae1f-4cb7-b769-ce97e1865aa6', 'Migration2', 'Migration2', 'ldap-provider', 'ldap', 'org.keycloak.storage.UserStorageProvider')"

      There is link to test results where you can see the error: https://keycloak-jenkins.rhev-ci-vms.eng.rdu2.redhat.com/view/vramik/job/rh-sso-jpa-migration-manual/17/testReport/

        1. postgresplus-keycloak-database-update.sql
          55 kB
        2. oracle-keycloak-database-update.sql
          55 kB
        3. mysql-keycloak-database-update.sql
          55 kB
        4. mssql-keycloak-database-update.sql
          59 kB
        5. mariadb-keycloak-database-update.sql
          54 kB
        6. db2-keycloak-database-update.sql
          59 kB

              vramik@redhat.com Vlasta Ramik
              vramik@redhat.com Vlasta Ramik
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: