<div dir="ltr">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?</div><div class="gmail_extra"><br><div class="gmail_quote">On 13 January 2016 at 14:45, Boken Lin <span dir="ltr"><<a href="mailto:bl@onion.io" target="_blank">bl@onion.io</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><p dir="ltr">Hi Stian, thanks for your reply. The database we are using is MySQL on AWS.</p><span class="HOEnZb"><font color="#888888">
<p dir="ltr">Boken.</p></font></span><div class="HOEnZb"><div class="h5">
<div class="gmail_quote">On Jan 13, 2016 2:48 AM, "Stian Thorgersen" <<a href="mailto:sthorger@redhat.com" target="_blank">sthorger@redhat.com</a>> wrote:<br type="attribution"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">What database are you using?</div><div class="gmail_extra"><br><div class="gmail_quote">On 13 January 2016 at 03:41, Boken Lin <span dir="ltr"><<a href="mailto:bl@onion.io" target="_blank">bl@onion.io</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi everyone,<br>
<br>
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:<br>
<br>
00:55:20,179 ERROR [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 60) Change Set META-INF/<a href="mailto:jpa-changelog-1.3.0.xml%3A%3A1.3.0%3A%3Abburke@redhat.com" target="_blank">jpa-changelog-1.3.0.xml::1.3.0::bburke@redhat.com</a> fail<br>
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<br>
OP 'FK_PMConfig'; check that column/key exists [Failed SQL: ALTER TABLE auth_table.PROTOCOL_MAPPER_CONFIG DROP FOREIGN KEY FK_PMConfig]<br>
<br>
I have tried upgrading to 1.3.1 as well as to 1.7.0 directly, but the same error message was shown.<br>
<br>
Can someone point me in the right direction?<br>
<br>
Thank very much!<br>
Boken.<br>
_______________________________________________<br>
keycloak-user mailing list<br>
<a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a><br>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><br>
</blockquote></div><br></div>
</blockquote></div>
</div></div></blockquote></div><br></div>