<html><head><meta http-equiv="Content-Type" content="text/html charset=windows-1252"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" 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><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><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><blockquote type="cite" class=""><div class="">On Mar 1, 2016, at 8:17 AM, Marek Posolda <<a href="mailto:mposolda@redhat.com" class="">mposolda@redhat.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class="">
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix">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 cite="mid:EB860BCB-63B3-4D6A-ACEB-D067F4F99F57@yahoo.com" type="cite" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" 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 moz-do-not-send="true" href="mailto:mposolda@redhat.com" class=""></a><a class="moz-txt-link-abbreviated" href="mailto:mposolda@redhat.com">mposolda@redhat.com</a>> wrote:</div>
<br class="Apple-interchange-newline">
<div class="">
<meta content="text/html; charset=windows-1252" http-equiv="Content-Type" class="">
<div bgcolor="#FFFFFF" text="#000000" class="">
<div class="moz-cite-prefix">Which JDBC driver and DB
version are you using? Just found this thread during
googling: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog">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 cite="mid:E074F712-1D84-48CA-AB9A-A6B16441D699@yahoo.com" type="cite" class="">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252" 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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="Apple-tab-span" style="white-space:pre"> </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 class="" face="Menlo"><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 class="" face="Menlo"><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 class="" face="Menlo"><span style="font-size: 11px;" class="">
<connection-property
name="defaultFetchSize"></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
1000</span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
</connection-property></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<driver>mysql</driver></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<pool></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><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 class="" face="Menlo"><span style="font-size: 11px;" class="">
</pool></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<security></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<user-name>keycloak</user-name></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<password>keycloakrocks!</password></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
</security></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<timeout></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><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 class="" face="Menlo"><span style="font-size: 11px;" class="">
</timeout></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
<statement></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><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 class="" face="Menlo"><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 class="" face="Menlo"><span style="font-size: 11px;" class="">
</statement></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><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 class="" face="Menlo"><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 class="" face="Menlo"><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 class="" face="Menlo"><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 class="" face="Menlo"><span style="font-size: 11px;" class="">
</driver></span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
.</span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
.</span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><span style="font-size: 11px;" class="">
.</span></font></div>
<div style="margin: 0px; line-height: normal;" class=""><font class="" face="Menlo"><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="mimeAttachmentHeader"></fieldset>
<br class="">
<pre class="" wrap="">_______________________________________________
keycloak-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:keycloak-user@lists.jboss.org">keycloak-user@lists.jboss.org</a>
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/keycloak-user">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=""></body></html>