Thanks for the reply.

I tried with the following settings:

     <datasource>
  |          <name>LDAP</name>
  |          
<service-name>portal:service=Module,type=LDAPConnectionContext</service-name>
  |          <class>org.jboss.portal.identity.ldap.LDAPConnectionContext</class>
  |          <config>
  |             <option>
  |                <name>host</name>
  |                <value>server</value>
  |             </option>
  |             <option>
  |                <name>port</name>
  |                <value>389</value>
  |             </option>
  |             <option>
  |                <name>contextFactory</name>
  |                <value>com.sun.jndi.ldap.LdapCtxFactory</value>
  |             </option>
  |             <option>
  |                <name>adminDN</name>
  |                <value>dn</value>
  |             </option>
  |             <option>
  |                <name>adminPassword</name>
  |                <value>pass</value>
  |             </option>
  |             <option>
  |                <name>poolingPrefsize</name>
  |                <value>20</value>
  |             </option>
  |             <option>
  |                <name>poolingMaxsize</name>
  |                <value>100</value>
  |             </option>
  |             <option>
  |                <name>poolingTimeout</name>
  |                <value>5000</value>
  |             </option>
  |             <option>
  |                <name>poolingDebug</name>
  |                <value>fine</value>
  |             </option>
  |          </config>
  |       </datasource>
  |    </datasources>

I'm testing the portal in the admin console - the default portal has some 
portlets by me that are actually using the portal identity-api. So not touching 
the just in case they have something to do with this.

Same thing as before. The setting seem to have no effect. When I do the user 
search it opens tens of connections according to netstat. I'm not seen any 
debug anywhere even though using the debug option. Where should I find the 
debugging logs?

In the jmx-console I can see that the pooling properties seem to be correct. 
However, clicking a few times on search users I end up with way over hunder 
connections.

At this point I decided to play around with JAVA_OPTS and added:
-Dcom.sun.jndi.ldap.connect.pool.debug=fine 
-Dcom.sun.jndi.ldap.connect.pool=true 
to JAVA_OPTS in run.conf

This seem to activate the pooling or at least the debug! The first click 
(portal admin console) results in this in STRERR:

22:17:45,188 ERROR [STDERR] Use [EMAIL PROTECTED]
22:17:45,191 ERROR [STDERR] Release [EMAIL PROTECTED]
22:17:45,192 ERROR [STDERR] Use [EMAIL PROTECTED]
22:17:45,193 ERROR [STDERR] Release [EMAIL PROTECTED]
22:17:45,194 ERROR [STDERR] Use [EMAIL PROTECTED]
22:17:45,195 ERROR [STDERR] Release [EMAIL PROTECTED]
22:17:45,196 ERROR [STDERR] Use [EMAIL PROTECTED]
22:17:45,197 ERROR [STDERR] Release [EMAIL PROTECTED]
22:17:45,198 ERROR [STDERR] Use [EMAIL PROTECTED]
22:17:45,199 ERROR [STDERR] Release [EMAIL PROTECTED]
22:17:45,199 ERROR [STDERR] Use [EMAIL PROTECTED]
22:17:45,201 ERROR [STDERR] Release [EMAIL PROTECTED]

Now when I click Members tab, everything seems fine again except for one 
connection not getting released (quite a few connections used for one click 
btw):
22:19:57,735 ERROR [STDERR] Use [EMAIL PROTECTED]
22:19:57,801 ERROR [STDERR] Use [EMAIL PROTECTED]
22:19:57,803 ERROR [STDERR] Release [EMAIL PROTECTED]
22:19:57,805 ERROR [STDERR] Use [EMAIL PROTECTED]
22:19:57,806 ERROR [STDERR] Release [EMAIL PROTECTED]
22:19:57,807 ERROR [STDERR] Use [EMAIL PROTECTED]
22:19:57,808 ERROR [STDERR] Release [EMAIL PROTECTED]
22:19:57,809 ERROR [STDERR] Use [EMAIL PROTECTED]
22:19:57,810 ERROR [STDERR] Release [EMAIL PROTECTED]
22:19:57,810 ERROR [STDERR] Use [EMAIL PROTECTED]
22:19:57,812 ERROR [STDERR] Release [EMAIL PROTECTED]
22:19:57,812 ERROR [STDERR] Use [EMAIL PROTECTED]
22:19:57,814 ERROR [STDERR] Release [EMAIL PROTECTED]

