[keycloak-user] LockAcquisitionException and Lock wait timeout exceeded exception in events

Tue Mar 19 05:59:30 EDT 2019

 Nope, i Meant, i already have these settingMin Pool Size:50Max Pool Size:100Flush Strategy:IdleConnectionsPool Fair:truePool Prefill:falsePool Use Strict Min:falseUse Fast Fail:false
 and it did not help :(
    On Tuesday, 19 March, 2019, 2:03:48 pm IST, Marek Posolda <mposolda at redhat.com> wrote:  

  Cool, it can help maybe. You will see... Another thing is, that we know that big number of realms is causing issues. There are some improvements planned, hopefully for this year. 
  Marek 
  On 19/03/2019 06:23, Madhu wrote:

  Hi Marek, 
  Thanks for quick response. 
  I double checked my connection pool settings, this is what i have configured  Min Pool Size:50 Max Pool Size:100 Flush Strategy:IdleConnections Pool Fair:true Pool Prefill:false Pool Use Strict Min:false Use Fast Fail:false 
  Do you think i need to change this,  i donth think the system is starving for connections.. will dig more deep here and get back. 

  Madhu     On Tuesday, 19 March, 2019, 2:51:39 am IST, Madhu <kkcmadhu at yahoo.com> wrote:  

    Realm is tenant in my case. I have more than 600 realms and each realm has about 6 clients (excluding what gets shipped by default). There are 2 realm roles and 2 to 3 client roles per client, I have a scriptmapper and 2 groups and about 10 users in each realm. My Max db connection is 30. Let me check that again try increasing it..
 Madhu

 Sent from Yahoo Mail on Android 

  On Tue, 19 Mar 2019 at 2:21 AM, Marek Posolda <mposolda at redhat.com> wrote:     Hi, 
  what exactly is "tenant" in your case? Is it client or realm? 
  We know that there are some issues with big number of those entities, so you will probably see issues with 500 or more realms/clients. Maybe it helps to increase count of max DB connections -  both at the datasource level in standalone(-ha).xml and in the settings of your MySQL DB. But not really sure... 
  Marek 
   On 18/03/2019 15:59, Madhu wrote:

     Hi , 
  I am using keycloak 4.5.0.Final in one on my projects and  i have fairly large number of tenants (> 500). Off late i see frequently  lock acquisation related errors and timeout. 

  I am not able to figure out where and how this is origniating? can you please help? 
  My suspecion is  is this related to events logging? could this be because of farily large number of entrys in the audit/ events table? 
  Note the thread id default task-19354 in the for event REFRESH_TOKEN_ERROR and corresponding thread throwing LockAcquisitionException 
  Regards, Madhu 

    2019-03-17 17:14:47,010 WARN  [org.keycloak.events] (default task-19354) type=REFRESH_TOKEN_ERROR, realmId=*********, clientId=null, userId=null, ipAddress= xx.yy.zz.aaa,  error=invalid_client_credentials, grant_type=refresh_token 2019-03-17 17:15:13,183 WARN  [org.keycloak.events] (default task-19354) type=REFRESH_TOKEN_ERROR, realmId=*********, clientId=null, userId=null, ipAddress=xx.yy.zz.aaa, error=invalid_client_credentials, grant_type=refresh_token 2019-03-17 17:24:31,128 WARN  [org.keycloak.events] (default task-19353) type=REFRESH_TOKEN_ERROR, realmId=*********, clientId=null, userId=null, ipAddress=xx.yy.zz.aaa, error=invalid_client_credentials, grant_type=refresh_token 2019-03-17 17:46:17,677 WARN  [org.keycloak.events] (default task-19353) type=REFRESH_TOKEN_ERROR, realmId=*********, clientId=null, userId=null, ipAddress=xx.yy.zz.aaa, error=invalid_client_credentials, grant_type=refresh_token 2019-03-17 17:47:00,850 WARN  [org.keycloak.events] (default task-19353) type=REFRESH_TOKEN_ERROR, realmId=*********, clientId=null, userId=null, ipAddress=xx.yy.zz.aaa, error=invalid_client_credentials, grant_type=refresh_token 2019-03-17 18:46:48,058 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-19354) SQL Error: 1205, SQLState: 40001 2019-03-17 18:46:48,059 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-19354) Lock wait timeout exceeded; try restarting transaction 2019-03-17 18:46:48,059 INFO  [org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl] (default task-19354) HHH000010: On release of batch it still contained JDBC statements 2019-03-17 18:46:48,077 WARN  [com.arjuna.ats.arjuna] (default task-19354) ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffffc0a803b1:-a9285f2:5bf97526:bb36de,org.wildfly.transaction.client.AbstractTransaction$AssociatingSynchronization at 5ad70e16 >: javax.persistence.PersistenceException:org.hibernate.exception.LockAcquisitionException: could not execute statement  atorg.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1692)  atorg.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)  atorg.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1608)  atorg.hibernate.jpa.internal.EntityManagerImpl$CallbackExceptionMapperImpl.mapManagedFlushFailure(EntityManagerImpl.java:235)  atorg.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3163)  atorg.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352)  atorg.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:491)  atorg.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorImpl.beforeCompletion(JtaTransactionCoordinatorImpl.java:316)  atorg.hibernate.resource.transaction.backend.jta.internal.synchronization.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:47)  atorg.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:37)  atorg.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:236)  atorg.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:247)  atorg.wildfly.transaction.client.AbstractTransaction$AssociatingSynchronization.beforeCompletion(AbstractTransaction.java:292)  atcom.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)  atcom.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:368)  atcom.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:91)  atcom.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)  atcom.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1289)  atcom.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)  atcom.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:89)  atorg.wildfly.transaction.client.LocalTransaction.commitAndDissociate(LocalTransaction.java:77)  atorg.wildfly.transaction.client.ContextTransactionManager.commit(ContextTransactionManager.java:71)  atorg.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:92)  atorg.keycloak.services.DefaultKeycloakTransactionManager.commit(DefaultKeycloakTransactionManager.java:136)  atorg.keycloak.services.filters.KeycloakTransactionCommitter.filter(KeycloakTransactionCommitter.java:43)  atorg.jboss.resteasy.core.interception.ContainerResponseContextImpl.filter(ContainerResponseContextImpl.java:353)  atorg.jboss.resteasy.core.ServerResponseWriter.executeFilters(ServerResponseWriter.java:207)  atorg.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:85)  atorg.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:59)  atorg.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:530)  atorg.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:461)  atorg.jboss.resteasy.core.SynchronousDispatcher.lambda$invoke$4(SynchronousDispatcher.java:231)  atorg.jboss.resteasy.core.SynchronousDispatcher.lambda$preprocess$0(SynchronousDispatcher.java:137)  atorg.jboss.resteasy.core.interception.PreMatchContainerRequestContext.filter(PreMatchContainerRequestContext.java:361)  atorg.jboss.resteasy.core.SynchronousDispatcher.preprocess(SynchronousDispatcher.java:140)  atorg.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:217)  atorg.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:227)  atorg.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)  atorg.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)  atjavax.servlet.http.HttpServlet.service(HttpServlet.java:790)  atio.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)  atio.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)  atorg.keycloak.services.filters.KeycloakSessionServletFilter.doFilter(KeycloakSessionServletFilter.java:90)  atio.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)  atio.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)  atio.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)  atio.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)  atio.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)  atio.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)  atorg.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atio.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)  atio.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atio.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)  atio.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)  atio.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)  atio.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)  atio.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)  atio.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atorg.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atorg.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atio.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)  atio.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)  atio.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)  atio.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)  atio.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)  atio.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)  atorg.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)  atorg.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)  atorg.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)  atorg.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)  atorg.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)  atio.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)  atio.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)  atio.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)  atio.undertow.server.Connectors.executeRootHandler(Connectors.java:360)  atio.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)  atorg.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)  atorg.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)  atorg.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)  atorg.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)  atjava.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement  atorg.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:511)  atorg.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)  atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)  atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)  atorg.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)  atorg.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)  atorg.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3013)  atorg.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3513)  atorg.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)  atorg.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589)  atorg.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)  atorg.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)  atorg.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)  atorg.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)  atorg.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468)  atorg.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3159)  ... 81 more Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction  atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)  atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)  atcom.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1116)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1066)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1396)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1051)  atorg.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)  atorg.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)  ... 92 more 
  2019-03-17 18:46:48,558 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (default task-19354) Uncaught server error: org.keycloak.models.ModelException:org.hibernate.exception.LockAcquisitionException: could not execute  statement  atorg.keycloak.connections.jpa.PersistenceExceptionConverter.convert(PersistenceExceptionConverter.java:61)  atorg.keycloak.connections.jpa.JpaExceptionConverter.convert(JpaExceptionConverter.java:31)  atorg.keycloak.transaction.JtaTransactionWrapper.handleException(JtaTransactionWrapper.java:65)  atorg.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:94)  atorg.keycloak.services.DefaultKeycloakTransactionManager.commit(DefaultKeycloakTransactionManager.java:136)  atorg.keycloak.services.filters.KeycloakTransactionCommitter.filter(KeycloakTransactionCommitter.java:43)  atorg.jboss.resteasy.core.interception.ContainerResponseContextImpl.filter(ContainerResponseContextImpl.java:353)  atorg.jboss.resteasy.core.ServerResponseWriter.executeFilters(ServerResponseWriter.java:207)  atorg.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:85)  atorg.jboss.resteasy.core.ServerResponseWriter.writeNomapResponse(ServerResponseWriter.java:59)  atorg.jboss.resteasy.core.SynchronousDispatcher.writeResponse(SynchronousDispatcher.java:530)  atorg.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:461)  atorg.jboss.resteasy.core.SynchronousDispatcher.lambda$invoke$4(SynchronousDispatcher.java:231)  atorg.jboss.resteasy.core.SynchronousDispatcher.lambda$preprocess$0(SynchronousDispatcher.java:137)  atorg.jboss.resteasy.core.interception.PreMatchContainerRequestContext.filter(PreMatchContainerRequestContext.java:361)  atorg.jboss.resteasy.core.SynchronousDispatcher.preprocess(SynchronousDispatcher.java:140)  atorg.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:217)  atorg.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:227)  atorg.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)  atorg.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51)  atjavax.servlet.http.HttpServlet.service(HttpServlet.java:790)  atio.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)  atio.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)  atorg.keycloak.services.filters.KeycloakSessionServletFilter.doFilter(KeycloakSessionServletFilter.java:90)  atio.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)  atio.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)  atio.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)  atio.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)  atio.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)  atio.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)  atorg.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atio.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)  atio.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atio.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)  atio.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)  atio.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)  atio.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)  atio.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)  atio.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atorg.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atorg.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68)  atio.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)  atio.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292)  atio.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81)  atio.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138)  atio.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135)  atio.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)  atio.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)  atorg.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)  atorg.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)  atorg.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)  atorg.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)  atorg.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)  atio.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272)  atio.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81)  atio.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104)  atio.undertow.server.Connectors.executeRootHandler(Connectors.java:360)  atio.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)  atorg.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)  atorg.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)  atorg.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)  atorg.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)  atjava.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement  atorg.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:511)  atorg.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)  atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)  atorg.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)  atorg.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:207)  atorg.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:45)  atorg.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3013)  atorg.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3513)  atorg.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:89)  atorg.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:589)  atorg.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:463)  atorg.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:337)  atorg.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)  atorg.hibernate.internal.SessionImpl.flush(SessionImpl.java:1295)  atorg.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:468)  atorg.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3159)  atorg.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2352)  atorg.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:491)  atorg.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorImpl.beforeCompletion(JtaTransactionCoordinatorImpl.java:316)  atorg.hibernate.resource.transaction.backend.jta.internal.synchronization.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:47)  atorg.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:37)  atorg.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:236)  atorg.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:247)  atorg.wildfly.transaction.client.AbstractTransaction$AssociatingSynchronization.beforeCompletion(AbstractTransaction.java:292)  atcom.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)  atcom.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:368)  atcom.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:91)  atcom.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)  atcom.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1289)  atcom.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)  atcom.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:89)  atorg.wildfly.transaction.client.LocalTransaction.commitAndDissociate(LocalTransaction.java:77)  atorg.wildfly.transaction.client.ContextTransactionManager.commit(ContextTransactionManager.java:71)  atorg.keycloak.transaction.JtaTransactionWrapper.commit(JtaTransactionWrapper.java:92)  ... 63 more Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Lock wait timeout exceeded; try restarting transaction  atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)  atcom.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95)  atcom.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1116)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1066)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1396)  atcom.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1051)  atorg.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)  atorg.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:204)  ... 92 more 