Re: Tomcat DS question
Could you give an answer on my question first? Maybe you can create a jsp page printing out the sys prop like this. <% out.println("javax.sql.DataSource.Factory: " + System.getProperty("javax.sql.DataSource.Factory")); %> Let me know what you get there. Regards, Woonsan > On May 17, 2016, at 10:40 PM, pradeep reddywrote: > > Also, how to determine if the application is using ojdbc6.jar or > tomcat-dbcp.jar for connection pool. Apologies I am not a developer and > want to understand the concept of connection pool. > > Thanks > Pradeep > >> On Tue, May 17, 2016 at 2:32 PM, Woonsan Ko wrote: >> >> I don't know much about that for Oracle. What I was trying to mention >> was simply that you can check if you have a system property >> (-Djavax.sql.DataSource.Factory=...) to use a custom one. (Even though >> it's not that common, but it's still possible to override it by system >> property.) Your configuration doesn't have the factory attribute, so >> if you don't have the specific system property, then you can rule out >> my suspicion and focus on some other possibilities. >> >> Regards, >> >> Woonsan >> >> >> On Tue, May 17, 2016 at 2:51 PM, pradeep reddy >> wrote: >>> Thanks for response, would you know if there is any recommended dbcp jar >>> that we need to use for Oracle 12 and Tomcat 6 ? >>> >>> Thanks >>> Pradeep >>> On Tue, May 17, 2016 at 11:07 AM, Woonsan Ko wrote: 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 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 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 >> 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=0x7fbd3061f800 >> nid=0x59d0 > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. > type="javax.sql.DataSource" > driverClassName="oracle.jdbc.OracleDriver" url="XXX" > username="XX" password="XX" initialSize="1" >> maxActive="10" > minIdle="1" maxIdle="1" connectionCachingEnabled="true"
Re: Tomcat DS question
Also, how to determine if the application is using ojdbc6.jar or tomcat-dbcp.jar for connection pool. Apologies I am not a developer and want to understand the concept of connection pool. Thanks Pradeep On Tue, May 17, 2016 at 2:32 PM, Woonsan Kowrote: > I don't know much about that for Oracle. What I was trying to mention > was simply that you can check if you have a system property > (-Djavax.sql.DataSource.Factory=...) to use a custom one. (Even though > it's not that common, but it's still possible to override it by system > property.) Your configuration doesn't have the factory attribute, so > if you don't have the specific system property, then you can rule out > my suspicion and focus on some other possibilities. > > Regards, > > Woonsan > > > On Tue, May 17, 2016 at 2:51 PM, pradeep reddy > wrote: > > Thanks for response, would you know if there is any recommended dbcp jar > > that we need to use for Oracle 12 and Tomcat 6 ? > > > > Thanks > > Pradeep > > > > On Tue, May 17, 2016 at 11:07 AM, Woonsan Ko wrote: > > > >> 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 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 > >> 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 > 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=0x7fbd3061f800 > nid=0x59d0 > >> >> >> > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. > >> >> >> > >> >> >> > >> >> >> > type="javax.sql.DataSource" > >> >> >> > driverClassName="oracle.jdbc.OracleDriver" url="XXX" > >> >> >> > username="XX" password="XX" initialSize="1" > maxActive="10" > >> >> >> > minIdle="1" maxIdle="1" connectionCachingEnabled="true" > >> >> >> > fastConnectionFailoverEnabled="true" > >> >> >> > connectionCacheProperties="{MinLimit=1, MaxLimit=20, > >> >> >> > InitialLimit=1, >
Re: Tomcat DS question
I don't know much about that for Oracle. What I was trying to mention was simply that you can check if you have a system property (-Djavax.sql.DataSource.Factory=...) to use a custom one. (Even though it's not that common, but it's still possible to override it by system property.) Your configuration doesn't have the factory attribute, so if you don't have the specific system property, then you can rule out my suspicion and focus on some other possibilities. Regards, Woonsan On Tue, May 17, 2016 at 2:51 PM, pradeep reddywrote: > Thanks for response, would you know if there is any recommended dbcp jar > that we need to use for Oracle 12 and Tomcat 6 ? > > Thanks > Pradeep > > On Tue, May 17, 2016 at 11:07 AM, Woonsan Ko wrote: > >> 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 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 >> 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 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 >> >> 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=0x7fbd3061f800 nid=0x59d0 >> >> >> > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. >> >> >> >> >> >> > > >> >> > type="javax.sql.DataSource" >> >> >> > driverClassName="oracle.jdbc.OracleDriver" url="XXX" >> >> >> > username="XX" password="XX" 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=X" 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 >>
Re: Tomcat DS question
Hi Chris, It is not writing anything related to DBCP in catalina.out. Thanks Pradeep On Tue, May 17, 2016 at 1:49 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Pradeep, > > On 5/17/16 2:51 PM, pradeep reddy wrote: > > Thanks for response, would you know if there is any recommended > > dbcp jar that we need to use for Oracle 12 and Tomcat 6 ? > > You don't need anything special. Woonson did not read your original > configuration evidently, or the stack trace. Both of those show that > DBCP is in fact in use and no special factory is being used. > > When you say that "it is not writing anything catalina.out", do you > mean that catalina.out does not exist, is empty, or has log messages > in it but nothing about DBCP itself? > > - -chris > -BEGIN PGP SIGNATURE- > Comment: GPGTools - http://gpgtools.org > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ > > iQIcBAEBCAAGBQJXO3XlAAoJEBzwKT+lPKRYoiIP/R5hPraVx3xDft+E4zLSPdon > SM+9nQcqdTRGfLvjbOHdsH1Yt+4cRIhTegxHdfSalsHvBV8iuh5xPdcn4epwKZl4 > Twu+s8LTaNK5PD3bhV3qJtlNpg+IyBAQoqk9weZcHsgaa/0tfZEeH3tIrJbBoZ+L > v///WExXCnviksBGxwk2w5iimYMcsyTVdADh/Pi8SgdinKtakxly+d0rfu0aUR2S > KFfBMaKr4bqf22PxVM5IhNxURzrGep73b18mT0kZ96yTjWpan7lOBzyx6w+2u5GK > +GIuwHGqqtoWDPxLEo9hG0JgNOCiLszNcdMGeyd3l3CXlPxp4vvMcj4LvUx7lqrs > oJ/UoPNFgPW2SfJNSagluvlIcqMzkFADLu7pfF15QoHJQsR2gNcoFn6xLq4E08WM > 0Igcyxn9+42Gkl5troeGnt0DOgMF4SzFATXg70263GwXELqLBHB6DYPBrugLmdCx > XBhPGh9PAy/mT3wJ1qEVlAQCAl7vY5jI0E6ZBl1ljLcQM9x1YQZ3sJhPlOgcqMCB > bERByGDx3DMls5/eWFwohPbVV2kG6xpDfvhW2ZLF1IP/+DHNyD/phyZZr9sPS164 > d7/eYEWL63qWCt1MR3AlXO37UDIRQ15kdcPuK9QCvR+nC/ULPqAGB50KeDe7YyLH > fBuVMTq84RA9M1pCYCRy > =W5lv > -END PGP SIGNATURE- > > - > To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org > For additional commands, e-mail: users-h...@tomcat.apache.org > >
Re: Tomcat DS question
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Pradeep, On 5/17/16 2:51 PM, pradeep reddy wrote: > Thanks for response, would you know if there is any recommended > dbcp jar that we need to use for Oracle 12 and Tomcat 6 ? You don't need anything special. Woonson did not read your original configuration evidently, or the stack trace. Both of those show that DBCP is in fact in use and no special factory is being used. When you say that "it is not writing anything catalina.out", do you mean that catalina.out does not exist, is empty, or has log messages in it but nothing about DBCP itself? - -chris -BEGIN PGP SIGNATURE- Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQIcBAEBCAAGBQJXO3XlAAoJEBzwKT+lPKRYoiIP/R5hPraVx3xDft+E4zLSPdon SM+9nQcqdTRGfLvjbOHdsH1Yt+4cRIhTegxHdfSalsHvBV8iuh5xPdcn4epwKZl4 Twu+s8LTaNK5PD3bhV3qJtlNpg+IyBAQoqk9weZcHsgaa/0tfZEeH3tIrJbBoZ+L v///WExXCnviksBGxwk2w5iimYMcsyTVdADh/Pi8SgdinKtakxly+d0rfu0aUR2S KFfBMaKr4bqf22PxVM5IhNxURzrGep73b18mT0kZ96yTjWpan7lOBzyx6w+2u5GK +GIuwHGqqtoWDPxLEo9hG0JgNOCiLszNcdMGeyd3l3CXlPxp4vvMcj4LvUx7lqrs oJ/UoPNFgPW2SfJNSagluvlIcqMzkFADLu7pfF15QoHJQsR2gNcoFn6xLq4E08WM 0Igcyxn9+42Gkl5troeGnt0DOgMF4SzFATXg70263GwXELqLBHB6DYPBrugLmdCx XBhPGh9PAy/mT3wJ1qEVlAQCAl7vY5jI0E6ZBl1ljLcQM9x1YQZ3sJhPlOgcqMCB bERByGDx3DMls5/eWFwohPbVV2kG6xpDfvhW2ZLF1IP/+DHNyD/phyZZr9sPS164 d7/eYEWL63qWCt1MR3AlXO37UDIRQ15kdcPuK9QCvR+nC/ULPqAGB50KeDe7YyLH fBuVMTq84RA9M1pCYCRy =W5lv -END PGP SIGNATURE- - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
Re: Tomcat DS question
Thanks for response, would you know if there is any recommended dbcp jar that we need to use for Oracle 12 and Tomcat 6 ? Thanks Pradeep On Tue, May 17, 2016 at 11:07 AM, Woonsan Kowrote: > 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 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 > 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 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 > >> 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=0x7fbd3061f800 nid=0x59d0 > >> >> > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. > >> >> > >> >> > >> >> > type="javax.sql.DataSource" > >> >> > driverClassName="oracle.jdbc.OracleDriver" url="XXX" > >> >> > username="XX" password="XX" 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=X" 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 > >> >>
Re: Tomcat DS question
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 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 reddywrote: > 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 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 >> 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=0x7fbd3061f800 nid=0x59d0 >> >> > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. >> >> >> >> > > >> > type="javax.sql.DataSource" >> >> > driverClassName="oracle.jdbc.OracleDriver" url="XXX" >> >> > username="XX" password="XX" 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=X" 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:
Re: Tomcat DS question
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 Kowrote: > 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 > 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=0x7fbd3061f800 nid=0x59d0 > >> > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. > >> > >> > >> > type="javax.sql.DataSource" > >> > driverClassName="oracle.jdbc.OracleDriver" url="XXX" > >> > username="XX" password="XX" 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=X" 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 > >
Re: Tomcat DS question
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 reddywrote: > 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=0x7fbd3061f800 nid=0x59d0 >> > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. >> >> > > > type="javax.sql.DataSource" >> > driverClassName="oracle.jdbc.OracleDriver" url="XXX" >> > username="XX" password="XX" 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=X" 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
Re: Tomcat DS question
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=0x7fbd3061f800 nid=0x59d0 > > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. > > > > type="javax.sql.DataSource" > > driverClassName="oracle.jdbc.OracleDriver" url="XXX" > > username="XX" password="XX" 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=X" 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 > >
Re: Tomcat DS question
-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=0x7fbd3061f800 nid=0x59d0 > in Object.wait() [0x7fbbe124f000] 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 <0x00072b18f320> (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. > type="javax.sql.DataSource" > driverClassName="oracle.jdbc.OracleDriver" url="XXX" > username="XX" password="XX" 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=X" 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
Re: Tomcat DS question
Hello Christopher, Let me post my thread dump here. All HTTP threads are in WAITING state. "http-12453-346" daemon prio=10 tid=0x7fbd3061f800 nid=0x59d0 in Object.wait() [0x7fbbe124f000] 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(GenericObjectPool.java:1104) - locked <0x00072b18f320> (a org.apache.tomcat.dbcp.pool.impl.GenericObjectPool$Latch) at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:106) at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044) at org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:82) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167) at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161) at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577) at org.hibernate.loader.Loader.doQuery(Loader.java:696) at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) at org.hibernate.loader.Loader.doList(Loader.java:2232) at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) at org.hibernate.loader.Loader.list(Loader.java:2124) at org.hibernate.loader.custom.CustomLoader.list(CustomLoader.java:312) at org.hibernate.impl.SessionImpl.listCustomQuery(SessionImpl.java:1723) at org.hibernate.impl.AbstractSessionImpl.list(AbstractSessionImpl.java:165) at org.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:175) at com.adobe_services.orderservice.persistence.dao.impl.StoreEmailDAOImpl.findPendingEmailOidsForOrderNumber(StoreEmailDAOImpl.java:237) at com.adobe_services.orderservice.service.OrderServiceImpl.findPendingEmailOidsForOrderNumber_aroundBody4(OrderServiceImpl.java:670) at com.adobe_services.orderservice.service.OrderServiceImpl.findPendingEmailOidsForOrderNumber_aroundBody5$advice(OrderServiceImpl.java:37) at com.adobe_services.orderservice.service.OrderServiceImpl.findPendingEmailOidsForOrderNumber(OrderServiceImpl.java:1) at sun.reflect.GeneratedMethodAccessor948.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy112.findPendingEmailOidsForOrderNumber(Unknown Source) at sun.reflect.GeneratedMethodAccessor948.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.orm.hibernate3.HibernateInterceptor.invoke(HibernateInterceptor.java:111) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy113.findPendingEmailOidsForOrderNumber(Unknown Source) at sun.reflect.GeneratedMethodAccessor948.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at
Re: Tomcat DS question
-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 auth="Container" type="javax.sql.DataSource" > driverClassName="oracle.jdbc.OracleDriver" url="XXX" > username="XX" password="XX" 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=X" 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
Tomcat DS question
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 Thanks Pradeep