getting the error when I am trying to connect my mysql server with keycloak at my local in standalone mode.

[aman.jaiswal]

HI team

I am getting the following error when I am trying to connect my mysql server with keycloak at my local in standalone mode.

Can anyone please help me for the same .....

error is also attached in file named "keycloak-error.txt"

tech@tech-Inspiron-5558:~/keycloak-2.1.0.Final$ ./bin/standalone.sh

=========================================================================

  JBoss Bootstrap Environment

  JBOSS_HOME: /home/tech/keycloak-2.1.0.Final

  JAVA: java

  JAVA_OPTS:  -server -Xms64m -Xmx512m -XX:MetaspaceSize=96M -XX:MaxMetaspaceSize=256m -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true

=========================================================================

14:47:06,415 INFO  [org.jboss.modules] (main) JBoss Modules version 1.5.1.Final

14:47:06,601 INFO  [org.jboss.msc] (main) JBoss MSC version 1.2.6.Final

14:47:06,670 INFO  [org.jboss.as] (MSC service thread 1-6) WFLYSRV0049: Keycloak 2.1.0.Final (WildFly Core 2.0.10.Final) starting

14:47:07,808 INFO  [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0039: Creating http management service using socket-binding (management-http)

14:47:07,828 INFO  [org.xnio] (MSC service thread 1-4) XNIO version 3.3.4.Final

14:47:07,843 INFO  [org.xnio.nio] (MSC service thread 1-4) XNIO NIO Implementation Version 3.3.4.Final

14:47:07,899 INFO  [org.wildfly.extension.io] (ServerService Thread Pool -- 29) WFLYIO001: Worker 'default' has auto-configured to 8 core threads with 64 task threads based on your 4 available processors

14:47:07,902 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 30) WFLYCLINF0001: Activating Infinispan subsystem.

14:47:07,920 INFO  [org.jboss.as.connector] (MSC service thread 1-2) WFLYJCA0009: Starting JCA Subsystem (WildFly/IronJacamar 1.3.2.Final)

14:47:07,983 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) WFLYJCA0005: Deploying non-JDBC-compliant driver class com.mysql.jdbc.Driver (version 5.1)

14:47:07,989 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-6) WFLYJCA0018: Started Driver service with driver-name = mysql

14:47:07,995 INFO  [org.jboss.as.jsf] (ServerService Thread Pool -- 36) WFLYJSF0007: Activated the following JSF Implementations: [main]

14:47:07,997 INFO  [org.jboss.as.connector.subsystems.datasources] (ServerService Thread Pool -- 26) WFLYJCA0004: Deploying JDBC-compliant driver class org.h2.Driver (version 1.3)

14:47:07,998 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-2) WFLYJCA0018: Started Driver service with driver-name = h2

14:47:08,021 INFO  [org.jboss.as.naming] (ServerService Thread Pool -- 38) WFLYNAM0001: Activating Naming Subsystem

14:47:08,022 WARN  [org.jboss.as.txn] (ServerService Thread Pool -- 43) WFLYTX0013: Node identifier property is set to the default value. Please make sure it is unique.

14:47:08,057 INFO  [org.jboss.as.security] (ServerService Thread Pool -- 42) WFLYSEC0002: Activating Security Subsystem

14:47:08,058 INFO  [org.jboss.remoting] (MSC service thread 1-1) JBoss Remoting version 4.0.18.Final

14:47:08,077 INFO  [org.jboss.as.naming] (MSC service thread 1-2) WFLYNAM0003: Starting Naming Service

14:47:08,078 INFO  [org.jboss.as.mail.extension] (MSC service thread 1-2) WFLYMAIL0001: Bound mail session [java:jboss/mail/Default]

14:47:08,083 INFO  [org.jboss.as.security] (MSC service thread 1-3) WFLYSEC0001: Current PicketBox version=4.9.4.Final

14:47:08,282 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-6) WFLYUT0003: Undertow 1.3.15.Final starting

14:47:08,289 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 44) WFLYUT0003: Undertow 1.3.15.Final starting

