Hi Phil Steitz, Thank you. I am sorry about this, I am new to this. I will post it in the mentioned list.
And, In the thread dump (jstack) there are no ACTIVE threads, all are BLOCKED or in IN_NATIVE and all threads that are BLOCKED are waiting for connection as below. Regards, Arun Karthik Ravishankar -----Original Message----- From: Phil Steitz [mailto:[email protected]] Sent: Thursday, March 05, 2009 4:05 PM To: [email protected] Subject: Re: GenericObjectPool.borrowObject() hangs Hi Arun, You should post questions like this to the commons user list (http://commons.apache.org/mail-lists.html). Put [dbcp] at the beginning of the subject line so people know what component the question is about. The issues list is for automated notifications from the bug tracking and source repository systems. Please also include information on how you have dbcp configured. Finally, when posting info from thread dumps, look through the entire dump to see if there is a thread that is active. In the case below, you should look for a thread that is waiting on response from the database. Phil Arun Karthik wrote: > Hi, > > Occasionally when the DB is taken down for maintenance my server hangs with > jmap similar to below: > I am not able to reproduce the same when I try to unplug the DB machine's > network cable or any other way I could think ok. > Could someone please guide me as to what the problem may be. > > I am using > > 1. commons-dbcp-1.2.1 > > 2. quartz scheduler > > 3. commons-pool-1.2 > > 4. oracle DB with thin client > > 5. ojdbc14.jar > > Thread 19804: (state = BLOCKED) > - java.lang.Object.wait(long) @bci=0 (Compiled frame; information may be > imprecise) > - java.lang.Object.wait() @bci=2, line=485 (Interpreted frame) > - org.apache.commons.pool.impl.GenericObjectPool.borrowObject() @bci=121, > line=748 (Interpreted frame) > - org.apache.commons.dbcp.PoolingDataSource.getConnection() @bci=4, line=95 > (Interpreted frame) > - org.apache.commons.dbcp.BasicDataSource.getConnection() @bci=4, line=540 > (Interpreted frame) > - org.quartz.utils.PoolingConnectionProvider.getConnection() @bci=4, > line=197 (Interpreted frame) > - org.quartz.utils.DBConnectionManager.getConnection(java.lang.String) > @bci=49, line=112 (Interpreted frame) > - com.abcd.jobs.utils.ABCDJobSchedulerUtil.getDBConnection() @bci=6, > line=291 (Interpreted frame) > - > com.abcd.jobs.utils.ABCDJobSchedulerUtil.getJobs(javax.servlet.http.HttpServletRequest) > @bci=35, line=306 (Interpreted frame) > - org.apache.jsp.jobs_jsp._jspService(javax.servlet.http.HttpServletRequest, > javax.servlet.http.HttpServletResponse) @bci=121, line=110 (Interpreted frame) > - > org.apache.jasper.runtime.HttpJspBase.service(javax.servlet.http.HttpServletRequest, > javax.servlet.http.HttpServletResponse) @bci=3, line=70 (Interpreted frame) > - javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest, > javax.servlet.ServletResponse) @bci=30, line=803 (Interpreted frame) > - > org.apache.jasper.servlet.JspServletWrapper.service(javax.servlet.http.HttpServletRequest, > javax.servlet.http.HttpServletResponse, boolean) @bci=395, line=393 > (Interpreted frame) > - > org.apache.jasper.servlet.JspServlet.serviceJspFile(javax.servlet.http.HttpServletRequest, > javax.servlet.http.HttpServletResponse, java.lang.String, > java.lang.Throwable, boolean) @bci=134, line=320 (Interpreted frame) > - > org.apache.jasper.servlet.JspServlet.service(javax.servlet.http.HttpServletRequest, > javax.servlet.http.HttpServletResponse) @bci=436, line=266 (Interpreted > frame) > - javax.servlet.http.HttpServlet.service(javax.servlet.ServletRequest, > javax.servlet.ServletResponse) @bci=30, line=803 (Interpreted frame) > - > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(javax.servlet.ServletRequest, > javax.servlet.ServletResponse) @bci=374, line=290 (Interpreted frame) > - > org.apache.catalina.core.ApplicationFilterChain.doFilter(javax.servlet.ServletRequest, > javax.servlet.ServletResponse) @bci=101, line=206 (Interpreted frame) > - > com.abcd.jobs.filters.SessionCheckFilter.doFilter(javax.servlet.ServletRequest, > javax.servlet.ServletResponse, javax.servlet.FilterChain) @bci=179, line=87 > (Interpreted frame) > - > org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(javax.servlet.ServletRequest, > javax.servlet.ServletResponse) @bci=117, line=235 (Interpreted frame) > - > org.apache.catalina.core.ApplicationFilterChain.doFilter(javax.servlet.ServletRequest, > javax.servlet.ServletResponse) @bci=101, line=206 (Interpreted frame) > - > org.apache.catalina.core.StandardWrapperValve.invoke(org.apache.catalina.connector.Request, > org.apache.catalina.connector.Response) @bci=804, line=233 (Interpreted > frame) > - > org.apache.catalina.core.StandardContextValve.invoke(org.apache.catalina.connector.Request, > org.apache.catalina.connector.Response) @bci=285, line=175 (Interpreted > frame) > - > org.apache.catalina.core.StandardHostValve.invoke(org.apache.catalina.connector.Request, > org.apache.catalina.connector.Response) @bci=64, line=128 (Interpreted frame) > - > org.apache.catalina.valves.ErrorReportValve.invoke(org.apache.catalina.connector.Request, > org.apache.catalina.connector.Response) @bci=6, line=102 (Interpreted frame) > - > org.apache.catalina.core.StandardEngineValve.invoke(org.apache.catalina.connector.Request, > org.apache.catalina.connector.Response) @bci=42, line=109 (Interpreted frame) > - > org.apache.catalina.connector.CoyoteAdapter.service(org.apache.coyote.Request, > org.apache.coyote.Response) @bci=157, line=263 (Interpreted frame) > - org.apache.coyote.http11.Http11Processor.process(java.net.Socket) > @bci=432, line=844 (Interpreted frame) > - > org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(java.net.Socket) > @bci=82, line=584 (Interpreted frame) > - org.apache.tomcat.util.net.JIoEndpoint$Worker.run() @bci=41, line=447 > (Interpreted frame) > - java.lang.Thread.run() @bci=11, line=619 (Interpreted frame) > > Regards, > Arun > > >
