<!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;">
Jboss Portal 2.7.2: Connection leak ( INACTIVE State) Problem
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/sunrat">sunrat</a> in <i>JBoss Portal</i> - <a href="https://community.jboss.org/message/827369#827369">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p class="p1">Hi All, </p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1">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 <strong>JBP_INSTANCE_PER_USER</strong> table before moving to inactive state </p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1">Checked from last query executed from v$session table and prev_sql_id </p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1"><strong>[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=?</strong> </p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1">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 <strong>PortalDS</strong> 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 class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1"><strong>Environment: </strong></p><p class="p1"><strong>Application server: Jboss</strong><strong>Portal <strong>2.7.2</strong> Application server</strong></p><p class="p1"><strong>OS: Linux </strong></p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1">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 class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1">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 class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1">Thanks in advance </p><p class="p2" style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p class="p1">Sunny</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/827369#827369">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>