[opencms-dev] OpenCms Freezing

[OpenCms]

Hi

We have OpenCms 5.0.1 running under the following environment:
Java 2 SDK 1.4.2
Tomcat 5.0.28
Oracle 9i (9.2.0.1)
Apache HTTP Server 2.0.50

Every thing seems to be ok till OpenCms stop responding with no error
messages. Tomcat still running but the OpenCms Servlet freezes. During the
development this behavior hepened every 2 or 3 days but since OpenCms went
into production the sistem freezes 3 or 4 times a day. I turned the logs
on and find this.

------------------- Strat -------------------

[26.12.2005 17:55:41] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: checking for outtimed connections
[26.12.2005 17:55:41] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: closing one outtimed connection
[26.12.2005 17:55:41] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: closing one outtimed connection
[26.12.2005 17:55:41] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: closing one outtimed connection
[26.12.2005 17:55:41] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: closing one outtimed connection
[26.12.2005 17:55:41] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: connection is to old, destroy it.
[26.12.2005 17:55:41] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: connection was broken
[26.12.2005 17:55:41] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: creating new connection. Current Amount is:10
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: connection is to old, destroy it.
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: connection was broken
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: creating new connection. Current Amount is:10
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcionline: connection is to old, destroy it.
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcionline: connection was broken
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcionline: checking for outtimed connections
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcionline: creating new connection. Current Amount is:9
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcionline: closing one outtimed connection
[26.12.2005 17:55:42] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcionline: closing one outtimed connection
[26.12.2005 17:55:45] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: connection is to old, destroy it.
[26.12.2005 17:55:45] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: connection was broken
[26.12.2005 17:55:45] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOci: creating new connection. Current Amount is:10
[26.12.2005 17:58:32] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcibackup: checking for outtimed connections
[26.12.2005 17:58:32] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcibackup: closing one outtimed connection
[26.12.2005 17:58:32] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcibackup: closing one outtimed connection
[26.12.2005 17:58:32] <opencms_pool> [com.opencms.dbpool.CmsPool]
oracleOcibackup: creating new connection. Current Amount is:3

------------------- End -------------------

Follows the connection pool configuration.

------------------- Strat -------------------
# Parameters for the oracleOci resource-broker to fill the defaults
resourcebroker.oracleOci.class=com.opencms.file.oraclesql.CmsResourceBroker
resourcebroker.oracleOci.pool=jdbc:opencmspool:oracleOci
resourcebroker.oracleOci.online.pool=jdbc:opencmspool:oracleOcionline
resourcebroker.oracleOci.backup.pool=jdbc:opencmspool:oracleOcibackup
resourcebroker.oracleOci.digest=MD5
resourcebroker.oracleOci.digest.fileencoding=UTF-8

# Parameters for the oracle connection-pool
pool.oracleOci.driver=oracle.jdbc.driver.OracleDriver
pool.oracleOci.url=jdbc:oracle:thin:@10.14.124.7:1521:opencms
pool.oracleOci.user=opencms
pool.oracleOci.password=oracle
pool.oracleOci.minConn=10
pool.oracleOci.maxConn=20
pool.oracleOci.increaseRate=5
pool.oracleOci.timeout=120
pool.oracleOci.maxage=360

# Parameters for the oracle online connection-pool
pool.oracleOcionline.driver=oracle.jdbc.driver.OracleDriver
pool.oracleOcionline.url=jdbc:oracle:thin:@10.14.124.7:1521:opencms
pool.oracleOcionline.user=opencms
pool.oracleOcionline.password=oracle
pool.oracleOcionline.minConn=5
pool.oracleOcionline.maxConn=10
pool.oracleOcionline.increaseRate=5
pool.oracleOcionline.timeout=120
pool.oracleOcionline.maxage=360

# Parameters for the oracle backup connection-pool
pool.oracleOcibackup.driver=oracle.jdbc.driver.OracleDriver
pool.oracleOcibackup.url=jdbc:oracle:thin:@10.14.124.7:1521:opencms
pool.oracleOcibackup.user=opencms
pool.oracleOcibackup.password=oracle
pool.oracleOcibackup.minConn=5
pool.oracleOcibackup.maxConn=10
pool.oracleOcibackup.increaseRate=5
pool.oracleOcibackup.timeout=120
pool.oracleOcibackup.maxage=360

------------------- End -------------------

Could this be causing this problem?

Thanks and regards,

Guilherme