[opencms-dev] out of control database connections

[Tim Howland]

We had success with replacing the bundled mysql jdbc drivers with the
newest ones from the manufacturer, and setting a brief timeout in
my.cnf. If you go this route, you should make sure you use the
validation query.
 
HTH,
 
Tim

  _____  

From: Andy Kriger [mailto:akriger at greaterthanone.com] 
Sent: Tuesday, September 21, 2004 12:17 PM
To: 'The OpenCms mailing list'
Subject: [opencms-dev] out of control database connections 



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/ce09e9bc/attachment.htm>