2019-03-05 11:11:43,802 DEBUG [org.teiid.AUDIT_LOG] (default task-38) [svc.1, null anonymous USERPASSWORD null null null true] 2019-03-05 11:11:43,803 DEBUG [org.teiid.SECURITY] (default task-38) authenticateUser anonymous JDBC 2019-03-05 11:11:43,803 DEBUG [org.teiid.SECURITY] (default task-38) Logon successful, created session: sessionid=vf4TgdWRfGN0; userName=cef9d7d3-af13-4b13-9e93-ef3c5307f0e9; vdbName=svc; vdbVersion=1; createdTime=Tue Mar 05 11:11:43 UTC 2019; applicationName=JDBC; clientHostName=null; clientHardwareAddress=null; IPAddress=null; securityDomain=teiid-security; lastPingTime=Tue Mar 05 11:11:43 UTC 2019 2019-03-05 11:11:43,803 DEBUG [org.teiid.AUDIT_LOG] (default task-38) [cef9d7d3-af13-4b13-9e93-ef3c5307f0e9] 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) Successfully obtained a session. 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) Connection Url= 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) ApplicationName=JDBC 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) PassthroughAuthentication=true 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) transportName=odata 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) org.keycloak.json.adapterConfig={"realm" : "mnd", "realm-public-key" : "MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAmM53zEZoW973ituvK6BeQgrWCO7EO/O6s6e84DxjDGDv2gx+gIRdpyNIw9zC5iSgIdluRvqtYwHqU5wcsX5XGURee7ATefIn3l7ZrVKVAt44ImeZTbcfGBdYH8PIMmMgjuF6qliKRDsqo8J9kza8g3OJhRQ4dwGMLYh+NmJp/tZvEQU+jqSAIblGEKjmHey9y6XK4mwfQrH0dxm69jmexp3YDi9WmdEqjD6lBdML9YbDHLHjwAFP+0YylnVYtFyuAWFnCHHWKPqP5UoITGuaI3XxffcIW9SFM3ICfJ+dJxcx9+f9FIpd21Iw3Om5fq0hvORbhQr4vGGU1m3vX8dr6wIDAQAB", "auth-server-url" : "https://morpheus.fritz.box/auth", "ssl-required" : "all", "disable-trust-manager" : true, "resource" : "Teiid", "credentials" : {"secret" : "237f0e2a-d7dd-4abd-a432-effa0e7ff852"}} 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) org.jboss.jbossfaces.IS_CDI=false 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) waitForLoad=0 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) VirtualDatabaseName=svc.1 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) local-transport-name=odata 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) skiptoken-cache-time=300000 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) batch-size=256 2019-03-05 11:11:43,803 FINE [org.teiid.jdbc] (default task-38) The JDBC Driver successfully obtained a connection. 2019-03-05 11:11:43,804 DEBUG [org.teiid.ODATA] (default task-38) Teiid-Query: /*+ cache(ttl:300000 scope:USER) */ SELECT g0.idProfile, g0.uuidUser FROM my_nutri_diary.Account AS g0 ORDER BY g0.idProfile /* vf4TgdWRfGN0 */ 2019-03-05 11:11:43,804 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 Request Thread vf4TgdWRfGN0.0 with state NEW 2019-03-05 11:11:43,804 DEBUG [org.teiid.TXN_LOG] (default task-38) vf4TgdWRfGN0 before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@5938628b(vf4TgdWRfGN0) 2019-03-05 11:11:43,804 DEBUG [org.teiid.TXN_LOG] (default task-38) vf4TgdWRfGN0 after getOrCreateTransactionContext : vf4TgdWRfGN0 NONE ID:NONE 2019-03-05 11:11:43,804 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0 executing prepared /*+ cache(ttl:300000 scope:USER) */ SELECT g0.idProfile, g0.uuidUser FROM my_nutri_diary.Account AS g0 ORDER BY g0.idProfile /* vf4TgdWRfGN0 */ 2019-03-05 11:11:43,806 DEBUG [org.teiid.AUDIT_LOG] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0 [cef9d7d3-af13-4b13-9e93-ef3c5307f0e9] [my_nutri_diary.Account, my_nutri_diary.Account.idProfile, my_nutri_diary.Account.uuidUser] 2019-03-05 11:11:43,806 DEBUG [org.teiid.AUDIT_LOG] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0 [cef9d7d3-af13-4b13-9e93-ef3c5307f0e9] [] 2019-03-05 11:11:43,807 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 ProcessTree for vf4TgdWRfGN0.0 AccessNode(0) output=[g0.idProfile, g0.uuidUser] SELECT g_0.idProfile AS c_0, g_0.uuidUser AS c_1 FROM my_nutri_diary.Account AS g_0 WHERE g_0.uuidUser = 'cef9d7d3-af13-4b13-9e93-ef3c5307f0e9' ORDER BY c_0 2019-03-05 11:11:43,807 DEBUG [org.teiid.TXN_LOG] (default task-38) vf4TgdWRfGN0 before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@5938628b(vf4TgdWRfGN0) 2019-03-05 11:11:43,807 DEBUG [org.teiid.TXN_LOG] (default task-38) vf4TgdWRfGN0 after getOrCreateTransactionContext : vf4TgdWRfGN0 NONE ID:NONE 2019-03-05 11:11:43,807 DEBUG [org.teiid.BUFFER_MGR] (default task-38) vf4TgdWRfGN0 Creating TupleBuffer: 1200119 [g0.idProfile, g0.uuidUser] [class java.lang.Long, class java.lang.String] batch size 1024 of type PROCESSOR 2019-03-05 11:11:43,807 DEBUG [org.teiid.CONNECTOR] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0.0.477 Create State 2019-03-05 11:11:43,807 DEBUG [org.teiid.PROCESSOR] (Worker66_QueryProcessorQueue10213) vf4TgdWRfGN0 Running task for parent thread default task-38 2019-03-05 11:11:43,807 DEBUG [org.teiid.CONNECTOR] (Worker66_QueryProcessorQueue10213) vf4TgdWRfGN0 vf4TgdWRfGN0.0.0.477 Processing NEW request: SELECT g_0.idProfile AS c_0, g_0.uuidUser AS c_1 FROM my_nutri_diary.Account AS g_0 WHERE g_0.uuidUser = 'cef9d7d3-af13-4b13-9e93-ef3c5307f0e9' ORDER BY c_0 2019-03-05 11:11:43,807 DEBUG [org.teiid.BUFFER_MGR] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0.0.477 Blocking on source query vf4TgdWRfGN0.0.0.477 2019-03-05 11:11:43,807 DEBUG [org.teiid.BUFFER_MGR] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0 Blocking on source request(s). 2019-03-05 11:11:43,807 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 Request Thread vf4TgdWRfGN0.0 - processor blocked 2019-03-05 11:11:48,808 WARN [org.teiid.CONNECTOR] (Worker66_QueryProcessorQueue10213) vf4TgdWRfGN0 Connector worker process failed for atomic-request=vf4TgdWRfGN0.0.0.477: org.teiid.translator.TranslatorException: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:285) at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:71) at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:201) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:354) at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:229) at com.sun.proxy.$Proxy51.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:278) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146) at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64) at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:281) ... 19 more Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:690) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138) ... 21 more Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (5000 [ms]) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:570) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:632) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:604) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624) ... 24 more 2019-03-05 11:11:48,815 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 Request Thread vf4TgdWRfGN0.0 with state PROCESSING 2019-03-05 11:11:48,815 DEBUG [org.teiid.CONNECTOR] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0.0.477 Remove State 2019-03-05 11:11:48,815 DEBUG [org.teiid.CONNECTOR] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0.0.477 Processing Close : SELECT g_0.idProfile AS c_0, g_0.uuidUser AS c_1 FROM my_nutri_diary.Account AS g_0 WHERE g_0.uuidUser = 'cef9d7d3-af13-4b13-9e93-ef3c5307f0e9' ORDER BY c_0 2019-03-05 11:11:48,817 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 QueryProcessor: closing processor 2019-03-05 11:11:48,817 WARN [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 TEIID30020 Processing exception for request vf4TgdWRfGN0.0 'TEIID30504 my_nutri_diary: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary'. Originally TeiidProcessingException 'IJ000655: No managed connections available within configured blocking timeout (5000 [ms])' SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:570.: org.teiid.core.TeiidProcessingException: TEIID30504 my_nutri_diary: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:397) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:157) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:401) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:346) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:261) at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:117) at org.teiid.transport.SessionCheckingProxy.invoke(SessionCheckingProxy.java:60) at com.sun.proxy.$Proxy36.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:213) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:278) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:262) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:211) at com.sun.proxy.$Proxy36.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:745) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:575) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:313) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:72) at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:256) at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:346) at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:164) at org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:323) at org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:246) at org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:167) at org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:96) at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:67) at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:39) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:236) at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:108) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.teiid.olingo.web.gzip.GzipFilter.doFilter(GzipFilter.java:57) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:53) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:59) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68) at org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292) at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:326) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:812) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.teiid.translator.TranslatorException: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:285) at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:71) at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:201) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:354) at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:229) at com.sun.proxy.$Proxy51.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:278) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) ... 3 more Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146) at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64) at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:281) ... 19 more Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:690) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138) ... 21 more Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (5000 [ms]) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:570) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:632) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:604) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624) ... 24 more 2019-03-05 11:11:48,818 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 Removing tuplesource for the request vf4TgdWRfGN0.0 2019-03-05 11:11:48,818 DEBUG [org.teiid.BUFFER_MGR] (default task-38) vf4TgdWRfGN0 Removing TupleBuffer: 1200119 2019-03-05 11:11:48,818 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 vf4TgdWRfGN0.0 Finished Processing 2019-03-05 11:11:48,818 DEBUG [org.teiid.PROCESSOR] (default task-38) vf4TgdWRfGN0 org.teiid.core.TeiidProcessingException: TEIID30504 my_nutri_diary: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary Sending error to client vf4TgdWRfGN0.0 2019-03-05 11:11:48,819 WARN [org.teiid.ODATA] (default task-38) TEIID16052 Unable to process odata request due to: TEIID30504 my_nutri_diary: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary: org.teiid.core.TeiidProcessingException: TEIID30504 my_nutri_diary: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:397) at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:157) at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:401) at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277) at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141) at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148) at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160) at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142) at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:492) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:362) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:285) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:346) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:261) at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:117) at org.teiid.transport.SessionCheckingProxy.invoke(SessionCheckingProxy.java:60) at com.sun.proxy.$Proxy36.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor100.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:213) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:278) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:262) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:211) at com.sun.proxy.$Proxy36.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:745) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:575) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:313) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:72) at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:256) at org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:346) at org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:164) at org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:323) at org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:246) at org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:167) at org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:96) at org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:67) at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:39) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129) at org.teiid.olingo.web.ODataFilter.internalDoFilter(ODataFilter.java:236) at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:108) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.teiid.olingo.web.gzip.GzipFilter.doFilter(GzipFilter.java:57) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at org.teiid.olingo.web.CorsFilter.doFilter(CorsFilter.java:80) at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61) at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131) at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:53) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:59) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68) at org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292) at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508) at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1508) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:326) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:812) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748) Caused by: org.teiid.translator.TranslatorException: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:285) at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:71) at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:201) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:354) at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:229) at com.sun.proxy.$Proxy51.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:278) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206) ... 3 more Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146) at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64) at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:281) ... 19 more Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/my_nutri_diary at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:690) at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789) at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138) ... 21 more Caused by: javax.resource.ResourceException: IJ000655: No managed connections available within configured blocking timeout (5000 [ms]) at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:570) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:632) at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:604) at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624) ... 24 more 2019-03-05 11:11:48,823 FINE [org.teiid.jdbc] (default task-38) Statement closed successfully. 2019-03-05 11:11:48,823 DEBUG [org.teiid.SECURITY] (default task-38) vf4TgdWRfGN0 closeSession vf4TgdWRfGN0 2019-03-05 11:11:48,823 DEBUG [org.teiid.AUDIT_LOG] (default task-38) vf4TgdWRfGN0 [cef9d7d3-af13-4b13-9e93-ef3c5307f0e9] 2019-03-05 11:11:48,823 DEBUG [org.teiid.TXN_LOG] (default task-38) vf4TgdWRfGN0 before cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@5938628b(vf4TgdWRfGN0,false) 2019-03-05 11:11:48,823 DEBUG [org.teiid.TXN_LOG] (default task-38) vf4TgdWRfGN0 after cancelTransactions : null 2019-03-05 11:11:48,823 FINE [org.teiid.jdbc] (default task-38) Connection successfully closed.