Return-Path: Delivered-To: apmail-jakarta-commons-user-archive@www.apache.org Received: (qmail 30721 invoked from network); 3 Dec 2003 18:01:03 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 3 Dec 2003 18:01:03 -0000 Received: (qmail 71074 invoked by uid 500); 3 Dec 2003 18:00:24 -0000 Delivered-To: apmail-jakarta-commons-user-archive@jakarta.apache.org Received: (qmail 71017 invoked by uid 500); 3 Dec 2003 18:00:23 -0000 Mailing-List: contact commons-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "Jakarta Commons Users List" Reply-To: "Jakarta Commons Users List" Delivered-To: mailing list commons-user@jakarta.apache.org Received: (qmail 70946 invoked from network); 3 Dec 2003 18:00:23 -0000 Received: from unknown (HELO astra.telenet-ops.be) (195.130.132.58) by daedalus.apache.org with SMTP; 3 Dec 2003 18:00:23 -0000 Received: from localhost (localhost.localdomain [127.0.0.1]) by astra.telenet-ops.be (Postfix) with SMTP id 14B413806A for ; Wed, 3 Dec 2003 19:00:22 +0100 (MET) Received: from pandora.be (D5E05DC5.kabel.telenet.be [213.224.93.197]) by astra.telenet-ops.be (Postfix) with ESMTP id 6BE9B37F95 for ; Wed, 3 Dec 2003 19:00:21 +0100 (MET) Message-ID: <3FCE24A9.70507@pandora.be> Date: Wed, 03 Dec 2003 19:00:09 +0100 From: Dirk Verbeeck User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Jakarta Commons Users List Subject: Re: [DBCP] Deadlock problem? References: <1070382470.4056.27.camel@munich> <3FCD1B17.4020402@pandora.be> <1070461629.18699.8.camel@munich> In-Reply-To: <1070461629.18699.8.camel@munich> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N 8 connections is the default maxActive You can also use the following page to get the number of active/idle connections from the perspective of the database pool: http://cvs.apache.org/~dirkv/builds/showJNDI.jsp -- Dirk Frank Stolze wrote: > Dirk, > > Thank you for your follow-up. I did restart the server between those > thread dumps. They represent the server being in a "hung" state, at > different instances. > > In terms of database connections, at that point in time I usually see 4 > to 6 connections, all of them in an idle state. The database server > allows 128 connections, and DBCP was at the default setting (8 I > believe?). > > I will generate several dumps when I catch another event like this. > > Regards, > Frank > > > On Tue, 2003-12-02 at 18:07, Dirk Verbeeck wrote: > >>Actually I don't see a deadlock in the stack traces you provided. >>I see two times 2 threads waiting for a connection >> >>In the first dump a getConnection from a in your products.jsp page and >>from CSVGenerator called in DataFileGeneratorServlet. >> >>The second dump again in the CSVGenerator but a different place and also the >>products.jsp page. >> >>You probably did restart the server between the two threaddumps? >>Please make a couple of threaddumps with 30 sec inbetween without restarting. >> >>How did you test the number of available database connections? >> >>-- Dirk >> >>Frank Stolze wrote: >> >> >>>Hi, >>> >>>I have been having some problems with Tomcat + DBCP for some time now. I >>>made every effort to find the problem myself and also look through the >>>mailing list archives, but it seems that I'm at a dead end now. Here is >>>my problem: >>> >>>Tomcat 4.1.27 >>>Commons-Pool 1.1 >>>Commons-DBCP 1.1 >>>PostgreSQL 7.3.3 >>> >>>While everything works beautifully for a while, at some (seemingly) >>>random point in time getting a db connection from the pool fails. >>>Database connections are available, both idle and not yet established. >>> >>>Configuration: >>> >>> >>scope="Shareable" type="javax.sql.DataSource"/> >>> >>> >>> password >>> xxxx >>> >>> >>> url >>> jdbc:postgresql://localhost:5432/bfth_db >>> >>> >>> driverClassName >>> org.postgresql.Driver >>> >>> >>> username >>> xxxx >>> >>> >>> >>>Here are two representative thread dumps: >> >>threaddumps removed >> >> >>>Any advice would be appreciated! >>> >>> >>>Frank >> >> >> >> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org >>For additional commands, e-mail: commons-user-help@jakarta.apache.org >> > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org > For additional commands, e-mail: commons-user-help@jakarta.apache.org > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: commons-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: commons-user-help@jakarta.apache.org