<html><head><meta http-equiv="Content-Type" content="text/html charset=utf-8"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Correct, still see the error when <span style="background-color: rgb(255, 255, 255);" class="">starting Keycloak 1.9.0 with empty MySQL DB.</span></div><div class=""><span style="background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><div class=""><span style="background-color: rgb(255, 255, 255);" class="">I’m confounded as Keycloak 1.5.x, 1.6.x, 1.7x. and 1.8.0 all work just fine with the same MySQL instance, only 1.8.1 and 1.9.0 have the issue. And I’m using the same version of the MySql JDBC driver in all cases (5.1.33). </span></div><div class=""><span style="background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><div class=""><span style="background-color: rgb(255, 255, 255);" class="">Will report back if I find anything.</span></div><div class=""><span style="background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><div class=""><span style="background-color: rgb(255, 255, 255);" class="">Thanks,</span></div><div class="">Darcy</div><div class=""><span style="background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><div class=""><span style="background-color: rgb(255, 255, 255);" class=""><br class=""></span></div><br class=""><div><blockquote type="cite" class=""><div class="">On Mar 2, 2016, at 6:00 AM, Stian Thorgersen <<a href="mailto:sthorger@redhat.com" class="">sthorger@redhat.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><div dir="ltr" class="">Maybe it's down to MySQL config? For example storage engine.</div><div class="gmail_extra"><br class=""><div class="gmail_quote">On 2 March 2016 at 08:11, Marek Posolda <span dir="ltr" class=""><<a href="mailto:mposolda@redhat.com" target="_blank" class="">mposolda@redhat.com</a>></span> wrote:<br class=""><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000" class=""><span class="">
<div class="">On 01/03/16 17:32, Darcy Welsh wrote:<br class="">
</div>
<blockquote type="cite" class="">
<div class="">Hi Marek,</div>
<div class=""><br class="">
</div>
<div class="">Thank-you for the response and suggestions, much
appreciated. Unfortunately, I tried all of them (clean db,
datasource settings and JDBC driver 5.1.29) and still see the
issue.</div>
</blockquote></span>
ah, so just to clearify. Even if you start Keycloak 1.9.0 with empty
MySQL DB, the startup will fail with this error?<span class=""><br class="">
<blockquote type="cite" class="">
<div class=""><br class="">
</div>
<div class="">It’s very strange indeed - I have no issue with
Keycloak 1.5.x, 1.6.x, 1,7.x, 1.8.0 - I suspect it may have
something to do with the change to Wildfly 10 starting in
Keycloak 1.8.1. </div>
<div class=""><br class="">
</div>
<div class="">I am using JRE 1.8.0_25, not sure if that is
relevant.</div>
</blockquote></span>
Guess wildfly version or JDK version is not too relevant here. Hard
to say without being able to reproduce.<span class="HOEnZb"><font color="#888888" class=""><br class="">
<br class="">
Marek</font></span><div class=""><div class="h5"><br class="">
<blockquote type="cite" class="">
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class="">Darcy</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<div class=""><br class="">
</div>
<br class="">
<div class="">
<blockquote type="cite" class="">
<div class="">On Mar 1, 2016, at 8:17 AM, Marek Posolda <<a href="mailto:mposolda@redhat.com" target="_blank" class=""></a><a href="mailto:mposolda@redhat.com" target="_blank" class="">mposolda@redhat.com</a>> wrote:</div>
<br class="">
<div class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="">Thanks. Strange as I couldn't
see it.<br class="">
<br class="">
Few questions:<br class="">
<br class="">
- Do you see it during startup of 1.9.0 against clean DB
too? Or just during migration from 1.8.0 ?<br class="">
<br class="">
- Could you try with datasource settings like this? [1]<br class="">
<br class="">
- Could you try with JDBC driver 5.1.29 ?<br class="">
<br class="">
[1]<br class="">
<br class="">
<datasource <br class="">
jndi-name="java:jboss/datasources/KeycloakDS"<br class="">
pool-name="KeycloakDS"<br class="">
enabled="true"<br class="">
use-java-context="true"><br class="">
<connection-url>jdbc:mysql://localhost/keycloak</connection-url><br class="">
<driver>mysql</driver><br class="">
<security><br class="">
<user-name>keycloak</user-name><br class="">
<password>keycloak</password><br class="">
</security><br class="">
</datasource><br class="">
<drivers><br class="">
<driver name="h2"
module="com.h2database.h2"><br class="">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class><br class="">
</driver><br class="">
<driver name="mysql"
module="com.mysql"><br class="">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class><br class="">
</driver><br class="">
</drivers><br class="">
</datasources><br class="">
<br class="">
<br class="">
Marek<br class="">
<br class="">
On 29/02/16 14:57, Darcy Welsh wrote:<br class="">
</div>
<blockquote type="cite" class="">
<div class="">Hey Marek,</div>
<div class=""><br class="">
</div>
<div class="">I am using MySQL 5.6.23 with JDBC driver
version 5.1.33.</div>
<div class=""><br class="">
</div>
<div class="">Darcy</div>
<div class=""><br class="">
</div>
<br class="">
<div class="">
<blockquote type="cite" class="">
<div class="">On Feb 29, 2016, at 2:16 AM, Marek
Posolda <<a href="mailto:mposolda@redhat.com" target="_blank" class="">mposolda@redhat.com</a>>
wrote:</div>
<br class="">
<div class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="">Which JDBC driver
and DB version are you using? Just found this
thread during googling: <a href="http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog" target="_blank" class=""></a><a href="http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog" target="_blank" class="">http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog</a>
. Wonder if it can be related to your issue...<br class="">
<br class="">
I am testing MySQL with JDBC driver version
5.1.29 and never saw the issue like this.<br class="">
<br class="">
Marek<br class="">
<br class="">
On 28/02/16 06:00, Darcy Welsh wrote:<br class="">
</div>
<blockquote type="cite" class="">
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">Hi,</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class="">
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">I successfully upgraded from 1.7.0
to 1.8.0, however, seeing the following
error when attempting to upgrade from 1.8.0
to either 1.8.1 or 1.9.0:</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class="">
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><span style="color:rgb(195,55,32)" class="">22:45:48,803 ERROR
[org.keycloak.services.resources.KeycloakApplication]
(ServerService Thread Pool -- 51) Failed
to migrate datamodel:
java.lang.RuntimeException: Failed to
update database</span></div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:87)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:153)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:42)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:30)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:103)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:103)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.models.cache.infinispan.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:61)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.models.cache.infinispan.DefaultCacheRealmProvider.getMigrationModel(DefaultCacheRealmProvider.java:43)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:21)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:139)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:82)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
java.lang.reflect.Constructor.newInstance(Constructor.java:408)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
java.util.concurrent.FutureTask.run(FutureTask.java:266)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
java.lang.Thread.run(Thread.java:745)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.jboss.threads.JBossThread.run(JBossThread.java:320)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class="">Caused
by: liquibase.exception.DatabaseException:
Incorrect database name '' [Failed SQL:
CREATE TABLE ``.DATABASECHANGELOG (ID
VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255)
NOT NULL, FILENAME VARCHAR(255) NOT NULL,
DATEEXECUTED datetime NOT NULL,
ORDEREXECUTED INT NOT NULL, EXECTYPE
VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35)
NULL, DESCRIPTION VARCHAR(255) NULL,
COMMENTS VARCHAR(255) NULL, TAG VARCHAR(255)
NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS
VARCHAR(255) NULL, LABELS VARCHAR(255)
NULL)]</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:112)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:214)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1074)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1136)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1126)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1122)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:63)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>...
36 more</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class="">Caused
by:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Incorrect database name ''</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
java.lang.reflect.Constructor.newInstance(Constructor.java:408)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.Util.handleNewInstance(Util.java:377)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.Util.getInstance(Util.java:360)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)" class=""><span style="white-space:pre-wrap" class=""> </span>...
45 more</div>
<div class=""><br class="">
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">Any ideas as to the potential
cause/resolution? </div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class="">
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class="">The MySQL datasource is configured
as follows:</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class="">
</div>
<div style="margin:0px;line-height:normal" class="">
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<datasource jta="true"
jndi-name="java:jboss/datasources/KeycloakDS"
pool-name="KeycloakDS" enabled="true"
use-java-context="true"></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<connection-url>jdbc:mysql://localhost:3306/keycloak</connection-url></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<connection-property
name="defaultFetchSize"></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
1000</span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
</connection-property></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<driver>mysql</driver></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<pool></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<max-pool-size>20</max-pool-size></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
</pool></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<security></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<user-name>keycloak</user-name></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<password>keycloakrocks!</password></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
</security></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<timeout></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<set-tx-query-timeout>true</set-tx-query-timeout></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
</timeout></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<statement></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<prepared-statement-cache-size>100</prepared-statement-cache-size></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<share-prepared-statements>true</share-prepared-statements></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
</statement></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
</datasource></span></font></div>
<div style="margin:0px;line-height:normal" class=""><span style="font-size:11px;font-family:Menlo" class="">
<drivers></span></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<driver name="mysql"
module="com.mysql.jdbc"></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
<datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlDataSource</datasource-class></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
</driver></span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class=""> .</span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class=""> .</span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class=""> .</span></font></div>
<div style="margin:0px;line-height:normal" class=""><font face="Menlo" class=""><span style="font-size:11px" class="">
</drivers></span></font></div>
<div style="font-family:Menlo;font-size:11px" class=""><br class="">
</div>
<div style="font-family:Menlo;font-size:11px" class=""><br class="">
</div>
<div style="font-family:Menlo;font-size:11px" class=""><br class="">
</div>
<div style="font-family:Menlo;font-size:11px" class="">Any help would be much
appreciated.</div>
<div style="font-family:Menlo;font-size:11px" class=""><br class="">
</div>
<div style="font-family:Menlo;font-size:11px" class="">Thank-you in advance,</div>
<div style="font-family:Menlo;font-size:11px" class="">Darcy Welsh</div>
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo" class=""><br class="">
</div>
<br class="">
<fieldset class=""></fieldset>
<br class="">
<pre class="">_______________________________________________
keycloak-user mailing list
<a href="mailto:keycloak-user@lists.jboss.org" target="_blank" class="">keycloak-user@lists.jboss.org</a>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" target="_blank" class="">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<br class="">
</div>
</div>
</blockquote>
</div>
<br class="">
</blockquote>
<br class="">
</div>
</div>
</blockquote>
</div>
<br class="">
</blockquote>
<br class="">
</div></div></div>
<br class="">_______________________________________________<br class="">
keycloak-user mailing list<br class="">
<a href="mailto:keycloak-user@lists.jboss.org" class="">keycloak-user@lists.jboss.org</a><br class="">
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" rel="noreferrer" target="_blank" class="">https://lists.jboss.org/mailman/listinfo/keycloak-user</a><br class=""></blockquote></div><br class=""></div>
</div></blockquote></div><br class=""></body></html>