<div dir="ltr">Maybe it's down to MySQL config? For example storage engine.</div><div class="gmail_extra"><br><div class="gmail_quote">On 2 March 2016 at 08:11, Marek Posolda <span dir="ltr"><<a href="mailto:mposolda@redhat.com" target="_blank">mposolda@redhat.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div bgcolor="#FFFFFF" text="#000000"><span class="">
<div>On 01/03/16 17:32, Darcy Welsh wrote:<br>
</div>
<blockquote type="cite">
<div>Hi Marek,</div>
<div><br>
</div>
<div>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>
<blockquote type="cite">
<div><br>
</div>
<div>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><br>
</div>
<div>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"><br>
<br>
Marek</font></span><div><div class="h5"><br>
<blockquote type="cite">
<div><br>
</div>
<div><br>
</div>
<div>Darcy</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<br>
<div>
<blockquote type="cite">
<div>On Mar 1, 2016, at 8:17 AM, Marek Posolda <<a href="mailto:mposolda@redhat.com" target="_blank"></a><a href="mailto:mposolda@redhat.com" target="_blank">mposolda@redhat.com</a>> wrote:</div>
<br>
<div>
<div bgcolor="#FFFFFF" text="#000000">
<div>Thanks. Strange as I couldn't
see it.<br>
<br>
Few questions:<br>
<br>
- Do you see it during startup of 1.9.0 against clean DB
too? Or just during migration from 1.8.0 ?<br>
<br>
- Could you try with datasource settings like this? [1]<br>
<br>
- Could you try with JDBC driver 5.1.29 ?<br>
<br>
[1]<br>
<br>
<datasource <br>
jndi-name="java:jboss/datasources/KeycloakDS"<br>
pool-name="KeycloakDS"<br>
enabled="true"<br>
use-java-context="true"><br>
<connection-url>jdbc:mysql://localhost/keycloak</connection-url><br>
<driver>mysql</driver><br>
<security><br>
<user-name>keycloak</user-name><br>
<password>keycloak</password><br>
</security><br>
</datasource><br>
<drivers><br>
<driver name="h2"
module="com.h2database.h2"><br>
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class><br>
</driver><br>
<driver name="mysql"
module="com.mysql"><br>
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class><br>
</driver><br>
</drivers><br>
</datasources><br>
<br>
<br>
Marek<br>
<br>
On 29/02/16 14:57, Darcy Welsh wrote:<br>
</div>
<blockquote type="cite">
<div>Hey Marek,</div>
<div><br>
</div>
<div>I am using MySQL 5.6.23 with JDBC driver
version 5.1.33.</div>
<div><br>
</div>
<div>Darcy</div>
<div><br>
</div>
<br>
<div>
<blockquote type="cite">
<div>On Feb 29, 2016, at 2:16 AM, Marek
Posolda <<a href="mailto:mposolda@redhat.com" target="_blank">mposolda@redhat.com</a>>
wrote:</div>
<br>
<div>
<div bgcolor="#FFFFFF" text="#000000">
<div>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"></a><a href="http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog" target="_blank">http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog</a>
. Wonder if it can be related to your issue...<br>
<br>
I am testing MySQL with JDBC driver version
5.1.29 and never saw the issue like this.<br>
<br>
Marek<br>
<br>
On 28/02/16 06:00, Darcy Welsh wrote:<br>
</div>
<blockquote type="cite">
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">Hi,</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><br>
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">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"><br>
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><span style="color:rgb(195,55,32)">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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)">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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </span>...
36 more</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo;color:rgb(195,55,32)">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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </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)"><span style="white-space:pre-wrap"> </span>...
45 more</div>
<div><br>
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">Any ideas as to the potential
cause/resolution? </div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><br>
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo">The MySQL datasource is configured
as follows:</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><br>
</div>
<div style="margin:0px;line-height:normal">
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<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"><font face="Menlo"><span style="font-size:11px">
<connection-url>jdbc:mysql://localhost:3306/keycloak</connection-url></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<connection-property
name="defaultFetchSize"></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
1000</span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
</connection-property></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<driver>mysql</driver></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<pool></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<max-pool-size>20</max-pool-size></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
</pool></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<security></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<user-name>keycloak</user-name></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<password>keycloakrocks!</password></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
</security></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<timeout></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<set-tx-query-timeout>true</set-tx-query-timeout></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
</timeout></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<statement></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<prepared-statement-cache-size>100</prepared-statement-cache-size></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<share-prepared-statements>true</share-prepared-statements></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
</statement></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
</datasource></span></font></div>
<div style="margin:0px;line-height:normal"><span style="font-size:11px;font-family:Menlo">
<drivers></span></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<driver name="mysql"
module="com.mysql.jdbc"></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
<datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlDataSource</datasource-class></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
</driver></span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px"> .</span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px"> .</span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px"> .</span></font></div>
<div style="margin:0px;line-height:normal"><font face="Menlo"><span style="font-size:11px">
</drivers></span></font></div>
<div style="font-family:Menlo;font-size:11px"><br>
</div>
<div style="font-family:Menlo;font-size:11px"><br>
</div>
<div style="font-family:Menlo;font-size:11px"><br>
</div>
<div style="font-family:Menlo;font-size:11px">Any help would be much
appreciated.</div>
<div style="font-family:Menlo;font-size:11px"><br>
</div>
<div style="font-family:Menlo;font-size:11px">Thank-you in advance,</div>
<div style="font-family:Menlo;font-size:11px">Darcy Welsh</div>
</div>
<div style="margin:0px;font-size:11px;line-height:normal;font-family:Menlo"><br>
</div>
<br>
<fieldset></fieldset>
<br>
<pre>_______________________________________________
keycloak-user mailing list
<a href="mailto:keycloak-user@lists.jboss.org" target="_blank">keycloak-user@lists.jboss.org</a>
<a href="https://lists.jboss.org/mailman/listinfo/keycloak-user" target="_blank">https://lists.jboss.org/mailman/listinfo/keycloak-user</a></pre>
</blockquote>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</blockquote>
<br>
</div></div></div>
<br>_______________________________________________<br>
keycloak-user mailing list<br>
<a href="mailto:keycloak-user@lists.jboss.org">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>