Mailing-List: contact user-help@commons.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Commons Users List" <user@commons.apache.org>
Received-SPF: pass (athena.apache.org: domain of phil.steitz@gmail.com
 designates 209.85.210.47 as permitted sender)
Message-ID: <4E4461CE.2050401@gmail.com>
Date: Thu, 11 Aug 2011 16:12:14 -0700
From: Phil Steitz <phil.steitz@gmail.com>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
 rv:5.0) Gecko/20110624 Thunderbird/5.0
MIME-Version: 1.0
To: Commons Users List <user@commons.apache.org>
Subject: Re: [dbcp] pool exhuasted
References: 
 <673C09F7CF4F6948B6DE09EC310E67409A5A973A86@NA-MAIL-1-3.rws.ad.ea.com>
 <673C09F7CF4F6948B6DE09EC310E67409A5A973DB1@NA-MAIL-1-3.rws.ad.ea.com>
In-Reply-To: 
 <673C09F7CF4F6948B6DE09EC310E67409A5A973DB1@NA-MAIL-1-3.rws.ad.ea.com>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

On 8/11/11 4:00 PM, Ji, Jason wrote:
> Hi Guys,
> I see this exceptions in our production :
>
>
> Caused by: java.sql.SQLException: Cannot get a connection, pool error: Pool exhausted
>         at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:188)
>         at java.sql.DriverManager.getConnection(DriverManager.java:582)
>         at java.sql.DriverManager.getConnection(DriverManager.java:207)
>
> we use mysql and we set the maxconnections to 100
>  when the problem happens , we  checked the db connection from mysql  by running this :
> mysql> show full processlist;
> and  we only see 4 connections on mysql .
>
> so apparently there is no connection leak , since the there are only 4 connecitons on mysql and our maxiConnections size is 100.
>
> Restarting the app fixed the problem ,and during the problem happens ,the traffic didn't peak .
>
> Does anyone happen to run into the same situation ?  or any suggestions ?
> Is there any known bug that similar to this , say the counter is miscounted or something else ?
> We use version 1.4 .

Are you sure your application is closing all of the connections that
it borrows from the pool?  Most likely, your application actually is
leaking connections; but the physical connections are being closed
on the server side.

Phil
>
>
> Thanks,
> Jason
>
>
>
>
>


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@commons.apache.org
For additional commands, e-mail: user-help@commons.apache.org