<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<div class="moz-cite-prefix">On 01/03/16 17:32, Darcy Welsh wrote:<br>
</div>
<blockquote
cite="mid:1D0F022B-C90C-425D-A1E7-601ADA411073@yahoo.com"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<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>
ah, so just to clearify. Even if you start Keycloak 1.9.0 with empty
MySQL DB, the startup will fail with this error?<br>
<blockquote
cite="mid:1D0F022B-C90C-425D-A1E7-601ADA411073@yahoo.com"
type="cite">
<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>
Guess wildfly version or JDK version is not too relevant here. Hard
to say without being able to reproduce.<br>
<br>
Marek<br>
<blockquote
cite="mid:1D0F022B-C90C-425D-A1E7-601ADA411073@yahoo.com"
type="cite">
<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
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">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"
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"><a 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></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="">
</blockquote>
<br>
</body>
</html>