May 29, 2022 @ 12:25:41.254 at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377) May 29, 2022 @ 12:25:41.254 at org.jboss.xnio@3.8.4.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1280) May 29, 2022 @ 12:25:41.254 at java.base/java.lang.Thread.run(Thread.java:829) May 29, 2022 @ 12:25:41.254 Caused by: org.hibernate.exception.LockAcquisitionException: could not execute statement May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.dialect.MySQLDialect$3.convert(MySQLDialect.java:547) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.hql.internal.ast.exec.BasicExecutor.doExecute(BasicExecutor.java:100) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.hql.internal.ast.exec.BasicExecutor.execute(BasicExecutor.java:59) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.hql.internal.ast.QueryTranslatorImpl.executeUpdate(QueryTranslatorImpl.java:453) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.engine.query.spi.HQLQueryPlan.performExecuteUpdate(HQLQueryPlan.java:378) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.internal.SessionImpl.executeUpdate(SessionImpl.java:1550) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.query.internal.AbstractProducedQuery.doExecuteUpdate(AbstractProducedQuery.java:1663) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1645) May 29, 2022 @ 12:25:41.254 ... 88 more May 29, 2022 @ 12:25:41.254 Caused by: com.mysql.cj.jdbc.exceptions.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction May 29, 2022 @ 12:25:41.254 at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:123) May 29, 2022 @ 12:25:41.254 at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) May 29, 2022 @ 12:25:41.254 at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) May 29, 2022 @ 12:25:41.254 at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:953) May 29, 2022 @ 12:25:41.254 at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1092) May 29, 2022 @ 12:25:41.254 at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1040) May 29, 2022 @ 12:25:41.254 at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1347) May 29, 2022 @ 12:25:41.254 at com.mysql.jdbc@8.0.22//com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1025) May 29, 2022 @ 12:25:41.254 at org.jboss.ironjacamar.jdbcadapters@1.5.2.Final//org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537) May 29, 2022 @ 12:25:41.254 at org.hibernate@5.3.23.Final//org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175) May 29, 2022 @ 12:25:41.254 ... 95 more May 29, 2022 @ 12:25:41.254 May 29, 2022 @ 12:25:41.253 09:55:41,252 ERROR [org.keycloak.services.error.KeycloakErrorHandler] (default task-212) Uncaught server error: javax.persistence.OptimisticLockException: org.hibernate.exception.LockAcquisitionException: could not execute statement May 29, 2022 @ 12:25:41.253 at org.hibernate@5.3.23.Final//org.hibernate.internal.ExceptionConverterImpl.wrapLockException(ExceptionConverterImpl.java:277) May 29, 2022 @ 12:25:41.253 at org.hibernate@5.3.23.Final//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:98) May 29, 2022 @ 12:25:41.253 at org.hibernate@5.3.23.Final//org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) May 29, 2022 @ 12:25:41.253 at org.hibernate@5.3.23.Final//org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1654) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-model-jpa@16.0.0//org.keycloak.models.jpa.session.JpaUserSessionPersisterProvider.updateLastSessionRefreshes(JpaUserSessionPersisterProvider.java:222) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-model-infinispan@16.0.0//org.keycloak.models.sessions.infinispan.changes.sessions.PersisterLastSessionRefreshStore.sendMessage(PersisterLastSessionRefreshStore.java:74) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-model-infinispan@16.0.0//org.keycloak.models.sessions.infinispan.changes.sessions.AbstractLastSessionRefreshStore.checkSendingMessage(AbstractLastSessionRefreshStore.java:61) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-model-infinispan@16.0.0//org.keycloak.models.sessions.infinispan.changes.sessions.AbstractLastSessionRefreshStore.putLastSessionRefresh(AbstractLastSessionRefreshStore.java:51) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-model-infinispan@16.0.0//org.keycloak.models.sessions.infinispan.UserSessionAdapter.setLastSessionRefresh(UserSessionAdapter.java:220) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-model-infinispan@16.0.0//org.keycloak.models.sessions.infinispan.InfinispanUserSessionProvider.createOfflineUserSession(InfinispanUserSessionProvider.java:732) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-services@16.0.0//org.keycloak.services.managers.UserSessionManager.createOfflineUserSession(UserSessionManager.java:141) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-services@16.0.0//org.keycloak.services.managers.UserSessionManager.createOrUpdateOfflineSession(UserSessionManager.java:62) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-services@16.0.0//org.keycloak.protocol.oidc.TokenManager$AccessTokenResponseBuilder.generateRefreshToken(TokenManager.java:1006) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-services@16.0.0//org.keycloak.protocol.oidc.endpoints.TokenEndpoint.clientCredentialsGrant(TokenEndpoint.java:784) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-services@16.0.0//org.keycloak.protocol.oidc.endpoints.TokenEndpoint.processGrantRequest(TokenEndpoint.java:205) May 29, 2022 @ 12:25:41.253 at jdk.internal.reflect.GeneratedMethodAccessor368.invoke(Unknown Source) May 29, 2022 @ 12:25:41.253 at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) May 29, 2022 @ 12:25:41.253 at java.base/java.lang.reflect.Method.invoke(Method.java:566) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:170) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:130) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceMethodInvoker.internalInvokeOnTarget(ResourceMethodInvoker.java:660) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTargetAfterFilter(ResourceMethodInvoker.java:524) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceMethodInvoker.lambda$invokeOnTarget$2(ResourceMethodInvoker.java:474) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext.filter(PreMatchContainerRequestContext.java:364) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:476) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:434) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:192) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:152) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.invokeOnTargetObject(ResourceLocatorInvoker.java:183) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:141) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.ResourceLocatorInvoker.invoke(ResourceLocatorInvoker.java:32) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:492) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.SynchronousDispatcher.lambda$invoke$4(SynchronousDispatcher.java:261) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.SynchronousDispatcher.lambda$preprocess$0(SynchronousDispatcher.java:161) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext.filter(PreMatchContainerRequestContext.java:364) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.SynchronousDispatcher.preprocess(SynchronousDispatcher.java:164) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:247) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:249) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:60) May 29, 2022 @ 12:25:41.253 at org.jboss.resteasy.resteasy-core@4.7.2.Final//org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) May 29, 2022 @ 12:25:41.253 at javax.servlet.api@2.0.0.Final//javax.servlet.http.HttpServlet.service(HttpServlet.java:590) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-wildfly-extensions@16.0.0//org.keycloak.provider.wildfly.WildFlyRequestFilter.lambda$doFilter$0(WildFlyRequestFilter.java:41) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-services@16.0.0//org.keycloak.services.filters.AbstractRequestFilter.filter(AbstractRequestFilter.java:43) May 29, 2022 @ 12:25:41.253 at org.keycloak.keycloak-wildfly-extensions@16.0.0//org.keycloak.provider.wildfly.WildFlyRequestFilter.doFilter(WildFlyRequestFilter.java:39) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) May 29, 2022 @ 12:25:41.253 at org.wildfly.security.elytron-web.undertow-server@1.10.0.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.lambda$handleRequest$1(ElytronRunAsHandler.java:68) May 29, 2022 @ 12:25:41.253 at org.wildfly.security.elytron-base@1.17.1.Final//org.wildfly.security.auth.server.FlexibleIdentityAssociation.runAsFunctionEx(FlexibleIdentityAssociation.java:103) May 29, 2022 @ 12:25:41.253 at org.wildfly.security.elytron-base@1.17.1.Final//org.wildfly.security.auth.server.Scoped.runAsFunctionEx(Scoped.java:161) May 29, 2022 @ 12:25:41.253 at org.wildfly.security.elytron-base@1.17.1.Final//org.wildfly.security.auth.server.Scoped.runAs(Scoped.java:73) May 29, 2022 @ 12:25:41.253 at org.wildfly.security.elytron-web.undertow-server@1.10.0.Final//org.wildfly.elytron.web.undertow.server.ElytronRunAsHandler.handleRequest(ElytronRunAsHandler.java:67) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68) May 29, 2022 @ 12:25:41.253 at io.undertow.servlet@2.2.12.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117) May 29, 2022 @ 12:25:41.252 09:55:41,251 WARN [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-212) SQL Error: 1213, SQLState: 40001 May 29, 2022 @ 12:25:41.252 09:55:41,252 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (default task-212) Deadlock found when trying to get lock; try restarting transaction