14:47:08,430 INFO  [org.wildfly.extension.undertow] (ServerService Thread Pool -- 44) WFLYUT0014: Creating file handler for path '/home/tech/keycloak-2.1.0.Final/welcome-content' with options [directory-listing: 'false', follow-symlink: 'false', case-sensitive: 'true', safe-symlink-paths: '[]']

14:47:08,457 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0012: Started server default-server.

14:47:08,470 INFO  [org.jboss.as.ejb3] (MSC service thread 1-6) WFLYEJB0482: Strict pool mdb-strict-max-pool is using a max instance size of 16 (per class), which is derived from the number of CPUs on this host.

14:47:08,471 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-5) WFLYUT0018: Host default-host starting

14:47:08,474 INFO  [org.jboss.as.ejb3] (MSC service thread 1-3) WFLYEJB0481: Strict pool slsb-strict-max-pool is using a max instance size of 64 (per class), which is derived from thread worker pool sizing.

14:47:08,582 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0006: Undertow HTTP listener default listening on 127.0.0.1:8080

14:47:08,707 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-8) WFLYJCA0001: Bound data source [java:jboss/datasources/KeycloakDS]

14:47:08,713 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) WFLYJCA0001: Bound data source [java:jboss/datasources/ExampleDS]

14:47:08,913 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) WFLYSRV0027: Starting deployment of "keycloak-server.war" (runtime-name: "keycloak-server.war")

14:47:09,052 INFO  [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-1) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final

14:47:09,053 INFO  [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-5) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final

14:47:09,053 INFO  [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-7) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final

14:47:09,053 INFO  [org.infinispan.factories.GlobalComponentRegistry] (MSC service thread 1-2) ISPN000128: Infinispan version: Infinispan 'Mahou' 8.1.0.Final

14:47:09,425 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 50) WFLYCLINF0002: Started loginFailures cache from keycloak container

14:47:09,428 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 46) WFLYCLINF0002: Started sessions cache from keycloak container

14:47:09,427 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 48) WFLYCLINF0002: Started realms cache from keycloak container

14:47:09,426 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 51) WFLYCLINF0002: Started work cache from keycloak container

14:47:09,426 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 52) WFLYCLINF0002: Started offlineSessions cache from keycloak container

14:47:09,433 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 49) WFLYCLINF0002: Started users cache from keycloak container

14:47:10,106 INFO  [org.keycloak.services] (ServerService Thread Pool -- 49) KC-SERVICES0001: Loading config from /home/tech/keycloak-2.1.0.Final/standalone/configuration/keycloak-server.json

14:47:15,752 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 49) WFLYCLINF0002: Started userRevisions cache from keycloak container

14:47:15,760 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 49) WFLYCLINF0002: Started realmRevisions cache from keycloak container

14:47:23,980 INFO  [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (ServerService Thread Pool -- 49) Updating database. Using changelog META-INF/jpa-changelog-master.xml

14:48:25,489 INFO  [org.hibernate.jpa.internal.util.LogHelper] (ServerService Thread Pool -- 49) HHH000204: Processing PersistenceUnitInfo [

  name: keycloak-default

  ...]

14:48:25,539 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 49) HHH000412: Hibernate Core {5.0.7.Final}

14:48:25,540 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 49) HHH000206: hibernate.properties not found

14:48:25,541 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 49) HHH000021: Bytecode provider name : javassist

14:48:25,572 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 49) HCANN000001: Hibernate Commons Annotations {5.0.1.Final}

14:48:28,505 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 49) HHH000400: Using dialect: org.hibernate.dialect.MySQL5Dialect

14:48:28,524 INFO  [org.hibernate.engine.jdbc.env.internal.LobCreatorBuilderImpl] (ServerService Thread Pool -- 49) HHH000423: Disabling contextual LOB creation as JDBC driver reported JDBC version [3] less than 4

14:48:28,531 INFO  [org.hibernate.envers.boot.internal.EnversServiceImpl] (ServerService Thread Pool -- 49) Envers integration enabled? : true

14:48:29,003 INFO  [org.hibernate.validator.internal.util.Version] (ServerService Thread Pool -- 49) HV000001: Hibernate Validator 5.2.3.Final