Now clicking search users:
22:21:39,217 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,249 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,253 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,255 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,255 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,258 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,260 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,260 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,263 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,266 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,266 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,270 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,272 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,273 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,283 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,289 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,294 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,301 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,305 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,307 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,308 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,311 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,313 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,314 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,317 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,319 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,320 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,323 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,325 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,325 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,335 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,340 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,345 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,352 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,356 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,358 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,359 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,362 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,364 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,365 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,368 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,370 ERROR [LDAPUserProfileModuleImpl] No such attribute ('givenName') 
in entry: cn=jukkatv,ou=People,dc=replaced,dc=fi
22:21:39,370 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,371 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,374 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,376 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,377 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,389 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,394 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,405 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,411 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,416 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,418 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,419 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,422 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,424 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,425 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,428 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,430 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,431 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,434 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,436 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,437 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,446 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,451 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,456 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,463 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,469 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,471 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,472 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,475 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,477 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,478 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,481 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,483 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,484 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,487 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,489 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,490 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,499 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,504 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,510 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,516 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,520 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,522 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,522 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,525 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,528 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,528 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,531 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,533 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,534 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,537 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,539 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,540 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,549 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,554 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,559 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,565 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,570 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,572 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,573 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,576 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,578 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,579 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,582 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,585 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,585 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,588 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,591 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,591 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,600 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,606 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,611 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,617 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,621 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,624 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,624 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,628 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,630 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,631 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,634 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,636 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,637 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,640 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,642 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,643 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,652 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,658 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,664 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,670 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,674 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,677 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,677 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,680 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,683 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,683 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,686 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,688 ERROR [LDAPUserProfileModuleImpl] No such attribute ('givenName') 
in entry: cn=a2104,ou=People,dc=replaced,dc=fi
22:21:39,689 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,689 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,692 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,694 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,695 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,704 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,710 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,715 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,721 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,725 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,727 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,728 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,731 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,733 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,734 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,737 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,739 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,740 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,743 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,745 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,745 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,755 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,761 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,766 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,812 ERROR [STDERR] Create and use [EMAIL PROTECTED]:389]
22:21:39,815 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,817 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,818 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,818 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,820 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,820 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,822 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,822 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,824 ERROR [STDERR] Release [EMAIL PROTECTED]
22:21:39,824 ERROR [STDERR] Use [EMAIL PROTECTED]
22:21:39,825 ERROR [STDERR] Release [EMAIL PROTECTED]

And I end up with 83 established connections. The above debug has a count of 78 
for "Create and use" and 46 for "Release".

When I shutdown the server I can see the debug information that the connections 
are released.

Now I added some more options for JAVA_OPTS:
-Dcom.sun.jndi.ldap.connect.pool.maxsize=40 
-Dcom.sun.jndi.ldap.connect.pool.prefsize=20  
-Dcom.sun.jndi.ldap.connect.pool.timeout=5000

Now the timeout kicks in (notice I had 5000 also in the portal config which 
didn't have any effect), I get lines like:
22:31:09,184 ERROR [STDERR] Expired [EMAIL PROTECTED] expired

And the connections are in TIME_WAIT according to netstat!

So looking good but the user search causes connections leaks again and proves 
that the maxsize 40 is working since one user search is enough to get the 
portal hang and it's not getting any connections after 40.

Btw, I have Mysql5 setup as the portal database, but that shouldn't have 
anything to do with this, right?

So something is causing the connections not been released. I'm suspecting the 
ProfileModule since this leaking seems to happen everytime user properties is 
been fetched (user search for example). What would be the best way to debug 
this problem?

I will try to play around with the external context approach tomorrow but 
getting a bit frustrated. With external context none of those JAVA_OPTS I tried 
had any effect. Has anybody got a good pooling example done with external 
context?

View the original post : 
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4141487#4141487

Reply to the post : 
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4141487
_______________________________________________
jboss-user mailing list
jboss-user@lists.jboss.org
https://lists.jboss.org/mailman/listinfo/jboss-user

Reply via email to