Re: [keycloak-user] With Keycloak 2.2.1 the DB migration fails

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&gt; 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.connectionm > anager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool > ServerService Thread Pool -- 62 - IJ000615: Destroying active connection in > pool: mysql_keycloak (org.jboss.jca.adapters.jdbc.l > ocal.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(ReadAheadInput > Stream.java:100) > at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingS > treamIfNecessary(ReadAheadInputStream.java:143) > at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInput > Stream.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(Wrapped > Statement.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(AbstractJdbc > Database.java:1247) > at liquibase.database.AbstractJdbcDatabase.executeStatements(Ab > stractJdbcDatabase.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.LiquibaseJpaU > pdaterProvider.updateChangeSet(LiquibaseJpaUpdaterProvider.java:114) > at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaU > pdaterProvider.update(LiquibaseJpaUpdaterProvider.java:76) > at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaU > pdaterProvider.update(LiquibaseJpaUpdaterProvider.java:59) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.update(DefaultJpaConnectionProviderFactory.java:329) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.migration(DefaultJpaConnectionProviderFactory.java:299) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.lambda$lazyInit$0(DefaultJpaConnectionProviderFactory.java:186) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory$$Lambda$105/1378148237.run(Unknown Source) > at org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTrans > action(KeycloakModelUtils.java:677) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.lazyInit(DefaultJpaConnectionProviderFactory.java:137) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.create(DefaultJpaConnectionProviderFactory.java:85) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.create(DefaultJpaConnectionProviderFactory.java:63) > at org.keycloak.services.DefaultKeycloakSession.getProvider(Def > aultKeycloakSession.java:158) > at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRe > almProviderFactory.java:51) > at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRe > almProviderFactory.java:33) > at org.keycloak.services.DefaultKeycloakSession.getProvider(Def > aultKeycloakSession.java:158) > at org.keycloak.models.cache.infinispan.RealmCacheSession.getDe > legate(RealmCacheSession.java:161) > at org.keycloak.models.cache.infinispan.RealmCacheSession.getMi > grationModel(RealmCacheSession.java:154) > at org.keycloak.migration.MigrationModelManager.migrate(Migrati > onModelManager.java:60) > at org.keycloak.services.resources.KeycloakApplication.migrateM > odel(KeycloakApplication.java:221) > at org.keycloak.services.resources.KeycloakApplication.migrateA > ndBootstrap(KeycloakApplication.java:162) > at org.keycloak.services.resources.KeycloakApplication$1.run( > KeycloakApplication.java:121) > at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransac > tion(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(Native > ConstructorAccessorImpl.java:62) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De > legatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(Co > nstructorInjectorImpl.java:150) > at org.jboss.resteasy.spi.ResteasyProviderFactory.createProvide > rInstance(ResteasyProviderFactory.java:2209) > at org.jboss.resteasy.spi.ResteasyDeployment.createApplication( > ResteasyDeployment.java:299) > at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDepl > oyment.java:240) > at org.jboss.resteasy.plugins.server.servlet.ServletContainerDi > spatcher.init(ServletContainerDispatcher.java:113) > at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatc > her.init(HttpServletDispatcher.java:36) > at io.undertow.servlet.core.LifecyleInterceptorInvocation.proce > ed(LifecyleInterceptorInvocation.java:117) > at org.wildfly.extension.undertow.security.RunAsLifecycleInterc > eptor.init(RunAsLifecycleInterceptor.java:78) > at io.undertow.servlet.core.LifecyleInterceptorInvocation.proce > ed(LifecyleInterceptorInvocation.java:103) > at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrat > egy.start(ManagedServlet.java:231) > at io.undertow.servlet.core.ManagedServlet.createServlet(Manage > dServlet.java:132) > at io.undertow.servlet.core.DeploymentManagerImpl.start(Deploym > entManagerImpl.java:526) > at org.wildfly.extension.undertow.deployment.UndertowDeployment > Service.startContext(UndertowDeploymentService.java:101) > at org.wildfly.extension.undertow.deployment.UndertowDeployment > Service$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(ThreadPool > Executor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo > lExecutor.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-bi > n.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.u > pdater.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.u > pdater.liquibase.lock.CustomLockService ServerService Thread Pool -- 56 > - Going to release database lock > [2016-09-28 10:35:19.0595], ERROR, org.keycloak.connections.jpa.u > pdater.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(AbstractJdbcD > atabase.java:1130) > at org.keycloak.connections.jpa.updater.liquibase.lock.CustomLo > ckService.releaseLock(CustomLockService.java:184) > at org.keycloak.connections.jpa.updater.liquibase.lock.Liquibas > eDBLockProvider.lambda$releaseLock$1(LiquibaseDBLockProvider.java:126) > at org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTrans > action(KeycloakModelUtils.java:677) > at org.keycloak.connections.jpa.updater.liquibase.lock.Liquibas > eDBLockProvider.releaseLock(LiquibaseDBLockProvider.java:123) > at org.keycloak.services.resources.KeycloakApplication$1.run( > KeycloakApplication.java:123) > at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransac > tion(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(Native > ConstructorAccessorImpl.java:62) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De > legatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(Co > nstructorInjectorImpl.java:150) > at org.jboss.resteasy.spi.ResteasyProviderFactory.createProvide > rInstance(ResteasyProviderFactory.java:2209) > at org.jboss.resteasy.spi.ResteasyDeployment.createApplication( > ResteasyDeployment.java:299) > at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDepl > oyment.java:240) > at org.jboss.resteasy.plugins.server.servlet.ServletContainerDi > spatcher.init(ServletContainerDispatcher.java:113) > at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatc > her.init(HttpServletDispatcher.java:36) > at io.undertow.servlet.core.LifecyleInterceptorInvocation.proce > ed(LifecyleInterceptorInvocation.java:117) > at org.wildfly.extension.undertow.security.RunAsLifecycleInterc > eptor.init(RunAsLifecycleInterceptor.java:78) > at io.undertow.servlet.core.LifecyleInterceptorInvocation.proce > ed(LifecyleInterceptorInvocation.java:103) > at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrat > egy.start(ManagedServlet.java:231) > at io.undertow.servlet.core.ManagedServlet.createServlet(Manage > dServlet.java:132) > at io.undertow.servlet.core.DeploymentManagerImpl.start(Deploym > entManagerImpl.java:526) > at org.wildfly.extension.undertow.deployment.UndertowDeployment > Service.startContext(UndertowDeploymentService.java:101) > at org.wildfly.extension.undertow.deployment.UndertowDeployment > Service$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(ThreadPool > Executor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo > lExecutor.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(AbstractJdbcD > atabase.java:1128) > ... 31 more > Caused by: java.sql.SQLException: IJ031040: Connection is not associated > with a managed connection: org.jboss.jca.adapters.jdbc.jd > k7.WrappedConnectionJDK7@88d58a5 > at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedCo > nnection.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.subsyst > ems.datasources.CommonDeploymentService MSC service thread 1-3 - Stopped > CommonDeployment %s > [2016-09-28 10:35:19.0606], INFO , org.jboss.as.connector.subsyst > ems.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.subsyst > ems.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.service > s.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.UserTransa > ctionRegistry@daa6d39 removeListener org.jboss.as.jpa.container.JPA > UserTransactionListener@47424e73 > [2016-09-28 10:35:19.0642], DEBUG, org.jboss.as.connector.subsyst > ems.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.infini > span.subsystem.CacheContainerBuilder MSC service thread 1-7 - server > cache container stopped > [2016-09-28 10:35:19.0641], DEBUG, org.jboss.as.clustering.infini > span.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.infini > span.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 > [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.UndertowDeployment > Service$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(ThreadPool > Executor.java:1142) > at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoo > lExecutor.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.resource > s.KeycloakApplication(javax.servlet.ServletContext,org. > jboss.resteasy.core.Dispatcher) > at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(Co > nstructorInjectorImpl.java:162) > at org.jboss.resteasy.spi.ResteasyProviderFactory.createProvide > rInstance(ResteasyProviderFactory.java:2209) > at org.jboss.resteasy.spi.ResteasyDeployment.createApplication( > ResteasyDeployment.java:299) > at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDepl > oyment.java:240) > at org.jboss.resteasy.plugins.server.servlet.ServletContainerDi > spatcher.init(ServletContainerDispatcher.java:113) > at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatc > her.init(HttpServletDispatcher.java:36) > at io.undertow.servlet.core.LifecyleInterceptorInvocation.proce > ed(LifecyleInterceptorInvocation.java:117) > at org.wildfly.extension.undertow.security.RunAsLifecycleInterc > eptor.init(RunAsLifecycleInterceptor.java:78) > at io.undertow.servlet.core.LifecyleInterceptorInvocation.proce > ed(LifecyleInterceptorInvocation.java:103) > at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrat > egy.start(ManagedServlet.java:231) > at io.undertow.servlet.core.ManagedServlet.createServlet(Manage > dServlet.java:132) > at io.undertow.servlet.core.DeploymentManagerImpl.start(Deploym > entManagerImpl.java:526) > at org.wildfly.extension.undertow.deployment.UndertowDeployment > Service.startContext(UndertowDeploymentService.java:101) > at org.wildfly.extension.undertow.deployment.UndertowDeployment > Service$1.run(UndertowDeploymentService.java:82) > ... 6 more > Caused by: java.lang.RuntimeException: Failed to update database > at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaU > pdaterProvider.update(LiquibaseJpaUpdaterProvider.java:90) > at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaU > pdaterProvider.update(LiquibaseJpaUpdaterProvider.java:59) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.update(DefaultJpaConnectionProviderFactory.java:329) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.migration(DefaultJpaConnectionProviderFactory.java:299) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.lambda$lazyInit$0(DefaultJpaConnectionProviderFactory.java:186) > at org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTrans > action(KeycloakModelUtils.java:677) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.lazyInit(DefaultJpaConnectionProviderFactory.java:137) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.create(DefaultJpaConnectionProviderFactory.java:85) > at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFac > tory.create(DefaultJpaConnectionProviderFactory.java:63) > at org.keycloak.services.DefaultKeycloakSession.getProvider(Def > aultKeycloakSession.java:158) > at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRe > almProviderFactory.java:51) > at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRe > almProviderFactory.java:33) > at org.keycloak.services.DefaultKeycloakSession.getProvider(Def > aultKeycloakSession.java:158) > at org.keycloak.models.cache.infinispan.RealmCacheSession.getDe > legate(RealmCacheSession.java:161) > at org.keycloak.models.cache.infinispan.RealmCacheSession.getMi > grationModel(RealmCacheSession.java:154) > at org.keycloak.migration.MigrationModelManager.migrate(Migrati > onModelManager.java:60) > at org.keycloak.services.resources.KeycloakApplication.migrateM > odel(KeycloakApplication.java:221) > at org.keycloak.services.resources.KeycloakApplication.migrateA > ndBootstrap(KeycloakApplication.java:162) > at org.keycloak.services.resources.KeycloakApplication$1.run( > KeycloakApplication.java:121) > at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransac > tion(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(Native > ConstructorAccessorImpl.java:62) > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(De > legatingConstructorAccessorImpl.java:45) > at java.lang.reflect.Constructor.newInstance(Constructor.java:423) > at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(Co > nstructorInjectorImpl.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: > Reason: liquibase.exception.UnexpectedLiquibaseException: > java.sql.SQLException: IJ031040: Connection is not associated with a > managed connection: org.jboss.jca.adapters.jdbc.jd > k7.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.LiquibaseJpaU > pdaterProvider.updateChangeSet(LiquibaseJpaUpdaterProvider.java:114) > at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaU > pdaterProvider.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.jd > k7.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(AbstractJdbc > Database.java:1247) > at liquibase.database.AbstractJdbcDatabase.executeStatements(Ab > stractJdbcDatabase.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.jd > k7.WrappedConnectionJDK7@503aa43a > at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedCo > nnection.java:164) > at org.jboss.jca.adapters.jdbc.WrappedConnection.getMetaData(Wr > appedConnection.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 https://lists.jboss.org/mailma > n/listinfo/keycloak-user _______________________________________________ keycloak-user mailing listkeycloak-user@lists.jboss.orghttps://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