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.214.43 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=mime-version:in-reply-to:references:date:message-id:subject:from:to
         :content-type;
        b=gJEq8aVOQLy47rxuiGiL2SmcUUYdXpM27pkoWT9KAPGVOubNpi7r7FR1bwCOyn4ElA
         D8mxFQp61jgZARsb5hhR4ucD4p3kC2ebhdetGgRreHFxvEdi81+q2q4t0FdeuMqXHDnP
         hHklpibojtZ5y0DTgDtTf9C1Ww8UtxVG8SRak=
MIME-Version: 1.0
In-Reply-To: <AANLkTik_S_nxLQpNMMybHu9oJhGwRcZkkrDOB6fhm8yw@mail.gmail.com>
References: <AANLkTincEptBFi8Ab3OpQGu2w-aEoMGL9unSWS8+g6V+@mail.gmail.com>
	<AANLkTik+XiOaypLqYijiRbCaVLvm+DwBezTKTR14EgPa@mail.gmail.com>
	<AANLkTikskW4txWzrEP1H=0t7+8FNRAiAQvR5VD3fnOc0@mail.gmail.com>
	<AANLkTikKFoNiE9K0rHCuhz9iWidKpsLLCgOiciBVkg8+@mail.gmail.com>
	<AANLkTik_S_nxLQpNMMybHu9oJhGwRcZkkrDOB6fhm8yw@mail.gmail.com>
Date: Tue, 25 Jan 2011 20:05:19 -0500
Message-ID: <AANLkTi=+pWckowTyaBWatq5HW1MN6BKGLVdkk3F6PpZp@mail.gmail.com>
Subject: Re: [DBCP] Too many connections issue...
From: Phil Steitz <phil.steitz@gmail.com>
To: Commons Users List <user@commons.apache.org>
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Jan 25, 2011 at 4:39 PM, Suny kk <suny.kk@gmail.com> wrote:
> Hi Phil,
>
> Yes, I'm using BasiDataSource well, Is it because of my DBCP settings?
> Remember I got this exception when I started my application on different
> machine with same database.
>

Well, if the first instance starts and uses the full 500 max
connections, then that could explain why the second instance cannot
get any connections from the database (assuming the database itself
cannot handle more than 500 connections).

As I said below, the error that you are getting means that when the
application starts the database does not have connections available to
provide to the pool.  You should check and confirm:

0) Is the application closing all connections that it opens?  You can
quickly max the pool connections if your code does not return
connections to the pool.  Your configuration allows 500 connections to
be opened by the pool concurrently.  You should observe the actual
database engine connection counts and see if your app is getting near
the max.  Given that you have maxIdle set at 8, if you are hitting
high connection count numbers either you have some very long-running
queries and large load spikes, or your code is abandoning connections
(not closing them).

1) Are other applications or processes consuming available database connections?

Phil

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