Liferay 6.2 + Jackrabbit onOracle DB hanging

thumbnail
Fernando Fernandez, modified 6 Years ago. Expert Posts: 401 Join Date: 8/22/07 Recent Posts
Hi all,
I'm working on a migration from LR CE 6.0 to LR CE 6.2 [no comments, please :-) ]. The DL is configured to work on a Jackrabbit repository configured to work over an Oracle DB. It's working fine.
After migrating to LR6.2 the DL is working mostly OK (some old files missing) but sometimes page loading hangs when using data that comes from the Jackrabbit repository, This happens normally after some hours of operation and usually solves itself after ~5 minutes. For example: the home page has some content and images on it. When this happens, the page is loaded and displayed with all content except anything that comes from the DL. Content images, for example are not shown until many minutes are past.
Since no problems are showing on the logs, I turned up the jackrabbit logging to debug level but everything seems OK - with the delays but with no errors.
Any ideas on how this can be further analysed, to discover the problem?
TIA

Fernando
thumbnail
Alberto Chaparro, modified 6 Years ago. Liferay Master Posts: 560 Join Date: 4/25/11 Recent Posts
Hi Fernando,I don't remember an issue like this and with more information is difficult to point out to an specific element which causes this problem. What I think it can help is to:1- Increase the log level of classes that can be involved.2- When this happens, take 5 thread dumps with an interval of 5-10 seconds between them to  know if the process is stuck in a certain point of the code.I hope it helps.Cheers!
thumbnail
Fernando Fernandez, modified 6 Years ago. Expert Posts: 401 Join Date: 8/22/07 Recent Posts
Hi Alberto,

We decided to try DBStore instead of JCR, since the only reason for this setup was that we wanted the files stored in a DB server. It's a much simpler setup and it even seems faster.

Until now, the issue has not returned.

Thanks

Fernando