Page 1 of 1

Problem with loading categories folders

PostPosted:Sat Mar 30, 2013 9:24 am
by 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

Re: Problem with loading categories folders

PostPosted:Sat Mar 30, 2013 9:44 pm
by cvetang
Hi,
I found the problem and fix it.

regards,

Re: Problem with loading categories folders

PostPosted:Sun Mar 31, 2013 8:34 pm
by jllort
Seems a JVM problem, low memory assigned to JVM ? how did you solve it, can be useful to other users.

Re: Problem with loading categories folders

PostPosted:Mon Apr 01, 2013 12:37 pm
by pavila
cvetang wrote:Hi,
I found the problem and fix it.
Please, share your solution because may help to other users.