<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7036.0">
<TITLE>out of control database connections </TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">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).</FONT></P>
<P><FONT SIZE=2 FACE="Arial">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. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">Is there a known problem with OpenCms and runaway connections?</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">===== opencms.properties =====</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"># The name of the resource-broker to use</FONT>
<BR><FONT SIZE=2 FACE="Arial">resourcebroker=mysql</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"># Parameters for the mySQL resource-broker</FONT>
<BR><FONT SIZE=2 FACE="Arial">resourcebroker.mysql.class=com.opencms.file.mySql.CmsResourceBroker</FONT>
<BR><FONT SIZE=2 FACE="Arial">resourcebroker.mysql.pool=jdbc:opencmspool:mysql</FONT>
<BR><FONT SIZE=2 FACE="Arial">resourcebroker.mysql.online.pool=jdbc:opencmspool:mysqlonline</FONT>
<BR><FONT SIZE=2 FACE="Arial">resourcebroker.mysql.backup.pool=jdbc:opencmspool:mysqlbackup</FONT>
<BR><FONT SIZE=2 FACE="Arial">resourcebroker.mysql.digest=MD5</FONT>
<BR><FONT SIZE=2 FACE="Arial">resourcebroker.mysql.digest.fileencoding=UTF-8</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"># Parameters for the mySQL connection-pool</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.driver=org.gjt.mm.mysql.Driver</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.url=jdbc:mysql://localhost:3306/opencms</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.user=root</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.password=</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.minConn=10</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.maxConn=20</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.increaseRate=5</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.timeout=120</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysql.maxage=360</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"># Parameters for the mySQL online connection-pool</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.driver=org.gjt.mm.mysql.Driver</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.url=jdbc:mysql://localhost:3306/opencms</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.user=root</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.password=</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.minConn=5</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.maxConn=10</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.increaseRate=5</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.timeout=120</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlonline.maxage=360</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial"># Parameters for the mySQL backup connection-pool</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.driver=org.gjt.mm.mysql.Driver</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.url=jdbc:mysql://localhost:3306/opencms</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.user=root</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.password=</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.minConn=5</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.maxConn=10</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.increaseRate=5</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.timeout=120</FONT>
<BR><FONT SIZE=2 FACE="Arial">pool.mysqlbackup.maxage=360</FONT>
</P>
</BODY>
</HTML>