Hi Pradeep, I saw you had Oracle specific settings such as connectionCachingEnabled. So, maybe you're using Oracle specific DataSourceFactory instead of the default dbcp one. As far as I know, the default factory (org.apache...BasicDataSourceFactory) can be overridden by either factory attribute in the <Resource/> element or javax.sql.DataSource.Factory system property. In that case, it might be an issue around the custom factory implementation, not tomcat.
Regards, Woonsan On Mon, May 16, 2016 at 6:54 PM, pradeep reddy <[email protected]> wrote: > Hello Woonsan, > Via Jconsole I had validated all my changes that were made in > context.xml. But for some reason the logs doesn't show anything about > abandoned connections in catalina.out. I am not sure at this time if its a > bug in tomcat 6 or tomcat-dbcp.jar, but threaddumps clearly show that > threads are waiting on connections from connection pool. > > Thanks > Pradeep > > On Mon, May 16, 2016 at 4:38 PM, Woonsan Ko <[email protected]> wrote: > >> Hi Pradeep, >> >> Just in case, you might want to make sure your changes were really >> applied. For example, an effective context.xml could be in >> conf/Catalina/localhost/... >> If it was applied properly, the stack trace should have shown >> o.a.c.dbcp.AbandonedObjectPool#borrowObject() as well. >> >> Regards, >> >> Woonsan >> >> >> On Mon, May 16, 2016 at 5:54 PM, pradeep reddy <[email protected]> >> wrote: >> > unfortunately it is not writing anything catalina.out :-( >> > >> > Thanks >> > Pradeep >> > >> > On Mon, May 16, 2016 at 3:47 PM, Christopher Schultz < >> > [email protected]> wrote: >> > >> >> -----BEGIN PGP SIGNED MESSAGE----- >> >> Hash: SHA256 >> >> >> >> Pradeep, >> >> >> >> On 5/16/16 5:13 PM, pradeep reddy wrote: >> >> > Hello Christopher, >> >> > >> >> > Let me post my thread dump here. >> >> > >> >> > All HTTP threads are in WAITING state. >> >> > >> >> > "http-12453-346" daemon prio=10 tid=0x00007fbd3061f800 nid=0x59d0 >> >> > in Object.wait() [0x00007fbbe124f000] java.lang.Thread.State: >> >> > WAITING (on object monitor) at java.lang.Object.wait(Native >> >> > Method) at java.lang.Object.wait(Object.java:485) at >> >> > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject(Generi >> >> cObjectPool.java:1104) >> >> > >> >> > >> >> - - locked <0x000000072b18f320> (a >> >> > org.apache.tomcat.dbcp.pool.impl.GenericObjectPool$Latch) at >> >> > org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDat >> >> aSource.java:106) >> >> > >> >> > >> >> at >> >> org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSourc >> >> e.java:1044) >> >> > at >> >> > org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.g >> >> etConnection(LocalDataSourceConnectionProvider.java:82) >> >> >> >> Yep, >> >> > >> >> that certainly looks like you are waiting for connections from >> >> Tomcat's DBCP-based pool. >> >> >> >> > <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"/> >> >> >> >> That configuration looks okay to me. >> >> >> >> The "abandoned" logs are logged to stdout, so they should show up in >> >> your catalina.out file (or stdout.log if you are using a Windows Service >> >> ). >> >> >> >> Are you getting no messages about the abandoned connections? >> >> >> >> - -chris >> >> -----BEGIN PGP SIGNATURE----- >> >> Comment: GPGTools - http://gpgtools.org >> >> Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ >> >> >> >> iQIcBAEBCAAGBQJXOj/gAAoJEBzwKT+lPKRYFVQP/RJKOl0QoU8/qcgMBtdrqwbr >> >> gddAEbqeDVT4nb8Bp/MWpWEoICBr75IGMgSir+qKASwTKXNsORceyxcSn+YxRJnK >> >> POZgIZfwti4vLYMBr9jU1kdUsxCGriettcBZ8pkwJAAtyVX9O0lZiwEZuCp7WwA5 >> >> sbatkYHNtJQsjxQli1XA6NPNjQBS6y+WuQZQ0e/mf3CJUq9Rqa0uvsgAOK9XQTDB >> >> HBNfhF1sjIFy2ro5Vb6OagRHB+9CBxc01gM8V2d37hrbqmUVpiE4pKqO2sWZ6cz5 >> >> yCwSBEcxyNKvDoeP2kz/1HGIhSwB7ifV1zkbhgZaB5eQZVZZubXVcdwgmRMswUgl >> >> RtzqCPF6rOHkgccoe5IqZLb89pQITibz6G3xTAoHhcvh2m7bADAkoN9Jq88DxUqT >> >> CqXEc/01A0AdC5zzqdGPToReLPEcaifLuAK0seGQsHIHAtOytYEY2E9rmoPtCrGp >> >> J4AshEzNtmVT+WUc40FS1+KeabolYBk0biXZiZG/mkVEmKf1DpzPtsBGFfYvo3/i >> >> 0IAOS4zBvluQT1xaqNO6bFJ4fyfIwyWE26FBEPWRpsju2CEg/9+uXw6YM3xYxdkc >> >> TmTTXqp4wvfE82fb2NMGQT3Av/q2fD4Yvzt7DiyHmWL0i0BlsnWBRdJD0dogKFRK >> >> oVun2+a1tFD7lvJnVoiu >> >> =AHDK >> >> -----END PGP SIGNATURE----- >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: [email protected] >> >> For additional commands, e-mail: [email protected] >> >> >> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [email protected] >> For additional commands, e-mail: [email protected] >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
