[opencms-dev] out of control database connections

[Andy Kriger]

I am running OpenCms 5.0.1 with mySql 3.23.58 and Resin 3.0.8 (tho Resin is
not configured to created a db pool with mySql).

With no activity (the admin is not running, the application is not being
accessed), OpenCms keeps adding processes to mySql's processlist (these are
all Sleeping processes that never seem to be removed), taking up more and
more connections to the database (until eventually it runs out). I've
included the opencms.properties config info below. 

Is there a known problem with OpenCms and runaway connections?


===== opencms.properties =====

# The name of the resource-broker to use
resourcebroker=mysql

# Parameters for the mySQL resource-broker
resourcebroker.mysql.class=com.opencms.file.mySql.CmsResourceBroker
resourcebroker.mysql.pool=jdbc:opencmspool:mysql
resourcebroker.mysql.online.pool=jdbc:opencmspool:mysqlonline
resourcebroker.mysql.backup.pool=jdbc:opencmspool:mysqlbackup
resourcebroker.mysql.digest=MD5
resourcebroker.mysql.digest.fileencoding=UTF-8

# Parameters for the mySQL connection-pool
pool.mysql.driver=org.gjt.mm.mysql.Driver
pool.mysql.url=jdbc:mysql://localhost:3306/opencms
pool.mysql.user=root
pool.mysql.password=
pool.mysql.minConn=10
pool.mysql.maxConn=20
pool.mysql.increaseRate=5
pool.mysql.timeout=120
pool.mysql.maxage=360

# Parameters for the mySQL online connection-pool
pool.mysqlonline.driver=org.gjt.mm.mysql.Driver
pool.mysqlonline.url=jdbc:mysql://localhost:3306/opencms
pool.mysqlonline.user=root
pool.mysqlonline.password=
pool.mysqlonline.minConn=5
pool.mysqlonline.maxConn=10
pool.mysqlonline.increaseRate=5
pool.mysqlonline.timeout=120
pool.mysqlonline.maxage=360

# Parameters for the mySQL backup connection-pool
pool.mysqlbackup.driver=org.gjt.mm.mysql.Driver
pool.mysqlbackup.url=jdbc:mysql://localhost:3306/opencms
pool.mysqlbackup.user=root
pool.mysqlbackup.password=
pool.mysqlbackup.minConn=5
pool.mysqlbackup.maxConn=10
pool.mysqlbackup.increaseRate=5
pool.mysqlbackup.timeout=120
pool.mysqlbackup.maxage=360
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20040921/a32a02d2/attachment.htm>