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