<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
from time to time I'm facing similar issues. From my investigations I
could not find any traces linked to the error directly, but I found
problems with db pooling timeouts:<br>
<br>
17 Nov 2008 18:53:57,397 ERROR [org.opencms.main.CmsThreadStore: 190]
Failed to write locks to database. <br>
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing
the following query: . <br>
at
org.opencms.db.generic.CmsProjectDriver.writeLocks(CmsProjectDriver.java:2179)<br>
at
org.opencms.lock.CmsLockManager.writeLocks(CmsLockManager.java:579)<br>
at
org.opencms.db.CmsDriverManager.writeLocks(CmsDriverManager.java:7993)<br>
at
org.opencms.db.CmsSecurityManager.writeLocks(CmsSecurityManager.java:5129)<br>
at org.opencms.main.CmsThreadStore.run(CmsThreadStore.java:187)<br>
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a
connection, pool error: Timeout waiting for idle object<br>
at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)<br>
at java.sql.DriverManager.getConnection(DriverManager.java:525)<br>
at java.sql.DriverManager.getConnection(DriverManager.java:193)<br>
at
org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)<br>
at
org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)<br>
at
org.opencms.db.generic.CmsProjectDriver.writeLocks(CmsProjectDriver.java:2139)<br>
... 4 more<br>
Caused by: java.util.NoSuchElementException: Timeout waiting for idle
object<br>
at
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)<br>
at
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)<br>
... 9 more<br>
<br>
<br>
There are different exceptions popping up but they are alwasy caused by
an exception in the connection pool. As there is just low traffic on my
system and these issues occurrences are to be measured in weeks or
months I did not further investigate them. <br>
<br>
<br>
I'm running:<br>
OpeCMS: 7.0.4<br>
Fedora 8 x64 (2.6.25.14-69.tc8)<br>
Tomcat: 2.2.26.0<br>
MySql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using
readline 5.0<br>
Java: Sun 64-Bit Server VM (build 1.5.0_15-b04, mixed mode)<br>
<br>
<br>
chan fook mun wrote:
<blockquote cite="mid659981.40359.qm@web76209.mail.sg1.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td
style="font-family: inherit; font-style: inherit; font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit;"
valign="top">
<div>Hi Everyone,</div>
<div> </div>
<div>I have a problem on Opencms. I installed Opencms 7.0.5 on
the Sun solaris server and let it run for a reasonable period of time
say 2 months. When I try to hit the Opencms URL of the application
website today, the Http 500 internal server error is viewed on the
browser. However I have not touched the code on the server once it is
added 2 months ago. Will appreciate those who encounter this before and
share their experience on how to go about solving it. Thank you.</div>
</td>
</tr>
</tbody>
</table>
<br>
<hr size="1"> <a
href="http://sg.rd.yahoo.com/sg/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/sg/">
New Email names for you! </a> <br>
Get the Email name you've always wanted on the new @ymail and
@rocketmail.<br>
Hurry before someone else does!
<pre wrap="">
<hr size="4" width="90%">
_______________________________________________
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
<a class="moz-txt-link-freetext" href="http://lists.opencms.org/mailman/listinfo/opencms-dev">http://lists.opencms.org/mailman/listinfo/opencms-dev</a></pre>
</blockquote>
<br>
</body>
</html>