14:48:29,821 INFO  [org.hibernate.hql.internal.QueryTranslatorFactoryInitiator] (ServerService Thread Pool -- 49) HHH000397: Using ASTQueryTranslatorFactory

14:52:08,901 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0348: Timeout after [300] seconds waiting for service container stability. Operation will roll back. Step that first updated the service container was 'add' at address '[

    ("core-service" => "management"),

    ("management-interface" => "http-interface")

]'

14:52:13,905 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.server.DeployerChainAddHandler$FinalRuntimeStepHandler@3de7a15 for operation {"operation" => "add-deployer-chains","address" => []} at address [] failed handling operation rollback -- java.util.concurrent.TimeoutException: java.util.concurrent.TimeoutException

  at org.jboss.as.controller.OperationContextImpl.waitForRemovals(OperationContextImpl.java:511)

  at org.jboss.as.controller.AbstractOperationContext$Step.handleResult(AbstractOperationContext.java:1369)

  at org.jboss.as.controller.AbstractOperationContext$Step.finalizeInternal(AbstractOperationContext.java:1328)

  at org.jboss.as.controller.AbstractOperationContext$Step.finalizeStep(AbstractOperationContext.java:1301)

  at org.jboss.as.controller.AbstractOperationContext$Step.access$300(AbstractOperationContext.java:1185)

  at org.jboss.as.controller.AbstractOperationContext.executeResultHandlerPhase(AbstractOperationContext.java:767)

  at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:644)

  at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370)

  at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344)

  at org.jboss.as.controller.ModelControllerImpl.boot(ModelControllerImpl.java:485)

  at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:387)

  at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:349)

  at org.jboss.as.server.ServerService.boot(ServerService.java:392)

  at org.jboss.as.server.ServerService.boot(ServerService.java:365)

  at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:299)

  at java.lang.Thread.run(Thread.java:745)

14:52:13,907 ERROR [org.jboss.as.controller.client] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.server.DeployerChainAddHandler$FinalRuntimeStepHandler@3de7a15 for operation {"operation" => "add-deployer-chains","address" => []} at address [] failed handling operation rollback -- java.util.concurrent.TimeoutException

14:52:18,908 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.domain.management.security.SecurityRealmAddHandler$ServiceInstallStepHandler@762cad33 for operation {"address" => [("core-service" => "management"),("security-realm" => "ApplicationRealm")],"operation" => "add","map-groups-to-roles" => undefined} at address [

    ("core-service" => "management"),

    ("security-realm" => "ApplicationRealm")

] failed handling operation rollback -- java.util.concurrent.TimeoutException: java.util.concurrent.TimeoutException

  at org.jboss.as.controller.OperationContextImpl.waitForRemovals(OperationContextImpl.java:511)

  at org.jboss.as.controller.AbstractOperationContext$Step.handleResult(AbstractOperationContext.java:1369)

  at org.jboss.as.controller.AbstractOperationContext$Step.finalizeInternal(AbstractOperationContext.java:1328)

  at org.jboss.as.controller.AbstractOperationContext$Step.finalizeStep(AbstractOperationContext.java:1311)

  at org.jboss.as.controller.AbstractOperationContext$Step.access$300(AbstractOperationContext.java:1185)

  at org.jboss.as.controller.AbstractOperationContext.executeResultHandlerPhase(AbstractOperationContext.java:767)

  at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:644)

  at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370)

  at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344)

  at org.jboss.as.controller.ModelControllerImpl.boot(ModelControllerImpl.java:485)

  at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:387)

  at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:349)

  at org.jboss.as.server.ServerService.boot(ServerService.java:392)

  at org.jboss.as.server.ServerService.boot(ServerService.java:365)

  at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:299)

  at java.lang.Thread.run(Thread.java:745)

14:52:18,909 ERROR [org.jboss.as.controller.client] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.domain.management.security.SecurityRealmAddHandler$ServiceInstallStepHandler@762cad33 for operation {"address" => [("core-service" => "management"),("security-realm" => "ApplicationRealm")],"operation" => "add","map-groups-to-roles" => undefined} at address [

    ("core-service" => "management"),

    ("security-realm" => "ApplicationRealm")

] failed handling operation rollback -- java.util.concurrent.TimeoutException

