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 <pradeep....@gmail.com> 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 <woon...@apache.org> 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 <pradeep....@gmail.com>
>> wrote:
>> > unfortunately it is not writing anything catalina.out :-(
>> >
>> > Thanks
>> > Pradeep
>> >
>> > On Mon, May 16, 2016 at 3:47 PM, Christopher Schultz <
>> > ch...@christopherschultz.net> 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: users-unsubscr...@tomcat.apache.org
>> >> For additional commands, e-mail: users-h...@tomcat.apache.org
>> >>
>> >>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
>> For additional commands, e-mail: users-h...@tomcat.apache.org
>>
>>
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
