You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by rohitmp <ro...@gmail.com> on 2008/03/16 21:29:47 UTC

Re: DBCP: Threads sitting forever in getConnection()?

HI All,
I too am facing the same issue.
But in contrast i have my resource setup in context.xml only
But still tomcat is waiting indefinitely to to get a connection.

My context file is as below

<?xml version="1.0" encoding="UTF-8"?>
<Context path="/mycontextpath">
    <Resource name="jdbc/connPool" auth="Container"
            type="javax.sql.DataSource" username="schot" password="tiger"
            driverClassName="org.gjt.mm.mysql.Driver"
url="jdbc:mysql://localhost:3306/myDb"
            maxActive="100" maxIdle="30"/>
            
   </Context>

the relevant thread dump is as follows

"http-8080-Processor2" daemon prio=10 tid=0x08374800 nid=0xef4 
in Object.wait() [0xae069000..0xae069e30]
   java.lang.Thread.State: WAITING (on object monitor)
	at java.lang.Object.wait(Native Method)
	- waiting on <0xaf619100> (a org.apache.tomcat.dbcp.pool.impl.GenericObjectPool)
	at java.lang.Object.wait(Object.java:485)
	at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject
(GenericObjectPool.java:810)
	- locked <0xaf619100> (a org.apache.tomcat.dbcp.pool.impl.GenericObjectPool)
	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection
(PoolingDataSource.java:96)
	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection
(BasicDataSource.java:880)
	at com.bhagin.vaanee.util.DBConnection.init
(DBConnection.java:64)
	at com.bhagin.vaanee.authorisation.AttributeBeanSetter.fngetSessionAttributeBean
(AttributeBeanSetter.java:42)
	at org.apache.jsp.authorize_jsp._jspService
(authorize_jsp.java:116)
	at org.apache.jasper.runtime.HttpJspBase.service(
HttpJspBase.java:98)
	at javax.servlet.http.HttpServlet.service
(HttpServlet.java:803)
	at org.apache.jasper.servlet.JspServletWrapper.service
(JspServletWrapper.java:331)
	at org.apache.jasper.servlet.JspServlet.serviceJspFile
(JspServlet.java:329)
	at org.apache.jasper.servlet.JspServlet.service
(JspServlet.java:265)
	at javax.servlet.http.HttpServlet.service
(HttpServlet.java:803)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
(ApplicationFilterChain.java:269)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter
(ApplicationFilterChain.java:188)
	at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:174)
	at org.apache.catalina.core.StandardHostValve.invoke
(StandardHostValve.java:127)
	at org.apache.catalina.valves.ErrorReportValve.invoke(
ErrorReportValve.java:117)
	at org.apache.catalina.core.StandardEngineValve.invoke
(StandardEngineValve.java:108)
	at org.apache.catalina.connector.CoyoteAdapter.service
(CoyoteAdapter.java:151)
	at org.apache.coyote.http11.Http11Processor.process
(Http11Processor.java:874)
	at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.
processConnection(Http11BaseProtocol.java:665)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
(PoolTcpEndpoint.java:528)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
(LeaderFollowerWorkerThread.java:81)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
(ThreadPool.java:689)
	at java.lang.Thread.run(Thread.java:619)


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Re: DBCP: Threads sitting forever in getConnection()?

Posted by Cattapan <ca...@gmail.com>.
You should set the maxWait parameter.




On Sun, Mar 16, 2008 at 5:29 PM, rohitmp <ro...@gmail.com> wrote:

> HI All,
> I too am facing the same issue.
> But in contrast i have my resource setup in context.xml only
> But still tomcat is waiting indefinitely to to get a connection.
>
> My context file is as below
>
> <?xml version="1.0" encoding="UTF-8"?>
> <Context path="/mycontextpath">
>    <Resource name="jdbc/connPool" auth="Container"
>            type="javax.sql.DataSource" username="schot" password="tiger"
>            driverClassName="org.gjt.mm.mysql.Driver"
> url="jdbc:mysql://localhost:3306/myDb"
>            maxActive="100" maxIdle="30"/>
>
>   </Context>
>
> the relevant thread dump is as follows
>
> "http-8080-Processor2" daemon prio=10 tid=0x08374800 nid=0xef4
> in Object.wait() [0xae069000..0xae069e30]
>   java.lang.Thread.State: WAITING (on object monitor)
>        at java.lang.Object.wait(Native Method)
>        - waiting on <0xaf619100> (a
> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool)
>        at java.lang.Object.wait(Object.java:485)
>        at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject
> (GenericObjectPool.java:810)
>        - locked <0xaf619100> (a
> org.apache.tomcat.dbcp.pool.impl.GenericObjectPool)
>        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection
> (PoolingDataSource.java:96)
>        at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection
> (BasicDataSource.java:880)
>        at com.bhagin.vaanee.util.DBConnection.init
> (DBConnection.java:64)
>        at
> com.bhagin.vaanee.authorisation.AttributeBeanSetter.fngetSessionAttributeBean
> (AttributeBeanSetter.java:42)
>        at org.apache.jsp.authorize_jsp._jspService
> (authorize_jsp.java:116)
>        at org.apache.jasper.runtime.HttpJspBase.service(
> HttpJspBase.java:98)
>        at javax.servlet.http.HttpServlet.service
> (HttpServlet.java:803)
>        at org.apache.jasper.servlet.JspServletWrapper.service
> (JspServletWrapper.java:331)
>        at org.apache.jasper.servlet.JspServlet.serviceJspFile
> (JspServlet.java:329)
>        at org.apache.jasper.servlet.JspServlet.service
> (JspServlet.java:265)
>        at javax.servlet.http.HttpServlet.service
> (HttpServlet.java:803)
>        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:269)
>        at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
>        at org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:213)
>        at org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:174)
>        at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:127)
>        at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:117)
>        at org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:108)
>        at org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:151)
>        at org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:874)
>        at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.
> processConnection(Http11BaseProtocol.java:665)
>        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.java:528)
>        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWorkerThread.java:81)
>        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.java:689)
>        at java.lang.Thread.run(Thread.java:619)
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>


