Mailing-List: contact issues-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: issues@commons.apache.org
Received-SPF: pass (athena.apache.org: domain of phil.steitz@gmail.com
 designates 74.125.92.150 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:user-agent:mime-version:to:subject:references
         :in-reply-to:content-type:content-transfer-encoding;
        b=F5qDBAP7ZpuM3Pt9pY2d5c1V5HLQ2OEAAIzMBGwTGWRTFx0xDGc1UzNGvtUZqBgJ+/
         queTL2xjBTsMR8HqrzYR2b8QCetr0Qsk5z4ofwSiM/xPaOW+kCfRWvYHP3f2bV4rXErC
         pWOWKqUkeMDjPU26hpvJBe3U9lyb2LN40F+ac=
Message-ID: <49AFAAC4.9000402@gmail.com>
Date: Thu, 05 Mar 2009 05:34:44 -0500
From: Phil Steitz <phil.steitz@gmail.com>
User-Agent: Thunderbird 2.0.0.19 (Macintosh/20081209)
MIME-Version: 1.0
To: issues@commons.apache.org
Subject: Re: GenericObjectPool.borrowObject() hangs
References: 
 <79FC28A5C5A82A4FA0B5715DD4E58C530EF44740E0@mercury.corp.tfhnet.local>
In-Reply-To: 
 <79FC28A5C5A82A4FA0B5715DD4E58C530EF44740E0@mercury.corp.tfhnet.local>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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
>
>
>