[keycloak-user] Database migration error

[Stian Thorgersen]

What MySQL version? It would also be helpful if you can confirm if this is
an issue with MySQL outside of AWS. Can you also create a JIRA issue please?

On 13 January 2016 at 14:45, Boken Lin <bl at onion.io> wrote:

> 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/20160119/a2bd3fa5/attachment-0001.html