Problem with loading categories folders

[cvetang]

Hi all,

I am writing about a problem, which I couldn't manage to fix.
Our installation is OpenKM 6.2.1 on CentOS 6 Linux. The system worked properly and start with customizing it.

Our supervisor started to make categories folders, but hadn't uploaded any documents.

Then suddenly a problem occurred after logging the system cannot load the Category folders. The error on the screen is :
Error when communicating with server (GetCategoriesFolder)

On the server error is the following:

Code: Select all

2013-03-30 11:09:38,973 [http-bio-0.0.0.0-8080-exec-4] ERROR org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/OpenKM] - Exception while dispatching incoming RPC call
com.google.gwt.user.server.rpc.UnexpectedException: Service method 'public abstract com.openkm.frontend.client.bean.GWTFolder com.openkm.frontend.client.service.OKMRepositoryService.getCategoriesFolder() throws com.openkm.frontend.client.OKMException' threw an unexpected exception: java.lang.StackOverflowError
.......................
Caused by: java.lang.StackOverflowError
        at org.hsqldb.jdbc.JDBCPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.JDBCConnection.prepareStatement(Unknown Source)
        at org.apache.tomcat.dbcp.dbcp.DelegatingConnection.prepareStatement(DelegatingConnection.java:281)
        at org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.prepareStatement(PoolingDataSource.java:313)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1700)
        at org.hibernate.loader.Loader.doQuery(Loader.java:801)
        at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
        at org.hibernate.loader.Loader.doList(Loader.java:2542)
        at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
        at org.hibernate.loader.Loader.list(Loader.java:2271)
        at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:459)
        at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:365)
        at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
        at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
        at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
        at com.openkm.dao.NodeFolderDAO.hasChilds(NodeFolderDAO.java:344)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:122)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
        at com.openkm.module.db.base.BaseFolderModule.getProperties(BaseFolderModule.java:158)
.............

First I checked the repository. Also I check with manual selecting the OKM_* check the data, check the relations and all looks fine.

Then I made an upgrade to 6.2.2 , but this didn't fix the problem.

After this I delete using sql commands all the category folders, which our supervisor created - no success again.

I backed up the repository and created one new. With the new repository the system works OK.

But to find and fix the problem, because if our system was on production state, it will be impossible to start with new repository.

Regards,
Cvetan

[cvetang]

Hi,
I found the problem and fix it.

regards,

[jllort]

Seems a JVM problem, low memory assigned to JVM ? how did you solve it, can be useful to other users.

[pavila]

Hi,
I found the problem and fix it.

Please, share your solution because may help to other users.