[opencms-dev] Repeated (daily) crashes of OpenCms 7.0.5

[a.westermann at alkacon.com]

Hi Nick,

I just read short over this mail and a bell rang. Regarding your 404 
recursion I guess what happens is:

- A resource is tried to be read. Most likely "/". Some problem occurs: 
eg. permissions disallow this.
- 404 page is executed. That very page reads properties (e.g. the 
template properties) of the resource that is currently requested. But...
- whoops: that page cannot be read. So the 404 page is triggered and we 
have the loop.

Solution: Remove any call in /system/handler/handld404.html that causes 
a lookup to the current requested resource. For a short try you could 
just write "hello world!" to that file. On a test system.


Kind Regards,
Achim.
 
-------------------
Achim Westermann
 
Alkacon Software GmbH  - The OpenCms Experts                    
http://www.alkacon.com - http://www.opencms.org    


Nick Straguzzi wrote:
> Hi everyone,
>
> I just wanted to say thank you very much to everyone on the OpenCms list for your help in solving this problem.  It appears the crashes we experienced were indeed caused by stale threads to MySQL.  Following Marc Johnen's advice (setting db.pool.default.whenExhaustedAction to "grow" instead of "block) and Tim Howland's (uncommenting the db.pool.default.testQuery statement) seems to have fixed the problem, at least for now.
>
> Along the way I and our IT folks were able to make a couple of useful tuning improvements, and the system has been running smoothly for several days.  I've used OpenCms for years, but I had never run into this problem before.
>
> I am still a bit leery about the 404 recursion/stack overflow.  I'm not entirely convinced yet that the problem has been solved.  It might well be that the system simply wasn't able to get to the 404 Handler JSP because all of the DB connections were stale, and a 404 on a request to a 404 Handler is never a good thing. ;)  Still, the problem occurred on JPG files and other static resources that shouldn't have triggered a 404 handler at all, I think.  But, I spent so much time last week on the crashing problem that I simply don't have the bandwidth now to dive any deeper into it.
>
> Again, my thanks - our entire organization very much appreciates it.
>
> Regards,
> Nick Straguzzi
>
> _______________________________________________
> 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
>