14:52:23,909 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.domain.management.security.SecurityRealmAddHandler$ServiceInstallStepHandler@762cad33 for operation {"address" => [("core-service" => "management"),("security-realm" => "ManagementRealm")],"operation" => "add","map-groups-to-roles" => false} at address [

    ("core-service" => "management"),

    ("security-realm" => "ManagementRealm")

] failed handling operation rollback -- java.util.concurrent.TimeoutException: java.util.concurrent.TimeoutException

  at org.jboss.as.controller.OperationContextImpl.waitForRemovals(OperationContextImpl.java:511)

  at org.jboss.as.controller.AbstractOperationContext$Step.handleResult(AbstractOperationContext.java:1369)

  at org.jboss.as.controller.AbstractOperationContext$Step.finalizeInternal(AbstractOperationContext.java:1328)

  at org.jboss.as.controller.AbstractOperationContext$Step.finalizeStep(AbstractOperationContext.java:1311)

  at org.jboss.as.controller.AbstractOperationContext$Step.access$300(AbstractOperationContext.java:1185)

  at org.jboss.as.controller.AbstractOperationContext.executeResultHandlerPhase(AbstractOperationContext.java:767)

  at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:644)

  at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370)

  at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344)

  at org.jboss.as.controller.ModelControllerImpl.boot(ModelControllerImpl.java:485)

  at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:387)

  at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:349)

  at org.jboss.as.server.ServerService.boot(ServerService.java:392)

  at org.jboss.as.server.ServerService.boot(ServerService.java:365)

  at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:299)

  at java.lang.Thread.run(Thread.java:745)

14:52:23,910 ERROR [org.jboss.as.controller.client] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.domain.management.security.SecurityRealmAddHandler$ServiceInstallStepHandler@762cad33 for operation {"address" => [("core-service" => "management"),("security-realm" => "ManagementRealm")],"operation" => "add","map-groups-to-roles" => false} at address [

    ("core-service" => "management"),

    ("security-realm" => "ManagementRealm")

] failed handling operation rollback -- java.util.concurrent.TimeoutException

14:52:28,911 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.controller.AbstractControllerService$ModelControllerServiceInitializationBootStepHandler$1@6098044e for operation {"operation" => "boottime-controller-initializer-step","address" => []} at address [] failed handling operation rollback -- java.util.concurrent.TimeoutException: java.util.concurrent.TimeoutException

  at org.jboss.as.controller.OperationContextImpl.waitForRemovals(OperationContextImpl.java:511)

  at org.jboss.as.controller.AbstractOperationContext$Step.handleResult(AbstractOperationContext.java:1369)

  at org.jboss.as.controller.AbstractOperationContext$Step.finalizeInternal(AbstractOperationContext.java:1328)

  at org.jboss.as.controller.AbstractOperationContext$Step.finalizeStep(AbstractOperationContext.java:1311)

  at org.jboss.as.controller.AbstractOperationContext$Step.access$300(AbstractOperationContext.java:1185)

  at org.jboss.as.controller.AbstractOperationContext.executeResultHandlerPhase(AbstractOperationContext.java:767)

  at org.jboss.as.controller.AbstractOperationContext.processStages(AbstractOperationContext.java:644)

  at org.jboss.as.controller.AbstractOperationContext.executeOperation(AbstractOperationContext.java:370)

  at org.jboss.as.controller.OperationContextImpl.executeOperation(OperationContextImpl.java:1344)

  at org.jboss.as.controller.ModelControllerImpl.boot(ModelControllerImpl.java:485)

  at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:387)

  at org.jboss.as.controller.AbstractControllerService.boot(AbstractControllerService.java:349)

  at org.jboss.as.server.ServerService.boot(ServerService.java:392)

  at org.jboss.as.server.ServerService.boot(ServerService.java:365)

  at org.jboss.as.controller.AbstractControllerService$1.run(AbstractControllerService.java:299)

  at java.lang.Thread.run(Thread.java:745)

14:52:28,912 ERROR [org.jboss.as.controller.client] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.controller.AbstractControllerService$ModelControllerServiceInitializationBootStepHandler$1@6098044e for operation {"operation" => "boottime-controller-initializer-step","address" => []} at address [] failed handling operation rollback -- java.util.concurrent.TimeoutException

