[opencms-dev] OpenCms Freezing

[Arash Kaffamanesh]

Guilherme,

Note sure, but lets try:

I had a similar problem after switching to a production system behind
the firewall (with MySQL),
I guess: your firewall cuts the connection after a certain time (idle
time) of inactivity (?)
If yes --> ask your firewall man :-)

Or write a wget cron which talks to your server every 1 hour, so that
your connection doesn't get killed anymore!

Or play with this settings:

pool.oracleOci.timeout=120
pool.oracleOci.maxage=360

HTH,

Best Regards,
Arash

--
http://www.pomegranate.de/en




-----Original Message-----
From: opencms-dev-bounces at opencms.org
[mailto:opencms-dev-bounces at opencms.org] On Behalf Of OpenCms
Sent: Montag, 2. Januar 2006 19:31
To: The OpenCms mailing list
Subject: [opencms-dev] OpenCms Freezing


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.CmsResourceBro
ker
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,




_______________________________________________
This mail is sent to you from the opencms-dev mailing list
To change your list options, or to unsubscribe from the list, please
visit http://lists.opencms.org/mailman/listinfo/opencms-dev