4:28 p.m.
Possible load-balancing issue in Teiid
--------------------------------------
Key: TEIID-1453
URL: https://issues.jboss.org/browse/TEIID-1453
Project: Teiid
Issue Type: Bug
Affects Versions: 7.1.1
Reporter: Boris Belovic
Assignee: Steven Hawkins
I have 2 SOA-P servers clustered, both with Teiid installed.
node1 has property org.teiid.sockets.maxCachedInstances set to 2
node2 has property org.teiid.sockets.maxCachedInstances set to 16
There is a web app deployed on node1 which starts consuming connections from Teiid
datasource. When all connections from node1 are used, the app should get a connection from
second node. But instead , I have got following exception:
16:06:59,341 ERROR [STDERR] org.jboss.util.NestedSQLException: Unable to get managed
connection for TEIID-DS; - nested throwable: (javax.resource.ResourceException: Unable to
get managed connection for TEIID-DS)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.getDatasourceConnection(Unknown
Source)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.doGet(Unknown Source)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
16:06:59,342 ERROR [STDERR] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
16:06:59,342 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
16:06:59,342 ERROR [STDERR] Caused by: javax.resource.ResourceException: Unable to get
managed connection for TEIID-DS
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
16:06:59,343 ERROR [STDERR] ... 24 more
16:06:59,343 ERROR [STDERR] Caused by: javax.resource.ResourceException: No
ManagedConnections available within configured blocking timeout ( 30000 [ms] )
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
16:06:59,343 ERROR [STDERR] ... 28 more
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:30 p.m.
New subject: [JBoss JIRA] Updated: (TEIID-1453) Possible load-balancing issue in Teiid
[
https://issues.jboss.org/browse/TEIID-1453?page=com.atlassian.jira.plugin...
]
Boris Belovic updated TEIID-1453:
---------------------------------
Attachment: LoadBalancingServlet.java
ConnectionWorker.java
teiid-ds.xml
Attaching client application and datasource used from obtaining connections
Possible load-balancing issue in Teiid
--------------------------------------
Key: TEIID-1453
URL: https://issues.jboss.org/browse/TEIID-1453
Project: Teiid
Issue Type: Bug
Affects Versions: 7.1.1
Reporter: Boris Belovic
Assignee: Steven Hawkins
Attachments: ConnectionWorker.java, LoadBalancingServlet.java, teiid-ds.xml
I have 2 SOA-P servers clustered, both with Teiid installed.
node1 has property org.teiid.sockets.maxCachedInstances set to 2
node2 has property org.teiid.sockets.maxCachedInstances set to 16
There is a web app deployed on node1 which starts consuming connections from Teiid
datasource. When all connections from node1 are used, the app should get a connection from
second node. But instead , I have got following exception:
16:06:59,341 ERROR [STDERR] org.jboss.util.NestedSQLException: Unable to get managed
connection for TEIID-DS; - nested throwable: (javax.resource.ResourceException: Unable to
get managed connection for TEIID-DS)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.getDatasourceConnection(Unknown
Source)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.doGet(Unknown Source)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
16:06:59,342 ERROR [STDERR] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
16:06:59,342 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
16:06:59,342 ERROR [STDERR] Caused by: javax.resource.ResourceException: Unable to get
managed connection for TEIID-DS
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
16:06:59,343 ERROR [STDERR] ... 24 more
16:06:59,343 ERROR [STDERR] Caused by: javax.resource.ResourceException: No
ManagedConnections available within configured blocking timeout ( 30000 [ms] )
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
16:06:59,343 ERROR [STDERR] ... 28 more
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:38 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1453) Possible load-balancing issue in Teiid
[
https://issues.jboss.org/browse/TEIID-1453?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1453:
---------------------------------------
We'll need a little more detail to know what is going on here, but there may be some
confusion over the feature.
The exception you're getting has to do with the DataSource max connections. The
maxCachedInstances has no influence on the number of connections that can be obtained, it
just caches socket connections for reuse when reconnecting to a particular instance.
So it all depends on what the datasource configuration look like. It can either go
against the embedded instance, in which case node2 will never come into play, or it can be
set up as a socket connection with the two instances listed in the url. In the latter
case there is no preference given to the first source over the second (unless you have
altered the discovery strategy or listed node1 multiple times in the url).
Possible load-balancing issue in Teiid
--------------------------------------
Key: TEIID-1453
URL: https://issues.jboss.org/browse/TEIID-1453
Project: Teiid
Issue Type: Bug
Affects Versions: 7.1.1
Reporter: Boris Belovic
Assignee: Steven Hawkins
Attachments: ConnectionWorker.java, LoadBalancingServlet.java, teiid-ds.xml
I have 2 SOA-P servers clustered, both with Teiid installed.
node1 has property org.teiid.sockets.maxCachedInstances set to 2
node2 has property org.teiid.sockets.maxCachedInstances set to 16
There is a web app deployed on node1 which starts consuming connections from Teiid
datasource. When all connections from node1 are used, the app should get a connection from
second node. But instead , I have got following exception:
16:06:59,341 ERROR [STDERR] org.jboss.util.NestedSQLException: Unable to get managed
connection for TEIID-DS; - nested throwable: (javax.resource.ResourceException: Unable to
get managed connection for TEIID-DS)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.getDatasourceConnection(Unknown
Source)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.doGet(Unknown Source)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
16:06:59,342 ERROR [STDERR] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
16:06:59,342 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
16:06:59,342 ERROR [STDERR] Caused by: javax.resource.ResourceException: Unable to get
managed connection for TEIID-DS
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
16:06:59,343 ERROR [STDERR] ... 24 more
16:06:59,343 ERROR [STDERR] Caused by: javax.resource.ResourceException: No
ManagedConnections available within configured blocking timeout ( 30000 [ms] )
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
16:06:59,343 ERROR [STDERR] ... 28 more
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
4:42 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1453) Possible load-balancing issue in Teiid
[
https://issues.jboss.org/browse/TEIID-1453?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1453:
---------------------------------------
Now that I've seen the datasource xml it seems that you are simply exhausting the
datasource connections. Are you attempting to use more than 10 connections
simultaneously? If that's the case, this has nothing to do with Teiid
load-balancing.
Possible load-balancing issue in Teiid
--------------------------------------
Key: TEIID-1453
URL: https://issues.jboss.org/browse/TEIID-1453
Project: Teiid
Issue Type: Bug
Affects Versions: 7.1.1
Reporter: Boris Belovic
Assignee: Steven Hawkins
Attachments: ConnectionWorker.java, LoadBalancingServlet.java, teiid-ds.xml
I have 2 SOA-P servers clustered, both with Teiid installed.
node1 has property org.teiid.sockets.maxCachedInstances set to 2
node2 has property org.teiid.sockets.maxCachedInstances set to 16
There is a web app deployed on node1 which starts consuming connections from Teiid
datasource. When all connections from node1 are used, the app should get a connection from
second node. But instead , I have got following exception:
16:06:59,341 ERROR [STDERR] org.jboss.util.NestedSQLException: Unable to get managed
connection for TEIID-DS; - nested throwable: (javax.resource.ResourceException: Unable to
get managed connection for TEIID-DS)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.getDatasourceConnection(Unknown
Source)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.doGet(Unknown Source)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
16:06:59,342 ERROR [STDERR] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
16:06:59,342 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
16:06:59,342 ERROR [STDERR] Caused by: javax.resource.ResourceException: Unable to get
managed connection for TEIID-DS
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
16:06:59,343 ERROR [STDERR] ... 24 more
16:06:59,343 ERROR [STDERR] Caused by: javax.resource.ResourceException: No
ManagedConnections available within configured blocking timeout ( 30000 [ms] )
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
16:06:59,343 ERROR [STDERR] ... 28 more
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
9:17 p.m.
New subject: [JBoss JIRA] Commented: (TEIID-1453) Possible load-balancing issue in Teiid
[
https://issues.jboss.org/browse/TEIID-1453?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-1453:
---------------------------------------
Should this issue be marked as resolved?
Possible load-balancing issue in Teiid
--------------------------------------
Key: TEIID-1453
URL: https://issues.jboss.org/browse/TEIID-1453
Project: Teiid
Issue Type: Bug
Affects Versions: 7.1.1
Reporter: Boris Belovic
Assignee: Steven Hawkins
Attachments: ConnectionWorker.java, LoadBalancingServlet.java, teiid-ds.xml
I have 2 SOA-P servers clustered, both with Teiid installed.
node1 has property org.teiid.sockets.maxCachedInstances set to 2
node2 has property org.teiid.sockets.maxCachedInstances set to 16
There is a web app deployed on node1 which starts consuming connections from Teiid
datasource. When all connections from node1 are used, the app should get a connection from
second node. But instead , I have got following exception:
16:06:59,341 ERROR [STDERR] org.jboss.util.NestedSQLException: Unable to get managed
connection for TEIID-DS; - nested throwable: (javax.resource.ResourceException: Unable to
get managed connection for TEIID-DS)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.getDatasourceConnection(Unknown
Source)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.doGet(Unknown Source)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
16:06:59,342 ERROR [STDERR] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
16:06:59,342 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
16:06:59,342 ERROR [STDERR] Caused by: javax.resource.ResourceException: Unable to get
managed connection for TEIID-DS
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
16:06:59,343 ERROR [STDERR] ... 24 more
16:06:59,343 ERROR [STDERR] Caused by: javax.resource.ResourceException: No
ManagedConnections available within configured blocking timeout ( 30000 [ms] )
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
16:06:59,343 ERROR [STDERR] ... 28 more
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
2:11 p.m.
New subject: [JBoss JIRA] Resolved: (TEIID-1453) Possible load-balancing issue in Teiid
[
https://issues.jboss.org/browse/TEIID-1453?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1453.
-----------------------------------
Resolution: Rejected
Possible load-balancing issue in Teiid
--------------------------------------
Key: TEIID-1453
URL: https://issues.jboss.org/browse/TEIID-1453
Project: Teiid
Issue Type: Bug
Affects Versions: 7.1.1
Reporter: Boris Belovic
Assignee: Steven Hawkins
Attachments: ConnectionWorker.java, LoadBalancingServlet.java, teiid-ds.xml
I have 2 SOA-P servers clustered, both with Teiid installed.
node1 has property org.teiid.sockets.maxCachedInstances set to 2
node2 has property org.teiid.sockets.maxCachedInstances set to 16
There is a web app deployed on node1 which starts consuming connections from Teiid
datasource. When all connections from node1 are used, the app should get a connection from
second node. But instead , I have got following exception:
16:06:59,341 ERROR [STDERR] org.jboss.util.NestedSQLException: Unable to get managed
connection for TEIID-DS; - nested throwable: (javax.resource.ResourceException: Unable to
get managed connection for TEIID-DS)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.getDatasourceConnection(Unknown
Source)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.doGet(Unknown Source)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
16:06:59,342 ERROR [STDERR] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
16:06:59,342 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
16:06:59,342 ERROR [STDERR] Caused by: javax.resource.ResourceException: Unable to get
managed connection for TEIID-DS
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
16:06:59,343 ERROR [STDERR] ... 24 more
16:06:59,343 ERROR [STDERR] Caused by: javax.resource.ResourceException: No
ManagedConnections available within configured blocking timeout ( 30000 [ms] )
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
16:06:59,343 ERROR [STDERR] ... 28 more
--
This message is automatically generated by JIRA.
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
5:40 a.m.
New subject: [JBoss JIRA] Closed: (TEIID-1453) Possible load-balancing issue in Teiid
[
https://issues.jboss.org/browse/TEIID-1453?page=com.atlassian.jira.plugin...
]
Steven Hawkins closed TEIID-1453.
---------------------------------
Possible load-balancing issue in Teiid
--------------------------------------
Key: TEIID-1453
URL: https://issues.jboss.org/browse/TEIID-1453
Project: Teiid
Issue Type: Bug
Affects Versions: 7.1.1
Reporter: Boris Belovic
Assignee: Steven Hawkins
Attachments: ConnectionWorker.java, LoadBalancingServlet.java, teiid-ds.xml
I have 2 SOA-P servers clustered, both with Teiid installed.
node1 has property org.teiid.sockets.maxCachedInstances set to 2
node2 has property org.teiid.sockets.maxCachedInstances set to 16
There is a web app deployed on node1 which starts consuming connections from Teiid
datasource. When all connections from node1 are used, the app should get a connection from
second node. But instead , I have got following exception:
16:06:59,341 ERROR [STDERR] org.jboss.util.NestedSQLException: Unable to get managed
connection for TEIID-DS; - nested throwable: (javax.resource.ResourceException: Unable to
get managed connection for TEIID-DS)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.getDatasourceConnection(Unknown
Source)
16:06:59,342 ERROR [STDERR] at
org.jboss.soa.clustering.teiid.LoadBalancingServlet.doGet(Unknown Source)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
16:06:59,342 ERROR [STDERR] at
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:183)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:95)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
16:06:59,342 ERROR [STDERR] at
org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
16:06:59,342 ERROR [STDERR] at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
16:06:59,342 ERROR [STDERR] at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
16:06:59,342 ERROR [STDERR] at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:451)
16:06:59,342 ERROR [STDERR] at java.lang.Thread.run(Thread.java:619)
16:06:59,342 ERROR [STDERR] Caused by: javax.resource.ResourceException: Unable to get
managed connection for TEIID-DS
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:441)
16:06:59,342 ERROR [STDERR] at
org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:424)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:496)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:941)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:89)
16:06:59,343 ERROR [STDERR] ... 24 more
16:06:59,343 ERROR [STDERR] Caused by: javax.resource.ResourceException: No
ManagedConnections available within configured blocking timeout ( 30000 [ms] )
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:311)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:690)
16:06:59,343 ERROR [STDERR] at
org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:404)
16:06:59,343 ERROR [STDERR] ... 28 more
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
4845
days inactive
4900
days old
6 comments
2 participants
participants (2)
-
Boris Belovic (JIRA) -
Steven Hawkins (JIRA)