<!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;">
Facing Connection leak ( INACTIVE State) Problem - Jboss Portal 2.7.2
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/asheesh.patel">Asheesh Patel</a> in <i>JBoss Portal</i> - <a href="https://community.jboss.org/message/827547#827547">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 All, </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I am seeing there are many connection in 'INACTIVE' state and are present for more than 12-15 hours. Most of the sessions (around 90%) have executed the below query to JBP_INSTANCE_PER_USER table before moving to inactive state </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Checked from last query executed from v$session table and prev_sql_id </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>[org.hibernate.SQL] select persistent0_.PK as PK6_0_, persistent0_.INSTANCE_PK as INSTANCE2_6_0_, persistent0_.SER_STATE as SER3_6_0_, persistent0_.USER_ID as USER4_6_0_, persistent0_.PORTLET_REF as PORTLET5_6_0_ from JBP_INSTANCE_PER_USER persistent0_ where persistent0_.INSTANCE_PK=? and persistent0_.USER_ID=? </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>The open connection count is reaching to DB threshold value and the inactive sessions are not getting utilized for serving the new request and DB is creating the new connection. Also I have found the PortalDS connection is running out of connection while checking from JMX console. The in-use connection is touching the maximum connection count and available connection count to zero. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>We are using below environment for our application: </p><p><strong>Application server:</strong> Jboss Portal Application 2.7.2 </p><p><strong>OS: </strong>Linux </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I also did the code review for connection leak, but seems the above query is getting executed by Jboss internally while user logs-in to application portal. </p><p>Can anyone please help me out, if encountered the similar problem in Jboss portal application server. Let me know if need more information for issue. </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks,</p><p>Asheesh Patel</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/827547#827547">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in JBoss Portal at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2011">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>