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@redhat.com> wrote:

What database are you using?

On 13 January 2016 at 03:41, Boken Lin <bl@onion.io> 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@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user