-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA256 Pradeep,
On 5/16/16 12:34 PM, pradeep reddy wrote: > Hello Community, I have a weird issue, which I am not able to > figure it out and needed some help. I am a Web Administrator and in > my organization we use Tomcat + CXF to run our commerce services. > > We are running on Tomcat-6.0.32 and jdk1.6.0_24, anyways we have > recently started to see issues with our connection pool and from > our monitoring tools its evident that we are running out of > connections. Now I have read some manuals on Apache Tomcat Page to > use below three settings to fail gracefully and to Log those > sessions which are either causing connection leak or abandoned > > removeAbandoned - set to true if we want to detect leaked > connections removeAbandonedTimeout logAbandoned="true" > > > But unfortunately even after having configured those above three > settings, I still see some sessions just hanging in and not > releasing the connection and I need help in understanding what I am > doing wrong. > > My DS cnfiguration <Resource name="jdbc/XXXXXDataSource" > auth="Container" type="javax.sql.DataSource" > driverClassName="oracle.jdbc.OracleDriver" url="XXXXXXXXXXX" > username="XXXXXX" password="XXXXXX" initialSize="1" maxActive="10" > minIdle="1" maxIdle="1" connectionCachingEnabled="true" > fastConnectionFailoverEnabled="true" > connectionCacheProperties="{MinLimit=1, MaxLimit=20, > InitialLimit=1, oracle.net.ns.SQLnetDef.TCP_CONNTIMEOUT_STR=3000}" > ONSConfiguration="nodes=XXXXX" validationQuery="SELECT 1 from > DUAL" removeAbandoned="true" removeAbandonedTimeout="30" > logAbandoned="true" maxWait="-1"/> What do the stack traces look like or the hung threads? - -chris -----BEGIN PGP SIGNATURE----- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJXOjC7AAoJEBzwKT+lPKRYl5oQAL+tSB6ZkBpMOqihbN79UHdG LAKsRdenKPhphA2yjahoXIx9nWvSd03jsFy8uzJYe3ztyRkJGW4h7VAm37gAHkKl sg/jtQzvtl4HYO6YI1v5OgljxR5GnK8CvGad5PhOg/s6/mLRZ9kfUdGgv6tCYHXe lpoEOA8Em6tMaTwg1u07gXAqMEJyqg5QA3tYR3MU+0RALhNeVWgXNoEULol0FEil PJVcAVN1WC6AX0qVa3JlXIK+PHHLDDZWLH7qrpo2nGVvcf/5oFf27N5AnnnarH87 RtOWHjWgK4APRVkEEOSX8Pef7YAb2dj6E+6fgf+3v117eEwYJlkLWU5pS/6Q3zWm 23obZllDks1clyYzs7C96zJukFb60wSRRGPdbHoSiKspH1J3/GavebaG7Sbg2ADB DNLcWG0fd4FUmy+kbG+pPi3hdEdwOQ0c6kgaqH7ARDjdYtfVKV8kgCe6wpJlKx+k WXfDK3cE2jWhUT/zx9VMutM+38gYk9G6ArUIZvOg5qdhcv6LvX299so3x8dEaL7w D/NNz4+yTJGVfQMnJ4LTnZR+R6wCUdhpS0quSYo9ZJNpXGERo3NY0aV80g4S8MQJ HObHoGDSUHDw4lScKCpIJYT7ZZ+Ok25fqyrlx+JN1fhsq7PcPtDQz/7FrRuhKEGa z8kfsKuyduF8cW1gDj5h =s/bM -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org