Details

    • Type: Bug
    • Status: Triage (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 9.0.0
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None
    • Docs QE Status:
      NEW
    • QE Status:
      NEW

      Description

      Hello

      I am trying to upgrade from 4.8.3 to Keycloak 9.0.

      Running a fresh database is fine, importing JSON files also except that user imported must change their password due to password policy changed.

      Now i would like to upgrade my real database.
      But Keycloak is not starting because of the following error :

      10:37:46,520 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool – 66) ERROR: duplicate key value violates unique constraint "uk_frsr6t700s9v50bu18ws5ha6"
      Detail: Key (name, owner, resource_server_id)=(Default Resource, 5f4108a0-0e09-4fa8-ad65-21f2404302de, 5f4108a0-0e09-4fa8-ad65-21f2404302de) already exists.
      10:37:46,535 FATAL [org.keycloak.services] (ServerService Thread Pool – 66) org.keycloak.models.ModelDuplicateException: javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

      The table involved is resource_server_resource where there is one line.

      Any clue of what's going on ?

      Many thanks for your help

        Gliffy Diagrams

          Attachments

          1. DBChangelog.jpg
            DBChangelog.jpg
            106 kB
          2. KC9_903_WITH_483_DATABASE_AND_9_JSON.log
            93 kB
          3. KC9_DB_LOG.jpg
            KC9_DB_LOG.jpg
            95 kB
          4. KC9_DEBUG_EMPTY.log
            64 kB
          5. KC9_DEBUG_NOPARAMS.log
            84 kB
          6. KC9_DEBUG.log
            72 kB
          7. ServerLog.txt
            42 kB

            Activity

              People

              • Assignee:
                vramik Vlasta Ramik
                Reporter:
                julien.baron Julien BARON
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: