Errors on opening submenus

Bug and problem reporting

Moderators: hugo, alexandre, rmvanarkel

Post Reply
vitalizar
Posts: 11
Joined: Tue Jan 18, 2011 8:10 am
Location: Sofia, Bulgaria
Contact:

Errors on opening submenus

Post by vitalizar »

When I'm trying to open submenus I get errors:

nl.strohalm.cyclos.dao.exceptions.DaoException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select memberacco0_.id as id85_0_, accounttyp1_.id as id84_1_, memberacco0_.creation_date as creation3_85_0_, memberacco0_.owner_name as owner4_85_0_, memberacco0_.type_id as type5_85_0_, memberacco0_.credit_limit as credit6_85_0_, memberacco0_.upper_credit_limit as upper7_85_0_, memberacco0_.member_id as member8_85_0_, memberacco0_.member_status as member9_85_0_, accounttyp1_.name as name84_1_, accounttyp1_.currency_id as currency4_84_1_, accounttyp1_.description as descript5_84_1_, accounttyp1_.system_account_id as system6_84_1_, accounttyp1_.subclass as subclass84_1_ from accounts memberacco0_ left outer join account_types accounttyp1_ on memberacco0_.type_id=accounttyp1_.id where memberacco0_.subclass='M' and 1=1 and memberacco0_.member_id=? order by accounttyp1_.name]; SQL state [HY000]; error code [1030]; Got error 28 from storage engine; nested exception is java.sql.SQLException: Got error 28 from storage engine
at nl.strohalm.cyclos.dao.BaseDAOImpl.list(BaseDAOImpl.java:385)
at nl.strohalm.cyclos.dao.BaseDAOImpl.list(BaseDAOImpl.java:367)
at nl.strohalm.cyclos.dao.accounts.AccountDAOImpl.search(AccountDAOImpl.java:158)
at nl.strohalm.cyclos.services.accounts.AccountServiceImpl.getAccounts(AccountServiceImpl.java:262)
at sun.reflect.GeneratedMethodAccessor1681.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:304)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:77)
at nl.strohalm.cyclos.aop.TraceAspect.doTrace(TraceAspect.java:175)
at nl.strohalm.cyclos.aop.TraceAspect.trace(TraceAspect.java:93)
at sun.reflect.GeneratedMethodAccessor67.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:597)
at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:583)
at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:60)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:160)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
at $Proxy20.getAccounts(Unknown Source)
at nl.strohalm.cyclos.controls.accounts.details.AccountOverviewAction.resolveAccounts(AccountOverviewAction.java:159)
at nl.strohalm.cyclos.controls.accounts.details.AccountOverviewAction.executeAction(AccountOverviewAction.java:120)
at nl.strohalm.cyclos.controls.BaseAction.execute(BaseAction.java:153)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at nl.strohalm.cyclos.struts.CyclosRequestProcessor.processActionPerform(CyclosRequestProcessor.java:153)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at nl.strohalm.cyclos.http.TransactionFilter.runInTransaction(TransactionFilter.java:171)
at nl.strohalm.cyclos.http.TransactionFilter.access$000(TransactionFilter.java:52)
at nl.strohalm.cyclos.http.TransactionFilter$1.doInTransaction(TransactionFilter.java:135)
at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:127)
at nl.strohalm.cyclos.http.TransactionFilter.execute(TransactionFilter.java:133)
at nl.strohalm.cyclos.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at nl.strohalm.cyclos.http.EncodingFilter.doFilter(EncodingFilter.java:63)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at nl.strohalm.cyclos.http.LoggedUserFilter.execute(LoggedUserFilter.java:75)
at nl.strohalm.cyclos.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:58)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:555)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:190)
at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:291)
at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:774)
at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:703)
at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:896)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:690)
at java.lang.Thread.run(Thread.java:619)
Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select memberacco0_.id as id85_0_, accounttyp1_.id as id84_1_, memberacco0_.creation_date as creation3_85_0_, memberacco0_.owner_name as owner4_85_0_, memberacco0_.type_id as type5_85_0_, memberacco0_.credit_limit as credit6_85_0_, memberacco0_.upper_credit_limit as upper7_85_0_, memberacco0_.member_id as member8_85_0_, memberacco0_.member_status as member9_85_0_, accounttyp1_.name as name84_1_, accounttyp1_.currency_id as currency4_84_1_, accounttyp1_.description as descript5_84_1_, accounttyp1_.system_account_id as system6_84_1_, accounttyp1_.subclass as subclass84_1_ from accounts memberacco0_ left outer join account_types accounttyp1_ on memberacco0_.type_id=accounttyp1_.id where memberacco0_.subclass='M' and 1=1 and memberacco0_.member_id=? order by accounttyp1_.name]; SQL state [HY000]; error code [1030]; Got error 28 from storage engine; nested exception is java.sql.SQLException: Got error 28 from storage engine
at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:120)
at org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:424)
at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:410)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:377)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)
at nl.strohalm.cyclos.utils.hibernate.HibernateQueryHandler.simpleList(HibernateQueryHandler.java:491)
at nl.strohalm.cyclos.utils.hibernate.HibernateQueryHandler.list(HibernateQueryHandler.java:415)
at nl.strohalm.cyclos.utils.hibernate.HibernateQueryHandler.executeQuery(HibernateQueryHandler.java:188)
at nl.strohalm.cyclos.dao.BaseDAOImpl.list(BaseDAOImpl.java:381)
... 64 more
Caused by: java.sql.SQLException: Got error 28 from storage engine
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1761)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1912)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1812)
at org.hibernate.loader.Loader.doQuery(Loader.java:697)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.doList(Loader.java:2232)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
at org.hibernate.loader.Loader.list(Loader.java:2124)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
at nl.strohalm.cyclos.utils.hibernate.HibernateQueryHandler$4.doInHibernate(HibernateQueryHandler.java:501)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
... 69 more

- It's something new. The Cyclos was stable before.
- Cyclos package is basic
- Version of Cyclos 3.5.6

Other info:
Tomcat Version - Apache Tomcat/6.0.29
JVM Version - 1.6.0_21-b06
JVM Vendor - Sun Microsystems Inc.
OS Name - Linux
OS Version - 2.6.18-194.3.1.el5xen
OS Architecture - amd64


Please, help to find the problem.
vitalizar
Posts: 11
Joined: Tue Jan 18, 2011 8:10 am
Location: Sofia, Bulgaria
Contact:

Disk

Post by vitalizar »

The cause was disk. It was full. Obviously that without cleaning policy it was matter of time to happen :-)
hugo
Posts: 633
Joined: Sun Jun 18, 2006 1:40 pm

Post by hugo »

Hi,

We had no time to look at this yet.
Thanks for letting us know that it was a problem with the disk.
Post Reply