Hi everyone, I'm trying to upgrade Keycloak 1.2.0 Final to a newer version, encountered the following error while the system tries to update the database: 00:55:20,179 ERROR [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 60) Change Set META-INF/ jpa-changelog-1.3.0.xml::1.3.0::bburke@redhat.com fail ed. Error: Can't DROP 'FK_PMConfig'; check that column/key exists [Failed SQL: ALTER TABLE auth_table.PROTOCOL_MAPPER_CONFIG DROP FOREIGN KEY FK_PMConfig]: liquibase.exception.DatabaseException: Can't DR OP 'FK_PMConfig'; check that column/key exists [Failed SQL: ALTER TABLE auth_table.PROTOCOL_MAPPER_CONFIG DROP FOREIGN KEY FK_PMConfig] I have tried upgrading to 1.3.1 as well as to 1.7.0 directly, but the same error message was shown. Can someone point me in the right direction? Thank very much! Boken. _______________________________________________ keycloak-user mailing list keycloak-user(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/keycloak-user

Hi Stian, thanks for your reply. The database we are using is MySQL on AWS. Boken. On Jan 13, 2016 2:48 AM, "Stian Thorgersen" <sthorger(a)redhat.com&gt; wrote: > What database are you using? > > On 13 January 2016 at 03:41, Boken Lin <bl(a)onion.io&gt; wrote: > >> Hi everyone, >> >> I'm trying to upgrade Keycloak 1.2.0 Final to a newer version, >> encountered the following error while the system tries to update the >> database: >> >> 00:55:20,179 ERROR >> [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] >> (ServerService Thread Pool -- 60) Change Set META-INF/ >> jpa-changelog-1.3.0.xml::1.3.0::bburke@redhat.com fail >> ed. Error: Can't DROP 'FK_PMConfig'; check that column/key exists >> [Failed SQL: ALTER TABLE auth_table.PROTOCOL_MAPPER_CONFIG DROP FOREIGN KEY >> FK_PMConfig]: liquibase.exception.DatabaseException: Can't DR >> OP 'FK_PMConfig'; check that column/key exists [Failed SQL: ALTER TABLE >> auth_table.PROTOCOL_MAPPER_CONFIG DROP FOREIGN KEY FK_PMConfig] >> >> I have tried upgrading to 1.3.1 as well as to 1.7.0 directly, but the >> same error message was shown. >> >> Can someone point me in the right direction? >> >> Thank very much! >> Boken. >> _______________________________________________ >> keycloak-user mailing list >> keycloak-user(a)lists.jboss.org >> https://lists.jboss.org/mailman/listinfo/keycloak-user >> > >