Keycloak interaction now uses JTA. Make sure you have the following in
standalone.xml or keycloak-server.json
"jta-lookup": {
"provider":"${keycloak.jta.lookup.provider:jboss}",
"jboss" : {
"enabled":true }
}
<spi name="jta-lookup">\
<default-provider>${keycloak.jta.lookup.provider:jboss}</default-provider>\
<provider name="jboss" enabled="true"/>\ </spi>
On 9/29/16 5:23 AM, Stian Thorgersen wrote:
Looks more like a database connection issue than a migration issue.
Did you try Googling for "IJ031040: Connection is not associated with
a managed connection"?
On 29 September 2016 at 07:17, Padmaka Wijaygoonawardena
<teknodjs(a)gmail.com <mailto:teknodjs@gmail.com>> wrote:
Hi,
With Keycloak 2.2.1 release the DB migration from a fresh DB fails
this also occurred in 2.1.0 as well. I use a MySQL DB as the
database. attached herewith is the stack trace.
[2016-09-28 10:35:18.0609], WARN ,
org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool
ServerService Thread Pool -- 62 - IJ000615: Destroying active
connection in pool: mysql_keycloak
(org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@2899b74f)
[2016-09-28 10:35:18.0618], WARN ,
org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection
ServerService Thread Pool -- 62 - IJ030022: Lock owned during
cleanup: ServerService Thread Pool -- 56: java.lang.Throwable:
Lock owned during cleanup: ServerService Thread Pool -- 56
at java.net.SocketInputStream.socketRead0(Native Method)
at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
at java.net.SocketInputStream.read(SocketInputStream.java:170)
at java.net.SocketInputStream.read(SocketInputStream.java:141)
at
com.mysql.jdbc.util.ReadAheadInputStream.fill(ReadAheadInputStream.java:100)
at
com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:143)
at
com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:173)
at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2911)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3337)
at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:3327)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
at
org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
at
liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
at
liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
at
liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at
liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
at liquibase.Liquibase.update(Liquibase.java:210)
at liquibase.Liquibase.update(Liquibase.java:190)
at liquibase.Liquibase.update(Liquibase.java:186)
at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.updateChangeSet(LiquibaseJpaUpdaterProvider.java:114)
at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:76)
at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:59)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.update(DefaultJpaConnectionProviderFactory.java:329)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.migration(DefaultJpaConnectionProviderFactory.java:299)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lambda$lazyInit$0(DefaultJpaConnectionProviderFactory.java:186)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory$$Lambda$105/1378148237.run(Unknown
Source)
at
org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:677)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:137)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:85)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:63)
at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:158)
at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:51)
at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:33)
at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:158)
at
org.keycloak.models.cache.infinispan.RealmCacheSession.getDelegate(RealmCacheSession.java:161)
at
org.keycloak.models.cache.infinispan.RealmCacheSession.getMigrationModel(RealmCacheSession.java:154)
at
org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:60)
at
org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:221)
at
org.keycloak.services.resources.KeycloakApplication.migrateAndBootstrap(KeycloakApplication.java:162)
at
org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:121)
at
org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:295)
at
org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:112)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at
org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
at
org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)
at
org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)
at
org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)
at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)
at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
at
org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
at
io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)
at
io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)
at
io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)
at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
[2016-09-28 10:35:18.0634], INFO ,
org.jboss.as.connector.services.driver.DriverService MSC service
thread 1-6 - WFLYJCA0019: Stopped Driver service with driver-name
= mysql-connector-java-5.1.33-bin.jar_com.mysql.jdbc.Driver_5_1
[2016-09-28 10:35:19.0107], INFO ,
org.hibernate.validator.internal.util.Version MSC service thread
1-5 - HV000001: Hibernate Validator 5.2.3.Final
[2016-09-28 10:35:19.0592], DEBUG,
org.keycloak.connections.jpa.updater.liquibase.conn.DefaultLiquibaseConnectionProvider$LogWrapper$1
ServerService Thread Pool -- 56 - Foreign key constraint added to
RESOURCE_POLICY (RESOURCE_ID)
[2016-09-28 10:35:19.0593], DEBUG,
org.keycloak.transaction.JtaTransactionWrapper ServerService
Thread Pool -- 56 - JtaTransactionWrapper rollback
[2016-09-28 10:35:19.0593], DEBUG,
org.keycloak.transaction.JtaTransactionWrapper ServerService
Thread Pool -- 56 - JtaTransactionWrapper end
[2016-09-28 10:35:19.0594], DEBUG,
org.keycloak.transaction.JtaTransactionWrapper ServerService
Thread Pool -- 56 - JtaTransactionWrapper resuming suspended
[2016-09-28 10:35:19.0595], DEBUG,
org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService
ServerService Thread Pool -- 56 - Going to release database lock
[2016-09-28 10:35:19.0595], ERROR,
org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService
ServerService Thread Pool -- 56 - Database error during release
lock: liquibase.exception.DatabaseException:
liquibase.exception.DatabaseException: java.sql.SQLException:
IJ031040: Connection is not associated with a managed connection:
org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@88d58a5
at
liquibase.database.AbstractJdbcDatabase.commit(AbstractJdbcDatabase.java:1130)
at
org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService.releaseLock(CustomLockService.java:184)
at
org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lambda$releaseLock$1(LiquibaseDBLockProvider.java:126)
at
org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:677)
at
org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.releaseLock(LiquibaseDBLockProvider.java:123)
at
org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:123)
at
org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:295)
at
org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:112)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at
org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
at
org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)
at
org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)
at
org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)
at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)
at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
at
org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
at
io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)
at
io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)
at
io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)
at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: liquibase.exception.DatabaseException:
java.sql.SQLException: IJ031040: Connection is not associated with
a managed connection:
org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@88d58a5
at
liquibase.database.jvm.JdbcConnection.commit(JdbcConnection.java:126)
at
liquibase.database.AbstractJdbcDatabase.commit(AbstractJdbcDatabase.java:1128)
... 31 more
Caused by: java.sql.SQLException: IJ031040: Connection is not
associated with a managed connection:
org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@88d58a5
at
org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.getAutoCommit(WrappedConnection.java:802)
at
liquibase.database.jvm.JdbcConnection.commit(JdbcConnection.java:122)
... 32 more
[2016-09-28 10:35:19.0596], DEBUG,
org.keycloak.transaction.JtaTransactionWrapper ServerService
Thread Pool -- 56 - JtaTransactionWrapper rollback
[2016-09-28 10:35:19.0596], DEBUG,
org.keycloak.transaction.JtaTransactionWrapper ServerService
Thread Pool -- 56 - JtaTransactionWrapper end
[2016-09-28 10:35:19.0598], INFO ,
org.jboss.as.server.BootstrapImpl$ShutdownHook Thread-2 -
WFLYSRV0220: Server shutdown has been requested.
[2016-09-28 10:35:19.0601], DEBUG,
org.jboss.as.security.service.SecurityDomainService MSC service
thread 1-8 - Stopping security domain service jboss-ejb-policy
[2016-09-28 10:35:19.0601], DEBUG,
org.jboss.as.mail.extension.MailSessionAdd$1 MSC service thread
1-2 - WFLYMAIL0003: Removed mail session [java:jboss/mail/Default]
[2016-09-28 10:35:19.0602], DEBUG,
org.infinispan.manager.DefaultCacheManager MSC service thread 1-7
- Stopping cache manager server on padmaka
[2016-09-28 10:35:19.0602], DEBUG,
org.wildfly.extension.undertow.ConsoleRedirectService MSC service
thread 1-2 - Stopping console redirect for default-host
[2016-09-28 10:35:19.0606], DEBUG,
org.jboss.as.connector.subsystems.datasources.CommonDeploymentService
MSC service thread 1-3 - Stopped CommonDeployment %s
[2016-09-28 10:35:19.0606], INFO ,
org.jboss.as.connector.subsystems.datasources.AbstractDataSourceAdd$2
MSC service thread 1-6 - WFLYJCA0010: Unbound data source
[java:jboss/datasources/KeycloakDS]
[2016-09-28 10:35:19.0607], DEBUG,
org.jboss.as.connector.subsystems.datasources.CommonDeploymentService
MSC service thread 1-6 - Stopped CommonDeployment %s
[2016-09-28 10:35:19.0612], DEBUG,
org.jboss.as.security.service.SecurityDomainService MSC service
thread 1-3 - Stopping security domain service jboss-web-policy
[2016-09-28 10:35:19.0624], DEBUG,
org.jboss.as.security.service.SecurityDomainService MSC service
thread 1-4 - Stopping security domain service jaspitest
[2016-09-28 10:35:19.0628], DEBUG,
org.jboss.as.connector.services.resourceadapters.deployment.registry.ResourceAdapterDeploymentRegistryService
MSC service thread 1-1 - Stopping service service jboss.raregistry
[2016-09-28 10:35:19.0628], DEBUG,
org.infinispan.manager.DefaultCacheManager MSC service thread 1-8
- Stopping cache manager web on padmaka
[2016-09-28 10:35:19.0630], DEBUG,
org.infinispan.manager.DefaultCacheManager MSC service thread 1-6
- Stopping cache manager ejb on padmaka
[2016-09-28 10:35:19.0630], INFO ,
org.infinispan.remoting.transport.jgroups.JGroupsTransport MSC
service thread 1-7 - ISPN000080: Disconnecting JGroups channel server
[2016-09-28 10:35:19.0631], DEBUG,
org.jboss.as.ejb3.remote.EJBTransactionRecoveryService$1
ServerService Thread Pool -- 62 - Un-registered
org.jboss.as.ejb3.remote.EJBTransactionRecoveryService$1@5bc6f06a
from the transaction recovery manager
[2016-09-28 10:35:19.0632], INFO ,
org.infinispan.remoting.transport.jgroups.JGroupsTransport MSC
service thread 1-7 - ISPN000082: Stopping the RpcDispatcher for
channel server
[2016-09-28 10:35:19.0638], INFO ,
org.infinispan.remoting.transport.jgroups.JGroupsTransport MSC
service thread 1-8 - ISPN000080: Disconnecting JGroups channel web
[2016-09-28 10:35:19.0638], INFO ,
org.infinispan.remoting.transport.jgroups.JGroupsTransport MSC
service thread 1-8 - ISPN000082: Stopping the RpcDispatcher for
channel web
[2016-09-28 10:35:19.0636], INFO ,
org.infinispan.remoting.transport.jgroups.JGroupsTransport MSC
service thread 1-6 - ISPN000080: Disconnecting JGroups channel ejb
[2016-09-28 10:35:19.0640], INFO ,
org.infinispan.remoting.transport.jgroups.JGroupsTransport MSC
service thread 1-6 - ISPN000082: Stopping the RpcDispatcher for
channel ejb
[2016-09-28 10:35:19.0637], DEBUG,
org.infinispan.manager.DefaultCacheManager MSC service thread 1-1
- Stopping cache manager hibernate on padmaka
[2016-09-28 10:35:19.0642], DEBUG,
org.jboss.tm.usertx.UserTransactionRegistry MSC service thread 1-2
- org.jboss.tm.usertx.UserTransactionRegistry@daa6d39
removeListener
org.jboss.as.jpa.container.JPAUserTransactionListener@47424e73
[2016-09-28 10:35:19.0642], DEBUG,
org.jboss.as.connector.subsystems.datasources.AbstractDataSourceAdd$2
MSC service thread 1-3 - Removed JDBC Data-source
[java:jboss/datasources/KeycloakDS]
[2016-09-28 10:35:19.0641], DEBUG,
org.jboss.as.clustering.infinispan.subsystem.CacheContainerBuilder
MSC service thread 1-7 - server cache container stopped
[2016-09-28 10:35:19.0641], DEBUG,
org.jboss.as.clustering.infinispan.subsystem.CacheContainerBuilder
MSC service thread 1-6 - ejb cache container stopped
[2016-09-28 10:35:19.0640], INFO ,
org.wildfly.extension.undertow.HttpsListenerService MSC service
thread 1-4 - WFLYUT0008: Undertow HTTPS listener https suspending
[2016-09-28 10:35:19.0639], DEBUG,
org.jboss.as.clustering.infinispan.subsystem.CacheContainerBuilder
MSC service thread 1-8 - web cache container stopped
[2016-09-28 10:35:19.0654], INFO ,
org.wildfly.extension.undertow.HttpsListenerService MSC service
thread 1-4 - WFLYUT0007: Undertow HTTPS listener https stopped,
was bound to 10.1.11.48:8101 <
http://10.1.11.48:8101>
[2016-09-28 10:35:19.0651], ERROR,
org.jboss.msc.service.ServiceControllerImpl$StartContextImpl
ServerService Thread Pool -- 56 - MSC000001: Failed to start
service
jboss.undertow.deployment.default-server.default-host./auth:
org.jboss.msc.service.StartException in service
jboss.undertow.deployment.default-server.default-host./auth:
java.lang.RuntimeException: RESTEASY003325: Failed to construct
public
org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:85)
at
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
at org.jboss.threads.JBossThread.run(JBossThread.java:320)
Caused by: java.lang.RuntimeException: RESTEASY003325: Failed to
construct public
org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher)
at
org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:162)
at
org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)
at
org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)
at
org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)
at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)
at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
at
org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
at
io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
at
io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)
at
io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)
at
io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)
at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
at
org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
... 6 more
Caused by: java.lang.RuntimeException: Failed to update database
at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:90)
at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:59)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.update(DefaultJpaConnectionProviderFactory.java:329)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.migration(DefaultJpaConnectionProviderFactory.java:299)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lambda$lazyInit$0(DefaultJpaConnectionProviderFactory.java:186)
at
org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:677)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:137)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:85)
at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:63)
at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:158)
at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:51)
at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:33)
at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:158)
at
org.keycloak.models.cache.infinispan.RealmCacheSession.getDelegate(RealmCacheSession.java:161)
at
org.keycloak.models.cache.infinispan.RealmCacheSession.getMigrationModel(RealmCacheSession.java:154)
at
org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:60)
at
org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:221)
at
org.keycloak.services.resources.KeycloakApplication.migrateAndBootstrap(KeycloakApplication.java:162)
at
org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:121)
at
org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:295)
at
org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:112)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
at
org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
... 19 more
Caused by: liquibase.exception.MigrationFailedException: Migration
failed for change set
META-INF/jpa-changelog-authz-2.0.0.xml::authz-2.0.0::psilva@redhat.com
<mailto:jpa-changelog-authz-2.0.0.xml%3A%3Aauthz-2.0.0%3A%3Apsilva@redhat.com>:
Reason: liquibase.exception.UnexpectedLiquibaseException:
java.sql.SQLException: IJ031040: Connection is not associated with
a managed connection:
org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@503aa43a
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:573)
at
liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:51)
at
liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
at liquibase.Liquibase.update(Liquibase.java:210)
at liquibase.Liquibase.update(Liquibase.java:190)
at liquibase.Liquibase.update(Liquibase.java:186)
at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.updateChangeSet(LiquibaseJpaUpdaterProvider.java:114)
at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:76)
... 44 more
Caused by: liquibase.exception.UnexpectedLiquibaseException:
java.sql.SQLException: IJ031040: Connection is not associated with
a managed connection:
org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@503aa43a
at
liquibase.database.jvm.JdbcConnection.getURL(JdbcConnection.java:79)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:62)
at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
at
liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1247)
at
liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1230)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:548)
... 51 more
Caused by: java.sql.SQLException: IJ031040: Connection is not
associated with a managed connection:
org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@503aa43a
at
org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)
at
org.jboss.jca.adapters.jdbc.WrappedConnection.getMetaData(WrappedConnection.java:913)
at
liquibase.database.jvm.JdbcConnection.getURL(JdbcConnection.java:77)
... 56 more
is there any solution for this?
Thanks in advance.
Padmaka
_______________________________________________ keycloak-user
mailing list keycloak-user(a)lists.jboss.org
<mailto:keycloak-user@lists.jboss.org>
https://lists.jboss.org/mailman/listinfo/keycloak-user
<
https://lists.jboss.org/mailman/listinfo/keycloak-user>
_______________________________________________
keycloak-user mailing list
keycloak-user(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user