14:52:28,913 ERROR [org.jboss.as.server] (ServerService Thread Pool -- 45) WFLYSRV0022: Deploy of deployment "keycloak-server.war" was rolled back with no failure message

14:52:28,926 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-7) WFLYJCA0010: Unbound data source [java:jboss/datasources/KeycloakDS]

14:52:28,933 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 28) IJ000615: Destroying active connection in pool: KeycloakDS (org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@701fdf12)

14:52:28,933 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 28) IJ000615: Destroying active connection in pool: KeycloakDS (org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@6d4fadd8)

14:52:28,935 WARN  [org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory] (ServerService Thread Pool -- 28) IJ030022: Lock owned during cleanup: ServerService Thread Pool -- 49: java.lang.Throwable: Lock owned during cleanup: ServerService Thread Pool -- 49

  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:113)

  at com.mysql.jdbc.util.ReadAheadInputStream.readFromUnderlyingStreamIfNecessary(ReadAheadInputStream.java:160)

  at com.mysql.jdbc.util.ReadAheadInputStream.read(ReadAheadInputStream.java:188)

  at com.mysql.jdbc.MysqlIO.readFully(MysqlIO.java:2494)

  at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2949)

  at com.mysql.jdbc.MysqlIO.reuseAndReadPacket(MysqlIO.java:2938)

  at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3481)

  at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)

  at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)

  at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2643)

  at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)

  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362)

  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2280)

  at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2265)

  at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)

  at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)

  at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)

  at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1313)

  at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:80)

  at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560)

  at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)

  at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)

  at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

  at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1300)

  at sun.reflect.GeneratedMethodAccessor310.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:498)

  at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:49)

  at com.sun.proxy.$Proxy62.flush(Unknown Source)

  at org.keycloak.models.jpa.RoleAdapter.addCompositeRole(RoleAdapter.java:105)

  at org.keycloak.migration.migrators.MigrationUtils.addAdminRole(MigrationUtils.java:35)

  at org.keycloak.migration.migrators.MigrateTo2_0_0.migrateAuthorizationServices(MigrateTo2_0_0.java:39)

  at org.keycloak.migration.migrators.MigrateTo2_0_0.migrate(MigrateTo2_0_0.java:32)

  at org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:108)

  at org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:184)

  at org.keycloak.services.resources.KeycloakApplication.migrateAndBootstrap(KeycloakApplication.java:141)

  at org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:106)

  at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:287)

  at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:97)

  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)

14:52:29,019 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 49) SQL Error: 0, SQLState: null

14:52:29,020 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 49) IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@1db6144

14:52:29,048 ERROR [org.keycloak.services] (ServerService Thread Pool -- 49) KC-SERVICES0002: Failed to migrate datamodel: org.keycloak.models.ModelException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement

  at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:61)

  at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:51)

  at com.sun.proxy.$Proxy62.flush(Unknown Source)

  at org.keycloak.models.jpa.RoleAdapter.addCompositeRole(RoleAdapter.java:105)

  at org.keycloak.migration.migrators.MigrationUtils.addAdminRole(MigrationUtils.java:35)

  at org.keycloak.migration.migrators.MigrateTo2_0_0.migrateAuthorizationServices(MigrateTo2_0_0.java:39)

  at org.keycloak.migration.migrators.MigrateTo2_0_0.migrate(MigrateTo2_0_0.java:32)

  at org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:108)

  at org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:184)

  at org.keycloak.services.resources.KeycloakApplication.migrateAndBootstrap(KeycloakApplication.java:141)

  at org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:106)

  at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:287)

  at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:97)

  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: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1303)

  at sun.reflect.GeneratedMethodAccessor310.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:498)

  at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:49)

  ... 35 more

Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement

  at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)

  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)

  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)

  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:78)

  at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.buildBatchStatement(AbstractBatchImpl.java:136)

  at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.getBatchStatement(AbstractBatchImpl.java:125)

  at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1287)

  at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:80)

  at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560)

  at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)

  at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)

  at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

  at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1300)

  ... 39 more

Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@1db6144

  at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)

  at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:444)

  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:87)

  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)

  ... 50 more

