Hi all, I have a quite simple setup, a cluster of a couple of instances, Oracle 10 database, Tomcat 6.0.32 under Windows (strange enough), and just the blossom module for a couple of things (without even spring db connection). Occasionally the webapp halts completely. There is nothing strange in the logs, no user can login (the login form just waits forever), and a few pages are displayed partially (while most of pages just waits forever). Partially displayed pages are not in cache. From Tomcat is not possible to stop the webapp in this condition (it just waits forever) and even the shutdown of Tomcat must be forced. I don't know if you ever meet a similar problem, any pointer would be really good.
My idea is that the problem is db-related. I don't use jndi, just the standard OraclePersistenceManager. I checked that "blockOnConnectionLoss" is set to false in all the configuration, but maybe sometimes a connection is returned from the pool in a strange state. The idea came from the fact that no user can login (which could mean that it's impossible to check the db password), and that some of the pages are partially served, maybe the static part or those that are in jackrabbit cache are rendered/served anyway but those that need db connection just blocks. I know that with Jndi pooling there is a possibility to set a few extra properties for Oracle connection caching, like "validateConnection=true;" that will force connection validation, but I don't know if the same is possible with a plain connection string. The meta-problem of this situation is also how to diagnose that the system is in this state (to force a Tomcat restart)... I can't call a page to check (because I'm not sure if the page is some of those partially rendered or a lucky one completely rendered while the rest of the app is dead), and I'm not sure that scheduled job won't simply hang like the rest of the webapp... Regards, Danilo. ---------------------------------------------------------------- For list details, see http://www.magnolia-cms.com/community/mailing-lists.html Alternatively, use our forums: http://forum.magnolia-cms.com/ To unsubscribe, E-mail to: <[email protected]> ----------------------------------------------------------------
