<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">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
cite="mid:EB860BCB-63B3-4D6A-ACEB-D067F4F99F57@yahoo.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<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>
<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 class="moz-txt-link-abbreviated" href="mailto:mposolda@redhat.com">mposolda@redhat.com</a></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>
</body>
</html>