Problema con pool de conexiones DBCP (en OpenCMS)
Publicado por chema (1 intervención) el 13/01/2009 15:37:56
Tengo un problema con el pool de conexiones DBCP (en OpenCMS)
Tengo instalado Opencms 7.0.3 + JBoss 4 en Ubuntu 7 server y la BBDD es Oracle 9.
He estressado OpenCMS hasta que sale este error, pasa lo mismo cuando se conectan muchos usuarios, no libera las conexiones incluso aunque ya no lleguen mas peticiones, al final se cuelga JBoss.
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: .
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1897)
at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6323)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5730)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:3953)
... 34 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error: Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)
at org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1880)
... 37 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
... 42 more
15:22:54,754 WARN [CmsDriverManager] An SQL error occurred when executing the following query: .
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: .
La configuracion del opencms.properties es :
db.pool.default.maxActive=100
db.pool.default.maxWait=2000
db.pool.default.minIdle=3
db.pool.default.maxIdle=10
db.pool.default.whenExhaustedAction=grow
db.pool.default.testOnBorrow=false
db.pool.default.testWhileIdle=true
db.pool.default.timeBetweenEvictionRuns=3600000
db.pool.default.numTestsPerEvictionRun=3
db.pool.default.minEvictableIdleTime=1800000
Gracias.
Tengo instalado Opencms 7.0.3 + JBoss 4 en Ubuntu 7 server y la BBDD es Oracle 9.
He estressado OpenCMS hasta que sale este error, pasa lo mismo cuando se conectan muchos usuarios, no libera las conexiones incluso aunque ya no lleguen mas peticiones, al final se cuelga JBoss.
Caused by: org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: .
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1897)
at org.opencms.db.CmsDriverManager.readResource(CmsDriverManager.java:6323)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:5730)
at org.opencms.db.CmsSecurityManager.readResource(CmsSecurityManager.java:3953)
... 34 more
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool error: Timeout waiting for idle object
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:193)
at org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)
at org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)
at org.opencms.db.generic.CmsVfsDriver.readResource(CmsVfsDriver.java:1880)
... 37 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
at org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
... 42 more
15:22:54,754 WARN [CmsDriverManager] An SQL error occurred when executing the following query: .
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing the following query: .
La configuracion del opencms.properties es :
db.pool.default.maxActive=100
db.pool.default.maxWait=2000
db.pool.default.minIdle=3
db.pool.default.maxIdle=10
db.pool.default.whenExhaustedAction=grow
db.pool.default.testOnBorrow=false
db.pool.default.testWhileIdle=true
db.pool.default.timeBetweenEvictionRuns=3600000
db.pool.default.numTestsPerEvictionRun=3
db.pool.default.minEvictableIdleTime=1800000
Gracias.
Valora esta pregunta


0