# Keycloak database upgrade to 9.0.1+ Failed

**URL:** <https://forum.keycloak.org/t/keycloak-database-upgrade-to-9-0-1-failed/2261>\
**Category:** Getting advice\
**Created:** [April 21, 2020, 9:21am UTC](https://forum.keycloak.org/t/keycloak-database-upgrade-to-9-0-1-failed/2261 "2020-04-21T09:21:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mnb](https://yyz2.discourse-cdn.com/free1/user_avatar/forum.keycloak.org/mnb/32/710_2.png) [@mnb](https://forum.keycloak.org/u/mnb)\
**Post date:** [April 21, 2020, 9:21am UTC](https://forum.keycloak.org/t/keycloak-database-upgrade-to-9-0-1-failed/2261/1 "2020-04-21T09:21:27Z")

</div>

Hi,

in process of upgrading the database of Version 9.0.0 to 9.0.2 or 9.0.3 ,i get this error message:

```
08:31:39,141 INFO [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 59) Updating database. Using changelog META-INF/jpa-changelog-master.xml
08:31:39,262 ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool -- 59) Change Set META-INF/jpa-changelog-9.0.1.xml::9.0.1-KEYCLOAK-12579-add-not-null-constraint::keycloak failed.  
   Error: Unique index or primary key violation: "SIBLING_NAMES_INDEX_E ON PUBLIC.KEYCLOAK_GROUP(REALM_ID, PARENT_GROUP, NAME) VALUES ('REALM_ID_X', ' ', 'NameX', 27)"; 
   SQL statement: UPDATE PUBLIC.KEYCLOAK_GROUP SET PARENT_GROUP = ' ' WHERE PARENT_GROUP IS NULL [23505-193] [Failed SQL: UPDATE PUBLIC.KEYCLOAK_GROUP SET PARENT_GROUP = ' ' WHERE PARENT_GROUP IS NULL]
08:31:39,278 FATAL [org.keycloak.services] (ServerService Thread Pool -- 59) java.lang.RuntimeException: Failed to update database

```

I’m not sure how to solve it.  
At the moment i have rolled the system back to 9.0.0.  
The system is a “Standalone” installation with H2 as database.

May be related: [KEYCLOAK-13908](https://issues.redhat.com/browse/KEYCLOAK-13908)

---

<div class="post-metadata">

**Author:** ![mnb](https://yyz2.discourse-cdn.com/free1/user_avatar/forum.keycloak.org/mnb/32/710_2.png) [@mnb](https://forum.keycloak.org/u/mnb)\
**Post date:** [April 22, 2020, 1:28pm UTC](https://forum.keycloak.org/t/keycloak-database-upgrade-to-9-0-1-failed/2261/2 "2020-04-22T13:28:29Z")

</div>

Fixed it by manual renaming a doubled group entry.  
And verifyed the renamed group does not have anything attached to it,  
then i deleted the group in Keycloak after the upgrade.