[keycloak-user] Database migration error

[Boken Lin]

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

> What database are you using?
>
> On 13 January 2016 at 03:41, Boken Lin <bl at 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 at 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 at lists.jboss.org
>> https://lists.jboss.org/mailman/listinfo/keycloak-user
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20160113/53f6a2c8/attachment.html