<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>out of control database connections</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=223135916-21092004><FONT face=Arial
color=#0000ff size=2>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.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=223135916-21092004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=223135916-21092004><FONT face=Arial
color=#0000ff size=2>HTH,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=223135916-21092004><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=223135916-21092004><FONT face=Arial
color=#0000ff size=2>Tim</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Andy Kriger
[mailto:akriger@greaterthanone.com] <BR><B>Sent:</B> Tuesday, September 21, 2004
12:17 PM<BR><B>To:</B> 'The OpenCms mailing list'<BR><B>Subject:</B>
[opencms-dev] out of control database connections <BR></FONT><BR></DIV>
<DIV></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>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 face=Arial size=2>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 face=Arial size=2>Is there a known problem with OpenCms and runaway
connections?</FONT> </P><BR>
<P><FONT face=Arial size=2>===== opencms.properties =====</FONT> </P>
<P><FONT face=Arial size=2># The name of the resource-broker to use</FONT>
<BR><FONT face=Arial size=2>resourcebroker=mysql</FONT> </P>
<P><FONT face=Arial size=2># Parameters for the mySQL resource-broker</FONT>
<BR><FONT face=Arial
size=2>resourcebroker.mysql.class=com.opencms.file.mySql.CmsResourceBroker</FONT>
<BR><FONT face=Arial
size=2>resourcebroker.mysql.pool=jdbc:opencmspool:mysql</FONT> <BR><FONT
face=Arial
size=2>resourcebroker.mysql.online.pool=jdbc:opencmspool:mysqlonline</FONT>
<BR><FONT face=Arial
size=2>resourcebroker.mysql.backup.pool=jdbc:opencmspool:mysqlbackup</FONT>
<BR><FONT face=Arial size=2>resourcebroker.mysql.digest=MD5</FONT> <BR><FONT
face=Arial size=2>resourcebroker.mysql.digest.fileencoding=UTF-8</FONT> </P>
<P><FONT face=Arial size=2># Parameters for the mySQL connection-pool</FONT>
<BR><FONT face=Arial size=2>pool.mysql.driver=org.gjt.mm.mysql.Driver</FONT>
<BR><FONT face=Arial
size=2>pool.mysql.url=jdbc:mysql://localhost:3306/opencms</FONT> <BR><FONT
face=Arial size=2>pool.mysql.user=root</FONT> <BR><FONT face=Arial
size=2>pool.mysql.password=</FONT> <BR><FONT face=Arial
size=2>pool.mysql.minConn=10</FONT> <BR><FONT face=Arial
size=2>pool.mysql.maxConn=20</FONT> <BR><FONT face=Arial
size=2>pool.mysql.increaseRate=5</FONT> <BR><FONT face=Arial
size=2>pool.mysql.timeout=120</FONT> <BR><FONT face=Arial
size=2>pool.mysql.maxage=360</FONT> </P>
<P><FONT face=Arial size=2># Parameters for the mySQL online
connection-pool</FONT> <BR><FONT face=Arial
size=2>pool.mysqlonline.driver=org.gjt.mm.mysql.Driver</FONT> <BR><FONT
face=Arial
size=2>pool.mysqlonline.url=jdbc:mysql://localhost:3306/opencms</FONT> <BR><FONT
face=Arial size=2>pool.mysqlonline.user=root</FONT> <BR><FONT face=Arial
size=2>pool.mysqlonline.password=</FONT> <BR><FONT face=Arial
size=2>pool.mysqlonline.minConn=5</FONT> <BR><FONT face=Arial
size=2>pool.mysqlonline.maxConn=10</FONT> <BR><FONT face=Arial
size=2>pool.mysqlonline.increaseRate=5</FONT> <BR><FONT face=Arial
size=2>pool.mysqlonline.timeout=120</FONT> <BR><FONT face=Arial
size=2>pool.mysqlonline.maxage=360</FONT> </P>
<P><FONT face=Arial size=2># Parameters for the mySQL backup
connection-pool</FONT> <BR><FONT face=Arial
size=2>pool.mysqlbackup.driver=org.gjt.mm.mysql.Driver</FONT> <BR><FONT
face=Arial
size=2>pool.mysqlbackup.url=jdbc:mysql://localhost:3306/opencms</FONT> <BR><FONT
face=Arial size=2>pool.mysqlbackup.user=root</FONT> <BR><FONT face=Arial
size=2>pool.mysqlbackup.password=</FONT> <BR><FONT face=Arial
size=2>pool.mysqlbackup.minConn=5</FONT> <BR><FONT face=Arial
size=2>pool.mysqlbackup.maxConn=10</FONT> <BR><FONT face=Arial
size=2>pool.mysqlbackup.increaseRate=5</FONT> <BR><FONT face=Arial
size=2>pool.mysqlbackup.timeout=120</FONT> <BR><FONT face=Arial
size=2>pool.mysqlbackup.maxage=360</FONT> </P></BODY></HTML>