<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Maximum Database connection issue in JBoss 5.1
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/amathewjboss1">Anil Mathew</a> in <i>Datasource Configuration</i> - <a href="https://community.jboss.org/message/731958#731958">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Hi,</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>    We have a big application which uses JBoss 5.1 and is running on Linux servers. Our production environments has 20 web servers (which runs on Apache/Tomcat) which talks to 4 app servers (which runs on JBoss 5.1 in one cluster) with a Oracle 9i database. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>   As far as the JBoss configuration is concerned, we are using pooledha invoker as our EJB calls are remote calls. Also <max-pool-size> in the oracle-ds.xml is set to 275. The ha-legacy-jboss-beans.xml has the following setup for the pooledInvokerHA:</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>  <bean name="PooledInvokerHA"</p><p>         class="org.jboss.invocation.pooled.server.PVOPooledInvokerHA"></p><p>          </p><p>      <depends>jboss:service=TransactionManager</depends></p><p>      <depends>HAPartition</depends></p><p>      </p><p>      <annotation>@org.jboss.aop.microcontainer.aspects.jmx.JMX(name="jboss:service=invoker,type=pooledha", exposedInterface=org.jboss.invocation.pooled.server.PooledInvokerMBean.class, registerDirectly=true)</annotation></p><p>      </p><p>      <property name="numAcceptThreads">1</property></p><p>      <property name="maxPoolSize">800</property></p><p>      <property name="clientMaxPoolSize">300</property></p><p>      <property name="socketTimeout">150000</property></p><p>            <property name="serverBindAddress"></p><p>         <value-factory bean="ServiceBindingManager" method="getStringBinding" </p><p>            parameter="jboss:service=invoker,type=pooledha"/></p><p>      </property></p><p>      <property name="serverBindPort"></p><p>         <value-factory bean="ServiceBindingManager" method="getIntBinding" </p><p>            parameter="jboss:service=invoker,type=pooledha"/></p><p>      </property></p><p>      <property name="clientConnectAddress">${jboss.bind.address}</property></p><p>      <property name="clientConnectPort">0</property></p><p>      <property name="enableTcpNoDelay">false</property></p><p>      <property name="transactionManagerService">jboss:service=TransactionManager</property></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>   </bean></p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>   The issue we are facing is that when we have an average/high load, we are reaching the "InUseConnectionCount" to 275 very quickly. When we look at the database side, we really don't have any traffic. So once we reached the maximum connection mark, the app servers started to get slow and then FULL GC and then it will crash. An interesting point is that during this situation just recycling the app servers doesn't kill the connections though.i.e we end up in recycling the complete web servers so that all the connections will be released. We spend many hours trying to figure out the issue, but no luck. So any thoughts on this issue will be appreciated.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks</p><p>Anil Mathew</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/731958#731958">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in Datasource Configuration at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>