Why does latency deteriorate rapidly as the number of concurrent connections increases? #15727

matyuda · 2022-11-28T14:18:47Z

matyuda
Nov 28, 2022

Hi all, I'm running Keycloak 19.0.2 with AWS Fargate(4 nodes) + RDS (MySQL).
When I performed a load test using the load test tool, the following log was output. Are there any possible causes?

Any sort of guidance around configuration or advice would be appreciated!

{
    "timestamp": "2022-11-28T09:40:40.106Z",
    "sequence": 31766,
    "loggerClassName": "org.jboss.logging.DelegatingBasicLogger",
    "loggerName": "org.hibernate.engine.jdbc.spi.SqlExceptionHelper",
    "level": "ERROR",
    "message": "Sorry, acquisition timeout!",
    "threadName": "executor-thread-563",
    "threadId": 923,
    "mdc": {},
    "ndc": "",
    "hostName": "ip-xxx-xxx-xxx-xxx.ap-northeast-1.compute.internal",
    "processName": "QuarkusEntryPoint",
    "processId": 1
}
{
    "timestamp": "2022-11-28T09:40:40.119Z",
    "sequence": 31771,
    "loggerClassName": "org.jboss.logging.Logger",
    "loggerName": "org.keycloak.services.error.KeycloakErrorHandler",
    "level": "ERROR",
    "message": "Uncaught server error",
    "threadName": "executor-thread-536",
    "threadId": 896,
    "mdc": {},
    "ndc": "",
    "hostName": "ip-xxx-xxx-xxx-xxx.ap-northeast-1.compute.internal",
    "processName": "QuarkusEntryPoint",
    "processId": 1,
    "exception": {
        "refId": 1,
        "exceptionType": "org.keycloak.models.ModelException",
        "message": "javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection",
        "frames": [
            {
                "class": "org.keycloak.connections.jpa.PersistenceExceptionConverter",
                "method": "convert",
                "line": 84
            },
            {
                "class": "org.keycloak.connections.jpa.PersistenceExceptionConverter",
                "method": "invoke",
                "line": 62
            },
            {
                "class": "com.sun.proxy.$Proxy78",
                "method": "find"
            },
            {
                "class": "org.keycloak.models.jpa.JpaUserProvider",
                "method": "getUserById",
                "line": 513
            },
            {
                "class": "org.keycloak.storage.UserStorageManager",
                "method": "getUserById",
                "line": 316
            },
            {
                "class": "org.keycloak.models.cache.infinispan.UserCacheSession",
                "method": "getUserById",
                "line": 216
            },
            {
                "class": "org.keycloak.models.sessions.infinispan.UserSessionAdapter",
                "method": "getUser",
                "line": 178
            },
            {
                "class": "org.keycloak.protocol.oidc.endpoints.TokenEndpoint",
                "method": "codeToToken",
                "line": 346
            },
            {
                "class": "org.keycloak.protocol.oidc.endpoints.TokenEndpoint",
                "method": "processGrantRequest",
                "line": 198
            },
            {
                "class": "jdk.internal.reflect.GeneratedMethodAccessor165",
                "method": "invoke"
            },
            {
                "class": "jdk.internal.reflect.DelegatingMethodAccessorImpl",
                "method": "invoke",
                "line": 43
            },
            {
                "class": "java.lang.reflect.Method",
                "method": "invoke",
                "line": 566
            },
            {
                "class": "org.jboss.resteasy.core.MethodInjectorImpl",
                "method": "invoke",
                "line": 170
            },
            {
                "class": "org.jboss.resteasy.core.MethodInjectorImpl",
                "method": "invoke",
                "line": 130
            },
            {
                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                "method": "internalInvokeOnTarget",
                "line": 660
            },
            {
                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                "method": "invokeOnTargetAfterFilter",
                "line": 524
            },
            {
                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                "method": "lambda$invokeOnTarget$2",
                "line": 474
            },
            {
                "class": "org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext",
                "method": "filter",
                "line": 364
            },
            {
                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                "method": "invokeOnTarget",
                "line": 476
            },
            {
                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                "method": "invoke",
                "line": 434
            },
            {
                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                "method": "invokeOnTargetObject",
                "line": 192
            },
            {
                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                "method": "invoke",
                "line": 152
            },
            {
                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                "method": "invokeOnTargetObject",
                "line": 183
            },
            {
                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                "method": "invoke",
                "line": 141
            },
            {
                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                "method": "invoke",
                "line": 32
            },
            {
                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                "method": "invoke",
                "line": 492
            },
            {
                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                "method": "lambda$invoke$4",
                "line": 261
            },
            {
                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                "method": "lambda$preprocess$0",
                "line": 161
            },
            {
                "class": "org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext",
                "method": "filter",
                "line": 364
            },
            {
                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                "method": "preprocess",
                "line": 164
            },
            {
                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                "method": "invoke",
                "line": 247
            },
            {
                "class": "io.quarkus.resteasy.runtime.standalone.RequestDispatcher",
                "method": "service",
                "line": 73
            },
            {
                "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                "method": "dispatch",
                "line": 151
            },
            {
                "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                "method": "handle",
                "line": 82
            },
            {
                "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                "method": "handle",
                "line": 42
            },
            {
                "class": "io.vertx.ext.web.impl.RouteState",
                "method": "handleContext",
                "line": 1212
            },
            {
                "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                "method": "iterateNext",
                "line": 163
            },
            {
                "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                "method": "next",
                "line": 201
            },
            {
                "class": "io.quarkus.vertx.http.runtime.StaticResourcesRecorder$2",
                "method": "handle",
                "line": 67
            },
            {
                "class": "io.quarkus.vertx.http.runtime.StaticResourcesRecorder$2",
                "method": "handle",
                "line": 55
            },
            {
                "class": "io.vertx.ext.web.impl.RouteState",
                "method": "handleContext",
                "line": 1212
            },
            {
                "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                "method": "iterateNext",
                "line": 163
            },
            {
                "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                "method": "next",
                "line": 201
            },
            {
                "class": "io.quarkus.vertx.http.runtime.VertxHttpRecorder$5",
                "method": "handle",
                "line": 380
            },
            {
                "class": "io.quarkus.vertx.http.runtime.VertxHttpRecorder$5",
                "method": "handle",
                "line": 358
            },
            {
                "class": "io.vertx.ext.web.impl.RouteState",
                "method": "handleContext",
                "line": 1212
            },
            {
                "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                "method": "iterateNext",
                "line": 163
            },
            {
                "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                "method": "next",
                "line": 201
            },
            {
                "class": "org.keycloak.quarkus.runtime.integration.web.QuarkusRequestFilter",
                "method": "lambda$createBlockingHandler$1",
                "line": 90
            },
            {
                "class": "io.vertx.core.impl.ContextImpl",
                "method": "lambda$null$0",
                "line": 159
            },
            {
                "class": "io.vertx.core.impl.AbstractContext",
                "method": "dispatch",
                "line": 100
            },
            {
                "class": "io.vertx.core.impl.ContextImpl",
                "method": "lambda$executeBlocking$1",
                "line": 157
            },
            {
                "class": "io.quarkus.vertx.core.runtime.VertxCoreRecorder$13",
                "method": "runWith",
                "line": 545
            },
            {
                "class": "org.jboss.threads.EnhancedQueueExecutor$Task",
                "method": "run",
                "line": 2449
            },
            {
                "class": "org.jboss.threads.EnhancedQueueExecutor$ThreadBody",
                "method": "run",
                "line": 1478
            },
            {
                "class": "org.jboss.threads.DelegatingRunnable",
                "method": "run",
                "line": 29
            },
            {
                "class": "org.jboss.threads.ThreadLocalResettingRunnable",
                "method": "run",
                "line": 29
            },
            {
                "class": "io.netty.util.concurrent.FastThreadLocalRunnable",
                "method": "run",
                "line": 30
            },
            {
                "class": "java.lang.Thread",
                "method": "run",
                "line": 829
            }
        ],
        "causedBy": {
            "exception": {
                "refId": 2,
                "exceptionType": "javax.persistence.PersistenceException",
                "message": "org.hibernate.exception.GenericJDBCException: Unable to acquire JDBC Connection",
                "frames": [
                    {
                        "class": "org.hibernate.internal.ExceptionConverterImpl",
                        "method": "convert",
                        "line": 154
                    },
                    {
                        "class": "org.hibernate.internal.SessionImpl",
                        "method": "find",
                        "line": 3430
                    },
                    {
                        "class": "org.hibernate.internal.SessionImpl",
                        "method": "find",
                        "line": 3357
                    },
                    {
                        "class": "jdk.internal.reflect.GeneratedMethodAccessor14",
                        "method": "invoke"
                    },
                    {
                        "class": "jdk.internal.reflect.DelegatingMethodAccessorImpl",
                        "method": "invoke",
                        "line": 43
                    },
                    {
                        "class": "java.lang.reflect.Method",
                        "method": "invoke",
                        "line": 566
                    },
                    {
                        "class": "org.keycloak.connections.jpa.PersistenceExceptionConverter",
                        "method": "invoke",
                        "line": 60
                    },
                    {
                        "class": "com.sun.proxy.$Proxy78",
                        "method": "find"
                    },
                    {
                        "class": "org.keycloak.models.jpa.JpaUserProvider",
                        "method": "getUserById",
                        "line": 513
                    },
                    {
                        "class": "org.keycloak.storage.UserStorageManager",
                        "method": "getUserById",
                        "line": 316
                    },
                    {
                        "class": "org.keycloak.models.cache.infinispan.UserCacheSession",
                        "method": "getUserById",
                        "line": 216
                    },
                    {
                        "class": "org.keycloak.models.sessions.infinispan.UserSessionAdapter",
                        "method": "getUser",
                        "line": 178
                    },
                    {
                        "class": "org.keycloak.protocol.oidc.endpoints.TokenEndpoint",
                        "method": "codeToToken",
                        "line": 346
                    },
                    {
                        "class": "org.keycloak.protocol.oidc.endpoints.TokenEndpoint",
                        "method": "processGrantRequest",
                        "line": 198
                    },
                    {
                        "class": "jdk.internal.reflect.GeneratedMethodAccessor165",
                        "method": "invoke"
                    },
                    {
                        "class": "jdk.internal.reflect.DelegatingMethodAccessorImpl",
                        "method": "invoke",
                        "line": 43
                    },
                    {
                        "class": "java.lang.reflect.Method",
                        "method": "invoke",
                        "line": 566
                    },
                    {
                        "class": "org.jboss.resteasy.core.MethodInjectorImpl",
                        "method": "invoke",
                        "line": 170
                    },
                    {
                        "class": "org.jboss.resteasy.core.MethodInjectorImpl",
                        "method": "invoke",
                        "line": 130
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                        "method": "internalInvokeOnTarget",
                        "line": 660
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                        "method": "invokeOnTargetAfterFilter",
                        "line": 524
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                        "method": "lambda$invokeOnTarget$2",
                        "line": 474
                    },
                    {
                        "class": "org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext",
                        "method": "filter",
                        "line": 364
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                        "method": "invokeOnTarget",
                        "line": 476
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                        "method": "invoke",
                        "line": 434
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                        "method": "invokeOnTargetObject",
                        "line": 192
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                        "method": "invoke",
                        "line": 152
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                        "method": "invokeOnTargetObject",
                        "line": 183
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                        "method": "invoke",
                        "line": 141
                    },
                    {
                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                        "method": "invoke",
                        "line": 32
                    },
                    {
                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                        "method": "invoke",
                        "line": 492
                    },
                    {
                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                        "method": "lambda$invoke$4",
                        "line": 261
                    },
                    {
                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                        "method": "lambda$preprocess$0",
                        "line": 161
                    },
                    {
                        "class": "org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext",
                        "method": "filter",
                        "line": 364
                    },
                    {
                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                        "method": "preprocess",
                        "line": 164
                    },
                    {
                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                        "method": "invoke",
                        "line": 247
                    },
                    {
                        "class": "io.quarkus.resteasy.runtime.standalone.RequestDispatcher",
                        "method": "service",
                        "line": 73
                    },
                    {
                        "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                        "method": "dispatch",
                        "line": 151
                    },
                    {
                        "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                        "method": "handle",
                        "line": 82
                    },
                    {
                        "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                        "method": "handle",
                        "line": 42
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RouteState",
                        "method": "handleContext",
                        "line": 1212
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                        "method": "iterateNext",
                        "line": 163
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                        "method": "next",
                        "line": 201
                    },
                    {
                        "class": "io.quarkus.vertx.http.runtime.StaticResourcesRecorder$2",
                        "method": "handle",
                        "line": 67
                    },
                    {
                        "class": "io.quarkus.vertx.http.runtime.StaticResourcesRecorder$2",
                        "method": "handle",
                        "line": 55
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RouteState",
                        "method": "handleContext",
                        "line": 1212
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                        "method": "iterateNext",
                        "line": 163
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                        "method": "next",
                        "line": 201
                    },
                    {
                        "class": "io.quarkus.vertx.http.runtime.VertxHttpRecorder$5",
                        "method": "handle",
                        "line": 380
                    },
                    {
                        "class": "io.quarkus.vertx.http.runtime.VertxHttpRecorder$5",
                        "method": "handle",
                        "line": 358
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RouteState",
                        "method": "handleContext",
                        "line": 1212
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                        "method": "iterateNext",
                        "line": 163
                    },
                    {
                        "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                        "method": "next",
                        "line": 201
                    },
                    {
                        "class": "org.keycloak.quarkus.runtime.integration.web.QuarkusRequestFilter",
                        "method": "lambda$createBlockingHandler$1",
                        "line": 90
                    },
                    {
                        "class": "io.vertx.core.impl.ContextImpl",
                        "method": "lambda$null$0",
                        "line": 159
                    },
                    {
                        "class": "io.vertx.core.impl.AbstractContext",
                        "method": "dispatch",
                        "line": 100
                    },
                    {
                        "class": "io.vertx.core.impl.ContextImpl",
                        "method": "lambda$executeBlocking$1",
                        "line": 157
                    },
                    {
                        "class": "io.quarkus.vertx.core.runtime.VertxCoreRecorder$13",
                        "method": "runWith",
                        "line": 545
                    },
                    {
                        "class": "org.jboss.threads.EnhancedQueueExecutor$Task",
                        "method": "run",
                        "line": 2449
                    },
                    {
                        "class": "org.jboss.threads.EnhancedQueueExecutor$ThreadBody",
                        "method": "run",
                        "line": 1478
                    },
                    {
                        "class": "org.jboss.threads.DelegatingRunnable",
                        "method": "run",
                        "line": 29
                    },
                    {
                        "class": "org.jboss.threads.ThreadLocalResettingRunnable",
                        "method": "run",
                        "line": 29
                    },
                    {
                        "class": "io.netty.util.concurrent.FastThreadLocalRunnable",
                        "method": "run",
                        "line": 30
           
10BC8
         },
                    {
                        "class": "java.lang.Thread",
                        "method": "run",
                        "line": 829
                    }
                ],
                "causedBy": {
                    "exception": {
                        "refId": 3,
                        "exceptionType": "org.hibernate.exception.GenericJDBCException",
                        "message": "Unable to acquire JDBC Connection",
                        "frames": [
                            {
                                "class": "org.hibernate.exception.internal.StandardSQLExceptionConverter",
                                "method": "convert",
                                "line": 42
                            },
                            {
                                "class": "org.hibernate.engine.jdbc.spi.SqlExceptionHelper",
                                "method": "convert",
                                "line": 113
                            },
                            {
                                "class": "org.hibernate.engine.jdbc.spi.SqlExceptionHelper",
                                "method": "convert",
                                "line": 99
                            },
                            {
                                "class": "org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl",
                                "method": "acquireConnectionIfNeeded",
                                "line": 111
                            },
                            {
                                "class": "org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl",
                                "method": "getPhysicalConnection",
                                "line": 138
                            },
                            {
                                "class": "org.hibernate.engine.jdbc.internal.StatementPreparerImpl",
                                "method": "connection",
                                "line": 50
                            },
                            {
                                "class": "org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5",
                                "method": "doPrepare",
                                "line": 149
                            },
                            {
                                "class": "org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate",
                                "method": "prepareStatement",
                                "line": 176
                            },
                            {
                                "class": "org.hibernate.engine.jdbc.internal.StatementPreparerImpl",
                                "method": "prepareQueryStatement",
                                "line": 151
                            },
                            {
                                "class": "org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader",
                                "method": "prepareQueryStatement",
                                "line": 198
                            },
                            {
                                "class": "org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader",
                                "method": "executeQueryStatement",
                                "line": 162
                            },
                            {
                                "class": "org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader",
                                "method": "executeLoad",
                                "line": 104
                            },
                            {
                                "class": "org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader",
                                "method": "load",
                                "line": 285
                            },
                            {
                                "class": "org.hibernate.persister.entity.AbstractEntityPersister",
                                "method": "doLoad",
                                "line": 4521
                            },
                            {
                                "class": "org.hibernate.persister.entity.AbstractEntityPersister",
                                "method": "load",
                                "line": 4511
                            },
                            {
                                "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                "method": "loadFromDatasource",
                                "line": 571
                            },
                            {
                                "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                "method": "doLoad",
                                "line": 539
                            },
                            {
                                "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                "method": "load",
                                "line": 208
                            },
                            {
                                "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                "method": "proxyOrLoad",
                                "line": 327
                            },
                            {
                                "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                "method": "doOnLoad",
                                "line": 108
                            },
                            {
                                "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                "method": "onLoad",
                                "line": 74
                            },
                            {
                                "class": "org.hibernate.event.service.internal.EventListenerGroupImpl",
                                "method": "fireEventOnEachListener",
                                "line": 118
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl",
                                "method": "fireLoadNoChecks",
                                "line": 1226
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl",
                                "method": "fireLoad",
                                "line": 1215
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl",
                                "method": "access$2100",
                                "line": 201
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl",
                                "method": "doLoad",
                                "line": 2830
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl",
                                "method": "lambda$load$1",
                                "line": 2807
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl",
                                "method": "perform",
                                "line": 2763
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl",
                                "method": "load",
                                "line": 2807
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl",
                                "method": "find",
                                "line": 3395
                            },
                            {
                                "class": "org.hibernate.internal.SessionImpl",
                                "method": "find",
                                "line": 3357
                            },
                            {
                                "class": "jdk.internal.reflect.GeneratedMethodAccessor14",
                                "method": "invoke"
                            },
                            {
                                "class": "jdk.internal.reflect.DelegatingMethodAccessorImpl",
                                "method": "invoke",
                                "line": 43
                            },
                            {
                                "class": "java.lang.reflect.Method",
                                "method": "invoke",
                                "line": 566
                            },
                            {
                                "class": "org.keycloak.connections.jpa.PersistenceExceptionConverter",
                                "method": "invoke",
                                "line": 60
                            },
                            {
                                "class": "com.sun.proxy.$Proxy78",
                                "method": "find"
                            },
                            {
                                "class": "org.keycloak.models.jpa.JpaUserProvider",
                                "method": "getUserById",
                                "line": 513
                            },
                            {
                                "class": "org.keycloak.storage.UserStorageManager",
                                "method": "getUserById",
                                "line": 316
                            },
                            {
                                "class": "org.keycloak.models.cache.infinispan.UserCacheSession",
                                "method": "getUserById",
                                "line": 216
                            },
                            {
                                "class": "org.keycloak.models.sessions.infinispan.UserSessionAdapter",
                                "method": "getUser",
                                "line": 178
                            },
                            {
                                "class": "org.keycloak.protocol.oidc.endpoints.TokenEndpoint",
                                "method": "codeToToken",
                                "line": 346
                            },
                            {
                                "class": "org.keycloak.protocol.oidc.endpoints.TokenEndpoint",
                                "method": "processGrantRequest",
                                "line": 198
                            },
                            {
                                "class": "jdk.internal.reflect.GeneratedMethodAccessor165",
                                "method": "invoke"
                            },
                            {
                                "class": "jdk.internal.reflect.DelegatingMethodAccessorImpl",
                                "method": "invoke",
                                "line": 43
                            },
                            {
                                "class": "java.lang.reflect.Method",
                                "method": "invoke",
                                "line": 566
                            },
                            {
                                "class": "org.jboss.resteasy.core.MethodInjectorImpl",
                                "method": "invoke",
                                "line": 170
                            },
                            {
                                "class": "org.jboss.resteasy.core.MethodInjectorImpl",
                                "method": "invoke",
                                "line": 130
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                "method": "internalInvokeOnTarget",
                                "line": 660
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                "method": "invokeOnTargetAfterFilter",
                                "line": 524
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                "method": "lambda$invokeOnTarget$2",
                                "line": 474
                            },
                            {
                                "class": "org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext",
                                "method": "filter",
                                "line": 364
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                "method": "invokeOnTarget",
                                "line": 476
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                "method": "invoke",
                                "line": 434
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                "method": "invokeOnTargetObject",
                                "line": 192
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                "method": "invoke",
                                "line": 152
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                "method": "invokeOnTargetObject",
                                "line": 183
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                "method": "invoke",
                                "line": 141
                            },
                            {
                                "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                "method": "invoke",
                                "line": 32
                            },
                            {
                                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                "method": "invoke",
                                "line": 492
                            },
                            {
                                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                "method": "lambda$invoke$4",
                                "line": 261
                            },
                            {
                                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                "method": "lambda$preprocess$0",
                                "line": 161
                            },
                            {
                                "class": "org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext",
                                "method": "filter",
                                "line": 364
                            },
                            {
                                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                "method": "preprocess",
                                "line": 164
                            },
                            {
                                "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                "method": "invoke",
                                "line": 247
                            },
                            {
                                "class": "io.quarkus.resteasy.runtime.standalone.RequestDispatcher",
                                "method": "service",
                                "line": 73
                            },
                            {
                                "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                                "method": "dispatch",
                                "line": 151
                            },
                            {
                                "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                                "method": "handle",
                                "line": 82
                            },
                            {
                                "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                                "method": "handle",
                                "line": 42
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RouteState",
                                "method": "handleContext",
                                "line": 1212
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                                "method": "iterateNext",
                                "line": 163
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                                "method": "next",
                                "line": 201
                            },
                            {
                                "class": "io.quarkus.vertx.http.runtime.StaticResourcesRecorder$2",
                                "method": "handle",
                                "line": 67
                            },
                            {
                                "class": "io.quarkus.vertx.http.runtime.StaticResourcesRecorder$2",
                                "method": "handle",
                                "line": 55
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RouteState",
                                "method": "handleContext",
                                "line": 1212
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                                "method": "iterateNext",
                                "line": 163
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                                "method": "next",
                                "line": 201
                            },
                            {
                                "class": "io.quarkus.vertx.http.runtime.VertxHttpRecorder$5",
                                "method": "handle",
                                "line": 380
                            },
                            {
                                "class": "io.quarkus.vertx.http.runtime.VertxHttpRecorder$5",
                                "method": "handle",
                                "line": 358
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RouteState",
                                "method": "handleContext",
                                "line": 1212
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                                "method": "iterateNext",
                                "line": 163
                            },
                            {
                                "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                                "method": "next",
                                "line": 201
                            },
                            {
                                "class": "org.keycloak.quarkus.runtime.integration.web.QuarkusRequestFilter",
                                "method": "lambda$createBlockingHandler$1",
                                "line": 90
                            },
                            {
                                "class": "io.vertx.core.impl.ContextImpl",
                                "method": "lambda$null$0",
                                "line": 159
                            },
                            {
                                "class": "io.vertx.core.impl.AbstractContext",
                                "method": "dispatch",
                                "line": 100
                            },
                            {
                                "class": "io.vertx.core.impl.ContextImpl",
                                "method": "lambda$executeBlocking$1",
                                "line": 157
                            },
                            {
                                "class": "io.quarkus.vertx.core.runtime.VertxCoreRecorder$13",
                                "method": "runWith",
                                "line": 545
                            },
                            {
                                "class": "org.jboss.threads.EnhancedQueueExecutor$Task",
                                "method": "run",
                                "line": 2449
                            },
                            {
                                "class": "org.jboss.threads.EnhancedQueueExecutor$ThreadBody",
                                "method": "run",
                                "line": 1478
                            },
                            {
                                "class": "org.jboss.threads.DelegatingRunnable",
                                "method": "run",
                                "line": 29
                            },
                            {
                                "class": "org.jboss.threads.ThreadLocalResettingRunnable",
                                "method": "run",
                                "line": 29
                            },
                            {
                                "class": "io.netty.util.concurrent.FastThreadLocalRunnable",
                                "method": "run",
                                "line": 30
                            },
                            {
                                "class": "java.lang.Thread",
                                "method": "run",
                                "line": 829
                            }
                        ],
                        "causedBy": {
                            "exception": {
                                "refId": 4,
                                "exceptionType": "java.sql.SQLException",
                                "message": "Sorry, acquisition timeout!",
                                "frames": [
                                    {
                                        "class": "io.agroal.pool.ConnectionPool",
                                        "method": "handlerFromSharedCache",
                                        "line": 294
                                    },
                                    {
                                        "class": "io.agroal.pool.ConnectionPool",
                                        "method": "getConnection",
                                        "line": 242
                                    },
                                    {
                                        "class": "io.agroal.pool.DataSource",
                                        "method": "getConnection",
                                        "line": 86
                                    },
                                    {
                                        "class": "io.quarkus.hibernate.orm.runtime.customized.QuarkusConnectionProvider",
                                        "method": "getConnection",
                                        "line": 23
                                    },
                                    {
                                        "class": "org.hibernate.internal.NonContextualJdbcConnectionAccess",
                                        "method": "obtainConnection",
                                        "line": 38
                                    },
                                    {
                                        "class": "org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl",
                                        "method": "acquireConnectionIfNeeded",
                                        "line": 108
                                    },
                                    {
                                        "class": "org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl",
                                        "method": "getPhysicalConnection",
                                        "line": 138
                                    },
                                    {
                                        "class": "org.hibernate.engine.jdbc.internal.StatementPreparerImpl",
                                        "method": "connection",
                                        "line": 50
                                    },
                                    {
                                        "class": "org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5",
                                        "method": "doPrepare",
                                        "line": 149
                                    },
                                    {
                                        "class": "org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate",
                                        "method": "prepareStatement",
                                        "line": 176
                                    },
                                    {
                                        "class": "org.hibernate.engine.jdbc.internal.StatementPreparerImpl",
                                        "method": "prepareQueryStatement",
                                        "line": 151
                                    },
                                    {
                                        "class": "org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader",
                                        "method": "prepareQueryStatement",
                                        "line": 198
                                    },
                                    {
                                        "class": "org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader",
                                        "method": "executeQueryStatement",
                                        "line": 162
                                    },
                                    {
                                        "class": "org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader",
                                        "method": "executeLoad",
                                        "line": 104
                                    },
                                    {
                                        "class": "org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader",
                                        "method": "load",
                                        "line": 285
                                    },
                                    {
                                        "class": "org.hibernate.persister.entity.AbstractEntityPersister",
                                        "method": "doLoad",
                                        "line": 4521
                                    },
                                    {
                                        "class": "org.hibernate.persister.entity.AbstractEntityPersister",
                                        "method": "load",
                                        "line": 4511
                                    },
                                    {
                                        "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                        "method": "loadFromDatasource",
                                        "line": 571
                                    },
                                    {
                                        "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                        "method": "doLoad",
                                        "line": 539
                                    },
                                    {
                                        "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                        "method": "load",
                                        "line": 208
                                    },
                                    {
                                        "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                        "method": "proxyOrLoad",
                                        "line": 327
                                    },
                                    {
                                        "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                        "method": "doOnLoad",
                                        "line": 108
                                    },
                                    {
                                        "class": "org.hibernate.event.internal.DefaultLoadEventListener",
                                        "method": "onLoad",
                                        "line": 74
                                    },
                                    {
                                        "class": "org.hibernate.event.service.internal.EventListenerGroupImpl",
                                        "method": "fireEventOnEachListener",
                                        "line": 118
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl",
                                        "method": "fireLoadNoChecks",
                                        "line": 1226
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl",
                                        "method": "fireLoad",
                                        "line": 1215
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl",
                                        "method": "access$2100",
                                        "line": 201
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl",
                                        "method": "doLoad",
                                        "line": 2830
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl",
                                        "method": "lambda$load$1",
                                        "line": 2807
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl",
                                        "method": "perform",
                                        "line": 2763
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl",
                                        "method": "load",
                                        "line": 2807
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl",
                                        "method": "find",
                                        "line": 3395
                                    },
                                    {
                                        "class": "org.hibernate.internal.SessionImpl",
                                        "method": "find",
                                        "line": 3357
                                    },
                                    {
                                        "class": "jdk.internal.reflect.GeneratedMethodAccessor14",
                                        "method": "invoke"
                                    },
                                    {
                                        "class": "jdk.internal.reflect.DelegatingMethodAccessorImpl",
                                        "method": "invoke",
                                        "line": 43
                                    },
                                    {
                                        "class": "java.lang.reflect.Method",
                                        "method": "invoke",
                                        "line": 566
                                    },
                                    {
                                        "class": "org.keycloak.connections.jpa.PersistenceExceptionConverter",
                                        "method": "invoke",
                                        "line": 60
                                    },
                                    {
                                        "class": "com.sun.proxy.$Proxy78",
                                        "method": "find"
                                    },
                                    {
                                        "class": "org.keycloak.models.jpa.JpaUserProvider",
                                        "method": "getUserById",
                                        "line": 513
                                    },
                                    {
                                        "class": "org.keycloak.storage.UserStorageManager",
                                        "method": "getUserById",
                                        "line": 316
                                    },
                                    {
                                        "class": "org.keycloak.models.cache.infinispan.UserCacheSession",
                                        "method": "getUserById",
                                        "line": 216
                                    },
                                    {
                                        "class": "org.keycloak.models.sessions.infinispan.UserSessionAdapter",
                                        "method": "getUser",
                                        "line": 178
                                    },
                                    {
                                        "class": "org.keycloak.protocol.oidc.endpoints.TokenEndpoint",
                                        "method": "codeToToken",
                                        "line": 346
                                    },
                                    {
                                        "class": "org.keycloak.protocol.oidc.endpoints.TokenEndpoint",
                                        "method": "processGrantRequest",
                                        "line": 198
                                    },
                                    {
                                        "class": "jdk.internal.reflect.GeneratedMethodAccessor165",
                                        "method": "invoke"
                                    },
                                    {
                                        "class": "jdk.internal.reflect.DelegatingMethodAccessorImpl",
                                        "method": "invoke",
                                        "line": 43
                                    },
                                    {
                                        "class": "java.lang.reflect.Method",
                                        "method": "invoke",
                                        "line": 566
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.MethodInjectorImpl",
                                        "method": "invoke",
                                        "line": 170
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.MethodInjectorImpl",
                                        "method": "invoke",
                                        "line": 130
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                        "method": "internalInvokeOnTarget",
                                        "line": 660
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                        "method": "invokeOnTargetAfterFilter",
                                        "line": 524
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                        "method": "lambda$invokeOnTarget$2",
                                        "line": 474
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext",
                                        "method": "filter",
                                        "line": 364
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                        "method": "invokeOnTarget",
                                        "line": 476
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceMethodInvoker",
                                        "method": "invoke",
                                        "line": 434
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                        "method": "invokeOnTargetObject",
                                        "line": 192
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                        "method": "invoke",
                                        "line": 152
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                        "method": "invokeOnTargetObject",
                                        "line": 183
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                        "method": "invoke",
                                        "line": 141
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.ResourceLocatorInvoker",
                                        "method": "invoke",
                                        "line": 32
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                        "method": "invoke",
                                        "line": 492
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                        "method": "lambda$invoke$4",
                                        "line": 261
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                        "method": "lambda$preprocess$0",
                                        "line": 161
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.interception.jaxrs.PreMatchContainerRequestContext",
                                        "method": "filter",
                                        "line": 364
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                        "method": "preprocess",
                                        "line": 164
                                    },
                                    {
                                        "class": "org.jboss.resteasy.core.SynchronousDispatcher",
                                        "method": "invoke",
                                        "line": 247
                                    },
                                    {
                                        "class": "io.quarkus.resteasy.runtime.standalone.RequestDispatcher",
                                        "method": "service",
                                        "line": 73
                                    },
                                    {
                                        "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                                        "method": "dispatch",
                                        "line": 151
                                    },
                                    {
                                        "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                                        "method": "handle",
                                        "line": 82
                                    },
                                    {
                                        "class": "io.quarkus.resteasy.runtime.standalone.VertxRequestHandler",
                                        "method": "handle",
                                        "line": 42
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RouteState",
                                        "method": "handleContext",
                                        "line": 1212
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                                        "method": "iterateNext",
                                        "line": 163
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                                        "method": "next",
                                        "line": 201
                                    },
                                    {
                                        "class": "io.quarkus.vertx.http.runtime.StaticResourcesRecorder$2",
                                        "method": "handle",
                                        "line": 67
                                    },
                                    {
                                        "class": "io.quarkus.vertx.http.runtime.StaticResourcesRecorder$2",
                                        "method": "handle",
                                        "line": 55
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RouteState",
                                        "method": "handleContext",
                                        "line": 1212
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                                        "method": "iterateNext",
                                        "line": 163
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                                        "method": "next",
                                        "line": 201
                                    },
                                    {
                                        "class": "io.quarkus.vertx.http.runtime.VertxHttpRecorder$5",
                                        "method": "handle",
                                        "line": 380
                                    },
                                    {
                                        "class": "io.quarkus.vertx.http.runtime.VertxHttpRecorder$5",
                                        "method": "handle",
                                        "line": 358
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RouteState",
                                        "method": "handleContext",
                                        "line": 1212
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RoutingContextImplBase",
                                        "method": "iterateNext",
                                        "line": 163
                                    },
                                    {
                                        "class": "io.vertx.ext.web.impl.RoutingContextWrapper",
                                        "method": "next",
                                        "line": 201
                                    },
                                    {
                                        "class": "org.keycloak.quarkus.runtime.integration.web.QuarkusRequestFilter",
                                        "method": "lambda$createBlockingHandler$1",
                                        "line": 90
                                    },
                                    {
                                        "class": "io.vertx.core.impl.ContextImpl",
                                        "method": "lambda$null$0",
                                        "line": 159
                                    },
                                    {
                                        "class": "io.vertx.core.impl.AbstractContext",
                                        "method": "dispatch",
                                        "line": 100
                                    },
                                    {
                                        "class": "io.vertx.core.impl.ContextImpl",
                                        "method": "lambda$executeBlocking$1",
                                        "line": 157
                                    },
                                    {
                                        "class": "io.quarkus.vertx.core.runtime.VertxCoreRecorder$13",
                                        "method": "runWith",
                                        "line": 545
                                    },
                                    {
                                        "class": "org.jboss.threads.EnhancedQueueExecutor$Task",
                                        "method": "run",
                                        "line": 2449
                                    },
                                    {
                                        "class": "org.jboss.threads.EnhancedQueueExecutor$ThreadBody",
                                        "method": "run",
                                        "line": 1478
                                    },
                                    {
                                        "class": "org.jboss.threads.DelegatingRunnable",
                                        "method": "run",
                                        "line": 29
                                    },
                                    {
                                        "class": "org.jboss.threads.ThreadLocalResettingRunnable",
                                        "method": "run",
                                        "line": 29
                                    },
                                    {
                                        "class": "io.netty.util.concurrent.FastThreadLocalRunnable",
                                        "method": "run",
                                        "line": 30
                                    },
                                    {
                                        "class": "java.lang.Thread",
                                        "method": "run",
                                        "line": 829
                                    }
                                ]
                            }
                        }
                    }
                }
            }
        }
    }
}