-- 
Bernardo Cattapan
cattapan@gmail.com

Re: DBCP: Threads sitting forever in getConnection()?

Posted by David Smith <dn...@cornell.edu>.
Hi.

1. Please post this in a separate thread as it's a separate issue.

2. Is this happening immediately (in the first request) after start or 
does it take a few requests to make it wait for a connection?  If it 
takes a few requests, your code is not closing connection as it should.  
They don't close themselves -- you need to explicitly close them so they 
can return to the pool.

--David

rohitmp wrote:
> HI All,
> I too am facing the same issue.
> But in contrast i have my resource setup in context.xml only
> But still tomcat is waiting indefinitely to to get a connection.
>
> My context file is as below
>
> <?xml version="1.0" encoding="UTF-8"?>
> <Context path="/mycontextpath">
>     <Resource name="jdbc/connPool" auth="Container"
>             type="javax.sql.DataSource" username="schot" password="tiger"
>             driverClassName="org.gjt.mm.mysql.Driver"
> url="jdbc:mysql://localhost:3306/myDb"
>             maxActive="100" maxIdle="30"/>
>             
>    </Context>
>
> the relevant thread dump is as follows
>
> "http-8080-Processor2" daemon prio=10 tid=0x08374800 nid=0xef4 
> in Object.wait() [0xae069000..0xae069e30]
>    java.lang.Thread.State: WAITING (on object monitor)
> 	at java.lang.Object.wait(Native Method)
> 	- waiting on <0xaf619100> (a org.apache.tomcat.dbcp.pool.impl.GenericObjectPool)
> 	at java.lang.Object.wait(Object.java:485)
> 	at org.apache.tomcat.dbcp.pool.impl.GenericObjectPool.borrowObject
> (GenericObjectPool.java:810)
> 	- locked <0xaf619100> (a org.apache.tomcat.dbcp.pool.impl.GenericObjectPool)
> 	at org.apache.tomcat.dbcp.dbcp.PoolingDataSource.getConnection
> (PoolingDataSource.java:96)
> 	at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection
> (BasicDataSource.java:880)
> 	at com.bhagin.vaanee.util.DBConnection.init
> (DBConnection.java:64)
> 	at com.bhagin.vaanee.authorisation.AttributeBeanSetter.fngetSessionAttributeBean
> (AttributeBeanSetter.java:42)
> 	at org.apache.jsp.authorize_jsp._jspService
> (authorize_jsp.java:116)
> 	at org.apache.jasper.runtime.HttpJspBase.service(
> HttpJspBase.java:98)
> 	at javax.servlet.http.HttpServlet.service
> (HttpServlet.java:803)
> 	at org.apache.jasper.servlet.JspServletWrapper.service
> (JspServletWrapper.java:331)
> 	at org.apache.jasper.servlet.JspServlet.serviceJspFile
> (JspServlet.java:329)
> 	at org.apache.jasper.servlet.JspServlet.service
> (JspServlet.java:265)
> 	at javax.servlet.http.HttpServlet.service
> (HttpServlet.java:803)
> 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter
> (ApplicationFilterChain.java:269)
> 	at org.apache.catalina.core.ApplicationFilterChain.doFilter
> (ApplicationFilterChain.java:188)
> 	at org.apache.catalina.core.StandardWrapperValve.invoke
> (StandardWrapperValve.java:213)
> 	at org.apache.catalina.core.StandardContextValve.invoke
> (StandardContextValve.java:174)
> 	at org.apache.catalina.core.StandardHostValve.invoke
> (StandardHostValve.java:127)
> 	at org.apache.catalina.valves.ErrorReportValve.invoke(
> ErrorReportValve.java:117)
> 	at org.apache.catalina.core.StandardEngineValve.invoke
> (StandardEngineValve.java:108)
> 	at org.apache.catalina.connector.CoyoteAdapter.service
> (CoyoteAdapter.java:151)
> 	at org.apache.coyote.http11.Http11Processor.process
> (Http11Processor.java:874)
> 	at
> org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.
> processConnection(Http11BaseProtocol.java:665)
> 	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket
> (PoolTcpEndpoint.java:528)
> 	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt
> (LeaderFollowerWorkerThread.java:81)
> 	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run
> (ThreadPool.java:689)
> 	at java.lang.Thread.run(Thread.java:619)
>
>
> ---------------------------------------------------------------------
> To start a new topic, e-mail: users@tomcat.apache.org
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>   


---------------------------------------------------------------------
To start a new topic, e-mail: users@tomcat.apache.org
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org