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