We're running commons-dbcp-1.4 and commons-pool-1.6. To me, it sounds like we're being impacted by this bug:
https://issues.apache.org/jira/browse/DBCP-379 [DBCP-379] number of connections created has crossed more ...<https://issues.apache.org/jira/browse/DBCP-379> issues.apache.org I found that when the minIdle is configured then during loads, common pool creates more number of connections it will be greater than maxActive. Is it transparent application-wise to jump from these versions to the latests? Or what upgrading path do you suggest we take? Thanks again. Rene Romero Benavides Administrador de Bases de Datos para Command Center +52(55) 11020460 Ext. 6432 | Office +52 1 5545664012 | Mobile www.omnitracs.com/mx<http://www.omnitracs.com/mx> Register today! www.omnitracs.com/outlook<http://www.omnitracs.com/outlook> <https://outlook.office.com/owa/service.svc/s/GetFileAttachment?id=AAMkAGM2NWIyZGFmLWZhMTYtNDUzNC04YzQ5LWEwOTA1Zjk4MTY3ZgBGAAAAAABp9rw%2F5DvqQ5VNu%2FP5FANvBwCC6JFKXcS6RJy5Q76IhGGqAAAAAAEMAACC6JFKXcS6RJy5Q76IhGGqAACGtmA4AAABEgAQANT3RQAH0VJIrveZGngUUTQ%3D&X-OWA-CANARY=zgTt0gEIPEaHc-Q35K2xD7ADDSE3yNIYLGPJUeTkGumastS1fdcpigPbw4ASyo9SSzPAsJtdi6o> ________________________________ From: Phil Steitz <[email protected]> Sent: Tuesday, January 24, 2017 3:43:29 PM To: Commons Users List Subject: [EXTERNAL]Re: DBCP issuing more sessions than maxActive sessions in Oracle What versions of dbcp and pool are you running? Looks like 1.x from the package names. The first thing to look at is the changelogs[1] for releases since the pool and dbcp versions that you are running. Phil [1] for dbcp this is https://commons.apache.org/proper/commons-dbcp/changes-report.html There is a similar page on the pool site. On 1/24/17 3:02 PM, Romero, René wrote: > Hello guys. > > Under what circumstances could we get more than MaxActive sessions in the > database if DBCP is our only means of access to it? > > This is our current configuration and it's surpassing 160 Oracle sessions at > times when it shouldn't go beyond 32 (our current value for MaxActive). > > > DB = Oracle 11g > > Data access via spring famework. > > > Thanks in advance. > > > <bean id="dwDataSource" class="org.apache.commons.dbcp.BasicDataSource" > p:url="${dw.db.url}" p:username="${dw.db.username}" > p:password="${dw.db.password}" > p:driverClassName="${dw.db.driverClassName}" init-method="createDataSource" > destroy-method="close"> > <property name="initialSize" value="${dw.db.initial.connection.size}" /> > <property name="maxActive" value="${dw.db.max.connection.size}" /> > <!-- As part of perf testing, saw a bottleneck in the dw hence commiting > these two params > <property name="testOnBorrow" value="true" /> > <property name="validationQuery" value="${dw.db.validation.query}" /> --> > <property name="minEvictableIdleTimeMillis" value="900000" /> > <property name="minIdle" value="${dw.db.minIdle.connections}" /> > <property name="maxIdle" value="${dw.db.maxIdle.connections}" /> > <property name="timeBetweenEvictionRunsMillis" value="1200000" /> > </bean> > > > dw.db.url=jdbc:oracle:thin:someDB/somePass@someHost:1522:SomeInstance > dw.db.username=someUser > dw.db.password=somePass > dw.db.driverClassName=oracle.jdbc.OracleDriver > dw.db.allowed.operations=select > dw.db.schema=1|COMMON_APP_VIEWS_01, 81|COMMON_APP_VIEWS_81 > dw.db.maxRows=500 > dw.db.type=ORACLE > dw.db.validation.query=select 1 from dual > dw.db.initial.connection.size=4 > dw.db.max.connection.size=32 > dw.db.minIdle.connections=4 > dw.db.maxIdle.connections=4 > > > What other info would you need? > > > Rene Romero Benavides > Administrador de Bases de Datos para Command Center > +52(55) 11020460 Ext. 6432 | Office > > +52 1 5545664012 | Mobile > > www.omnitracs.com/mx<http://www.omnitracs.com/mx<http://www.omnitracs.com/mx<http://www.omnitracs.com/mx>> > > Register today! > www.omnitracs.com/outlook<http://www.omnitracs.com/outlook<http://www.omnitracs.com/outlook<http://www.omnitracs.com/outlook>> > > <https://outlook.office.com/owa/service.svc/s/GetFileAttachment?id=AAMkAGM2NWIyZGFmLWZhMTYtNDUzNC04YzQ5LWEwOTA1Zjk4MTY3ZgBGAAAAAABp9rw%2F5DvqQ5VNu%2FP5FANvBwCC6JFKXcS6RJy5Q76IhGGqAAAAAAEMAACC6JFKXcS6RJy5Q76IhGGqAACGtmA4AAABEgAQANT3RQAH0VJIrveZGngUUTQ%3D&X-OWA-CANARY=zgTt0gEIPEaHc-Q35K2xD7ADDSE3yNIYLGPJUeTkGumastS1fdcpigPbw4ASyo9SSzPAsJtdi6o> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] This message was received from outside of the Omnitracs network