Settings is below

1)Fargate task definition

      "environment": [
        {
          "name": "JAVA_OPTS",
          "value": "-Xms1024m -Xmx7168m -XX:MetaspaceSize=96M -XX:MaxMetaspaceSize=256m -Djava.net.preferIPv4Stack=true -Djboss.modules.system.pkgs=org.jboss.byteman -Djava.awt.headless=true"
        },
        {
          "name": "KC_CACHE",
          "value": "ispn"
        },
        {
          "name": "KC_CACHE_CONFIG_FILE",
          "value": "cache-ispn-jdbc-ping.xml"
        },
        {
          "name": "KC_DB_PASSWORD",
          "value": "password"
        },
        {
          "name": "KC_DB_POOL_INITIAL_SIZE",
          "value": "70"
        },
        {
          "name": "KC_DB_POOL_MAX_SIZE",
          "value": "70"
        },
        {
          "name": "KC_DB_POOL_MIN_SIZE",
          "value": "70"
        },
        {
          "name": "KC_DB_URL",
          "value": "jdbc:mysql://xxxxxx.yyyyyyy.ap-northeast-1.rds.amazonaws.com:3306/zzzzzzz?useSSL=false"
        },
        {
          "name": "KC_DB_URL_DATABASE",
          "value": "zzzzzzz"
        },
        {
          "name": "KC_DB_USERNAME",
          "value": "username"
        },
        {
          "name": "KC_HOSTNAME",
          "value": "xxx.xxx.xxxx"
        },
        {
          "name": "KC_HOSTNAME_STRICT_BACKCHANNEL",
          "value": "true"
        }
      ]

2)keycloak.config

db=mysql
proxy=edge
http-enabled=true
health-enabled=true
http-relative-path=/auth
spi-theme-welcome-theme=master
log-console-output=json

3)cache-ispn-jdbc-ping.xml

<?xml version="1.0" encoding="UTF-8"?>
<infinispan
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="urn:infinispan:config:11.0 http://www.infinispan.org/schemas/infinispan-config-11.0.xsd"
    xmlns="urn:infinispan:config:11.0">

  <!-- custom stack goes into the jgroups element -->
  <jgroups>
    <stack name="jdbc-ping-tcp" extends="tcp">
      <JDBC_PING connection_driver="com.mysql.cj.jdbc.Driver"
                 connection_username="${env.KC_DB_USERNAME}" connection_password="${env.KC_DB_PASSWORD}"
                 connection_url="${env.KC_DB_URL}"
                 initialize_sql="CREATE TABLE IF NOT EXISTS JGROUPSPING (own_addr varchar(200) NOT NULL, cluster_name varchar(200) NOT NULL, ping_data VARBINARY(255), constraint PK_JGROUPSPING PRIMARY KEY (own_addr, cluster_name));"
	         info_writer_sleep_time="500"
                 remove_all_data_on_view_change="true"
                 stack.combine="REPLACE"
                 stack.position="MPING" />
    </stack>
  </jgroups>
  
  <cache-container name="keycloak">
    <!-- custom stack must be referenced by name in the stack attribute of the transport element -->
    <transport lock-timeout="60000" stack="jdbc-ping-tcp"/>
    <local-cache name="realms">
      <encoding>
        <key media-type="application/x-java-object"/>
        <value media-type="application/x-java-object"/>
      </encoding>
      <memory max-count="10000"/>
    </local-cache>
    <local-cache name="users">
      <encoding>
        <key media-type="application/x-java-object"/>
        <value media-type="application/x-java-object"/>
      </encoding>
      <memory max-count="10000"/>
    </local-cache>
    <distributed-cache name="sessions" owners="3">
      <expiration lifespan="-1"/>
    </distributed-cache>
    <distributed-cache name="authenticationSessions" owners="3">
      <expiration lifespan="-1"/>
    </distributed-cache>
    <distributed-cache name="offlineSessions" owners="3">
      <expiration lifespan="-1"/>
    </distributed-cache>
    <distributed-cache name="clientSessions" owners="3">
      <expiration lifespan="-1"/>
    </distributed-cache>
    <distributed-cache name="offlineClientSessions" owners="3">
      <expiration lifespan="-1"/>
    </distributed-cache>
    <distributed-cache name="loginFailures" owners="3">
      <expiration lifespan="-1"/>
    </distributed-cache>
    <local-cache name="authorization">
      <encoding>
        <key media-type="application/x-java-object"/>
        <value media-type="application/x-java-object"/>
      </encoding>
      <memory max-count="10000"/>
    </local-cache>
    <replicated-cache name="work">
      <expiration lifespan="-1"/>
    </replicated-cache>
    <local-cache name="keys">
      <encoding>
        <key media-type="application/x-java-object"/>
        <value media-type="application/x-java-object"/>
      </encoding>
      <expiration max-idle="3600000"/>
      <memory max-count="1000"/>
    </local-cache>
    <distributed-cache name="actionTokens" owners="3">
      <encoding>
        <key media-type="application/x-java-object"/>
        <value media-type="application/x-java-object"/>
      </encoding>
      <expiration max-idle="-1" lifespan="-1" interval="300000"/>
      <memory max-count="-1"/>
    </distributed-cache>
  </cache-container>
</infinispan>