Keycloak liquibase error when upgrading to 12.0.3 in standalone-ha mode

While performing an upgrade from 10.0.2 to 12.0.3 of keycloak I am facing issue with sql migration which is resulting in liquibase error.
ERROR [org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider] (ServerService Thread Pool – 67) Change Set META-INF/jpa-changelog-12.0.0.xml::12.1.0-add-realm-localization-table::keycloak failed. Error: Table ‘REALM_LOCALIZATIONS’ already exists [Failed SQL: CREATE TABLE kcDBCACHE.REALM_LOCALIZATIONS (REALM_ID VARCHAR(255) NOT NULL, LOCALE VARCHAR(255) NOT NULL, TEXTS LONGTEXT NOT NULL)]

1 Like