[jira] [Commented] (POOL-107) number of connections created has crossed more than maxActive

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

[jira] [Commented] (POOL-107) number of connections created has crossed more than maxActive

Gilles (Jira)

    [ https://issues.apache.org/jira/browse/POOL-107?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13206526#comment-13206526 ]

Mark Thomas commented on POOL-107:

I've spent some time looking at this and I am struggling to see how the described behavior could occur. The configuration provided looks like a JNDI resource definition from a container environment. You do not say which container or which version. Neither do you say which version of DBCP you are using. Further, there is no configuration that suggests that it isn't the container that is providing the connection pool. Neither is a stack trace provided of the initial errors that occur which would be very enlightening.

Making a whole rash of assumptions (Tomcat is the container, the container provides the pool, latest Tomcat version) then if MySQL is not running, the connection pool will not be created when an attempt is made to obtain a connection. This will continue until the database is started at which point a connection pool will be created. In this scenario, the previous failures will have no effect on the pool that is created.

Without sufficient detail to reproduce this issue, the assumption is going to be that the problem is somewhere (container code, application code) rather then POOL or DBCP.

> number of connections created has crossed more than maxActive
> --------------------------------------------------------------
>                 Key: POOL-107
>                 URL: https://issues.apache.org/jira/browse/POOL-107
>             Project: Commons Pool
>          Issue Type: Bug
>    Affects Versions: 1.3
>         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
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira