[jira] [Resolved] (DBCP-379) number of connections created has crossed more than maxActive

["Mark Thomas (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DBCP-379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Mark Thomas resolved DBCP-379.
------------------------------

       Resolution: Duplicate
    Fix Version/s: 2.0
                   1.5.1

Based on the analysis of the root cause by Dmytro Savchenko (which I have reviewed and agree with) this is a duplicate of DBCP-342

> number of connections created has crossed more than maxActive 
> --------------------------------------------------------------
>
>                 Key: DBCP-379
>                 URL: https://issues.apache.org/jira/browse/DBCP-379
>             Project: Commons Dbcp
>          Issue Type: Bug
>         Environment: OS:Red Hat Enterprise Linux AS release 4 (Nahant Update 2)
> uname:Linux 2.6.9-22.ELsmp #1 SMP Mon Sep 19 18:32:14 EDT 2005 i686
> vm_info: Java HotSpot(TM) Server VM (1.4.2_13-b06) for
> linux-x86, built
> on Oct 18 2006 09:55:11 by unknown with unknown compiler
>            Reporter: Bhaskar NA
>             Fix For: 1.5.1, 2.0
>
>
> I found that when the minIdle is configured then during loads, common pool creates more number of connections  it will be greater than maxActive.
> When I had following settings:
> maxActive = 50
> maxIdle = 30
> minIdle=30
> factory=org.apache.commons.dbcp.BasicDataSourceFactory
> maxWait=10000
> timeBetweenEvictionRunsMillis=900000
> numTestsPerEvictionRun=50
> minEvictableIdleTimeMillis=1800000
> testWhileIdle=true
> testOnBorrow = true
> validationQuery='select 1 from dual'
> Number of connections in the pool went upto 121. (found thru netstat)
> When I changed minIdle to 15 and did my load test connecitons in the pool went upto 66
> Looks like maxActive is getting bypassed with minIdle.
> When I changed minIdle to 10 and maxActive to 30 and maxIdle to 30 then number of connections went upto 40.
> Can someone please throw light on what is going on here? I am using DBCP 1.2.1 and common pool 1.3.
> Bhaskar



--
This message was sent by Atlassian JIRA
(v6.1.5#6160)