[opencms-dev] Opencms throws http 500 error after running for some time

[Philip Kuegler]

Hi,

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:

17 Nov 2008 18:53:57,397 ERROR [org.opencms.main.CmsThreadStore: 190] 
Failed to write locks to database.
org.opencms.db.CmsDbSqlException: An SQL error occurred when executing 
the following query: .
        at 
org.opencms.db.generic.CmsProjectDriver.writeLocks(CmsProjectDriver.java:2179)
        at 
org.opencms.lock.CmsLockManager.writeLocks(CmsLockManager.java:579)
        at 
org.opencms.db.CmsDriverManager.writeLocks(CmsDriverManager.java:7993)
        at 
org.opencms.db.CmsSecurityManager.writeLocks(CmsSecurityManager.java:5129)
        at org.opencms.main.CmsThreadStore.run(CmsThreadStore.java:187)
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a 
connection, pool error: Timeout waiting for idle object
        at 
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:184)
        at java.sql.DriverManager.getConnection(DriverManager.java:525)
        at java.sql.DriverManager.getConnection(DriverManager.java:193)
        at 
org.opencms.db.CmsSqlManager.getConnectionByUrl(CmsSqlManager.java:104)
        at 
org.opencms.db.generic.CmsSqlManager.getConnection(CmsSqlManager.java:231)
        at 
org.opencms.db.generic.CmsProjectDriver.writeLocks(CmsProjectDriver.java:2139)
        ... 4 more
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
        at 
org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
        at 
org.apache.commons.dbcp.PoolingDriver.connect(PoolingDriver.java:176)
        ... 9 more


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.


I'm running:
OpeCMS: 7.0.4
Fedora 8 x64 (2.6.25.14-69.tc8)
Tomcat: 2.2.26.0
MySql Ver 14.12 Distrib 5.0.45, for redhat-linux-gnu (x86_64) using 
readline 5.0
Java: Sun 64-Bit Server VM (build 1.5.0_15-b04, mixed mode)


chan fook mun wrote:
> Hi Everyone,
>  
> 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.
>
>
> ------------------------------------------------------------------------
> New Email names for you! 
> <http://sg.rd.yahoo.com/sg/mail/domainchoice/mail/signature/*http://mail.promotions.yahoo.com/newdomains/sg/> 
>
> Get the Email name you've always wanted on the new @ymail and @rocketmail.
> Hurry before someone else does!
> ------------------------------------------------------------------------
>
>
> _______________________________________________
> 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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20081222/5d4f93cb/attachment.htm>