[opencms-dev] Stop org.opencms.db.CmsDbSqlException

[Brett Sheeran]

Hi,

Recently we lost all access to our OpenCMS site after database access
failed. Can anyone tell me what we could do to stop this occuring
again please? Details as follows.

We are running OpenCMS 7.04 on Tomcat 5.5 and MySQL 14.12. Recently,
our site stopped loading all pages. There were no errors in
opencms.log, but I did find the following error in catalina.out:

Bad response code:500 "Internal Server Error"
(org.opencms.db.CmsDbSqlException: An SQL error occurred when
executing the following query: . ) [65000] [65500] (Time:Jun 21, 2008
09:35:02.778 AM EST, RequestURL:/imps/sites.html, WebAppName:,
SessionID:3D505F77EBFA93955DBA95F212BC1E53,
DeviceName:root^html^mozilla/4, Username:null

It seems OpenCMS and MySQL were still running, but they weren't
talking to each other.

When I ran "show processlist", there did not seem to be any database
activity (besides "show processlist")

mysql> show processlist;
+-----+------+-----------+---------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+---------+---------+------+-------+------------------+
| 378 | root | localhost | opencms | Query | 0 | NULL | show processlist |
+-----+------+-----------+---------+---------+------+-------+------------------+


Whereas, after a restart, there was activity

mysql> show processlist;
+-----+------+-----------------+---------+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------------+---------+---------+------+-------+------------------+
| 378 | root | localhost | opencms | Query | 0 | NULL | show processlist |
| 380 | root | localhost:36489 | opencms | Sleep | 39 | | NULL |
| 381 | root | localhost:36490 | opencms | Sleep | 41 | | NULL |
+-----+------+-----------------+---------+---------+------+-------+------------------+


I have since changed whenExhaustedAction (in opencms.properties) from
"block" to "grow". However, I not sure this will help.

Any suggestions?

Thank you

Regards Brett S