14:52:29,050 ERROR [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (ServerService Thread Pool -- 49) 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@3689a0ee

  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.releaseLock(LiquibaseDBLockProvider.java:121)

  at org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:108)

  at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:287)

  at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:97)

  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@3689a0ee

  at liquibase.database.jvm.JdbcConnection.commit(JdbcConnection.java:126)

  at liquibase.database.AbstractJdbcDatabase.commit(AbstractJdbcDatabase.java:1128)

  ... 29 more

Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@3689a0ee

  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)

  ... 30 more

14:52:29,060 ERROR [org.jboss.msc.service.fail] (ServerService Thread Pool -- 49) 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: org.keycloak.models.ModelException: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement

  at org.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:61)

  at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:51)

  at com.sun.proxy.$Proxy62.flush(Unknown Source)

  at org.keycloak.models.jpa.RoleAdapter.addCompositeRole(RoleAdapter.java:105)

  at org.keycloak.migration.migrators.MigrationUtils.addAdminRole(MigrationUtils.java:35)

  at org.keycloak.migration.migrators.MigrateTo2_0_0.migrateAuthorizationServices(MigrateTo2_0_0.java:39)

  at org.keycloak.migration.migrators.MigrateTo2_0_0.migrate(MigrateTo2_0_0.java:32)

  at org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:108)

  at org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:184)

  at org.keycloak.services.resources.KeycloakApplication.migrateAndBootstrap(KeycloakApplication.java:141)

  at org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:106)

  at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:287)

  at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:97)

  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: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not prepare statement

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1303)

  at sun.reflect.GeneratedMethodAccessor310.invoke(Unknown Source)

  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

  at java.lang.reflect.Method.invoke(Method.java:498)

  at org.keycloak.connections.jpa.PersistenceExceptionConverter.invoke(PersistenceExceptionConverter.java:49)

  ... 35 more

Caused by: org.hibernate.exception.GenericJDBCException: could not prepare statement

  at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)

  at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)

  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:182)

  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareStatement(StatementPreparerImpl.java:78)

  at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.buildBatchStatement(AbstractBatchImpl.java:136)

  at org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl.getBatchStatement(AbstractBatchImpl.java:125)

  at org.hibernate.persister.collection.AbstractCollectionPersister.recreate(AbstractCollectionPersister.java:1287)

  at org.hibernate.action.internal.CollectionUpdateAction.execute(CollectionUpdateAction.java:80)

  at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:560)

  at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:434)

  at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)

  at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

  at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1282)

  at org.hibernate.jpa.spi.AbstractEntityManagerImpl.flush(AbstractEntityManagerImpl.java:1300)

  ... 39 more

Caused by: java.sql.SQLException: IJ031040: Connection is not associated with a managed connection: org.jboss.jca.adapters.jdbc.jdk7.WrappedConnectionJDK7@1db6144

  at org.jboss.jca.adapters.jdbc.WrappedConnection.lock(WrappedConnection.java:164)

  at org.jboss.jca.adapters.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:444)

  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$1.doPrepare(StatementPreparerImpl.java:87)

  at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:172)

  ... 50 more

14:52:29,068 INFO  [org.jboss.as.connector.subsystems.datasources] (MSC service thread 1-3) WFLYJCA0010: Unbound data source [java:jboss/datasources/ExampleDS]

14:52:29,077 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0008: Undertow HTTP listener default suspending

14:52:29,074 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 30) WFLYCLINF0003: Stopped work cache from keycloak container

14:52:29,079 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-1) WFLYUT0007: Undertow HTTP listener default stopped, was bound to 127.0.0.1:8080

14:52:29,074 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 44) WFLYCLINF0003: Stopped loginFailures cache from keycloak container

14:52:29,065 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0019: Host default-host stopping

14:52:29,081 INFO  [org.wildfly.extension.undertow] (MSC service thread 1-4) WFLYUT0004: Undertow 1.3.15.Final stopping

14:52:29,073 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 43) WFLYCLINF0003: Stopped offlineSessions cache from keycloak container

14:52:29,073 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-5) WFLYJCA0019: Stopped Driver service with driver-name = h2

14:52:29,072 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 42) WFLYCLINF0003: Stopped users cache from keycloak container

14:52:29,072 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 49) WFLYCLINF0003: Stopped sessions cache from keycloak container

14:52:29,093 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-3) WFLYSRV0028: Stopped deployment keycloak-server.war (runtime-name: keycloak-server.war) in 20188ms

14:52:29,098 INFO  [org.jboss.as.clustering.infinispan] (ServerService Thread Pool -- 36) WFLYCLINF0003: Stopped realms cache from keycloak container

14:52:29,112 INFO  [org.jboss.as.clustering.infinispan] (MSC service thread 1-3) WFLYCLINF0003: Stopped realmRevisions cache from keycloak container

14:52:29,122 INFO  [org.jboss.as.clustering.infinispan] (MSC service thread 1-3) WFLYCLINF0003: Stopped userRevisions cache from keycloak container

14:52:29,494 INFO  [org.jboss.as.connector.deployers.jdbc] (MSC service thread 1-8) WFLYJCA0019: Stopped Driver service with driver-name = mysql

14:52:29,504 FATAL [org.jboss.as.server] (Controller Boot Thread) WFLYSRV0056: Server boot has failed in an unrecoverable manner; exiting. See previous messages for details.

14:52:29,514 INFO  [org.jboss.as.server] (Thread-2) WFLYSRV0220: Server shutdown has been requested.

14:52:29,524 INFO  [org.jboss.as] (MSC service thread 1-8) WFLYSRV0050: Keycloak 2.1.0.Final (WildFly Core 2.0.10.Final) stopped in 6ms

[mayerw01]

>>>> "Unbound data source [java:jboss/datasources/KeycloakDS"

Is your mysql server up and your data source enabled?

[aman.jaiswal]

yes it is

[aman.jaiswal]

Hi  I am changed the time limit from 300 to 600 and it's work but I want to know that why it is not working on 300 sec of default time ?

[aman.jaiswal]

Hi  I am changed the time limit from 300 to 600 and it's work but I want to know that why it is not working on 300 sec of default time ?

[aman.jaiswal]

Hi can one please tell me what is the use of

  ("core-service" => "management"),

    ("management-interface" => "http-interface")

because of this I am getting the following error and it is only solved by increasing the default time limit.

Timeout after [300] seconds waiting for service container stability. Operation will roll back. Step that first updated the service container was 'add' at address '[

    ("core-service" => "management"),

    ("management-interface" => "http-interface")

]'

[vishrant.gupta]

How did you changed the time from 300 to 600?

[andey]

The error indicates an attempt to close a connection which has already been released to the pool (i.e. closed).

- This usually indicates either multiple components attempting to "own" the same connection reference or incorrect order of operations.

- This indicate an attempt to use a connection reference after the connection has been returned to the pool (i.e. it no longer belongs to the application component)

JBoss encapsulates physical data source connections in wrapper instances (which implement java.sql.Connection) which are returned to client code which calls getConnection().

The exception, "Connection is not associated with a managed connection", indicates that access to a connection wrapper has been attempted after the physical connection has been unlinked/separated from the wrapper.

- This can occur if the connection has failed or an associated transaction has been terminated by JBoss.

- This can occur if the application code calls close() on the wrapper then attempts to use the wrapper subsequently.

- This can be occurred whether your application source code caching the resource like Connection, Statement, ResultSet, etc. objects references (i.e. any object which may retain a reference to or use a connection when accessed)

somewhere in your application code.

- The above Errors such as  are also concerning an usually indicate application or 3rd party code mishandling of connections. This means that application or 3rd party code is attempting to use a connection that it no longer owns (i.e. usually one that has been returned to the pool by calling close())

In general, a connection should be obtained, used and closed in the same code block to avoid the potential for reference sharing. Each component should have its own connection reference (created by calling getConnection() on the datasource) even where the references are different proxies (which is what JBoss returns) for the same physical database connection. This approach helps to avoid errors such as "not associated" which may occur when multiple components are sharing the same reference (rather than different proxies created by different getConnection() calls).