hibernate operation:could not execute query using scroll?

[dynamolalit]

Hi,

I am using alfresco 3.2r on windows 2003 server with Tomcat 6 & jdk 1.6.At odd times, i am getting this strange error on my explorer web client:

A system error happened during the operation: Hibernate operation: could not execute query using scroll; uncategorized SQLException for SQL [select childassoc0_.id as col_0_0_, childassoc0_.type_qname_id as col_1_0_, childassoc0_.qname_ns_id as col_2_0_, childassoc0_.qname_localname as col_3_0_, childassoc0_.qname_crc as col_4_0_, childassoc0_.child_node_name as col_5_0_, childassoc0_.child_node_name_crc as col_6_0_, childassoc0_.is_primary as col_7_0_, childassoc0_.assoc_index as col_8_0_, nodeimpl1_.id as col_9_0_, storeimpl2_.protocol as col_10_0_, storeimpl2_.identifier as col_11_0_, nodeimpl1_.uuid as col_12_0_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.child_node_id=nodeimpl1_.id inner join alf_store storeimpl2_ on nodeimpl1_.store_id=storeimpl2_.id where childassoc0_.parent_node_id=? and (nodeimpl1_.type_qname_id in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) order by childassoc0_.assoc_index, childassoc0_.id]; SQL state [HY000]; error code [3]; Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28); nested exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)

While checking on server console, i can see error as below.

02:53:01,108 ERROR [org.alfresco.web.ui.common.Utils] A system error happened during the operation: Hibernate operation: could not execute query using scroll; uncategorized SQLException for SQL [select childassoc0_.id as col_0_0_, childassoc0_.type_qname_id as col_1_0_, childassoc0_.qname_ns_id as col_2_0_, childassoc0_.qname_localname as col_3_0_, childassoc0_.qname_crc as col_4_0_, childassoc0_.child_node_name as col_5_0_, childassoc0_.child_node_name_crc as col_6_0_, childassoc0_.is_primary as col_7_0_, childassoc0_.assoc_index as col_8_0_, nodeimpl1_.id as col_9_0_, storeimpl2_.protocol as col_10_0_, storeimpl2_.identifier as col_11_0_, nodeimpl1_.uuid as col_12_0_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.child_node_id=nodeimpl1_.id inner join alf_store storeimpl2_ on nodeimpl1_.store_id=storeimpl2_.id where childassoc0_.parent_node_id=? and (nodeimpl1_.type_qname_id in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) order by childassoc0_.assoc_index, childassoc0_.id]; SQL state [HY000]; error code [3]; Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28); nested exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)
org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query using scroll; uncategorized SQLException for SQL [select childassoc0_.id as col_0_0_, childassoc0_.type_qname_id as col_1_0_, childassoc0_.qname_ns_id as col_2_0_, childassoc0_.qname_localname as col_3_0_, childassoc0_.qname_crc as col_4_0_, childassoc0_.child_node_name as col_5_0_, childassoc0_.child_node_name_crc as col_6_0_, childassoc0_.is_primary as col_7_0_, childassoc0_.assoc_index as col_8_0_, nodeimpl1_.id as col_9_0_, storeimpl2_.protocol as col_10_0_, storeimpl2_.identifier as col_11_0_, nodeimpl1_.uuid as col_12_0_ from alf_child_assoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.child_node_id=nodeimpl1_.id inner join alf_store storeimpl2_ on nodeimpl1_.store_id=storeimpl2_.id where childassoc0_.parent_node_id=? and (nodeimpl1_.type_qname_id in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) order by childassoc0_.assoc_index, childassoc0_.id]; SQL state [HY000]; error code [3]; Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28); nested exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)
Caused by: java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)
   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 org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
   at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
   at org.hibernate.loader.Loader.getResultSet(Loader.java:1787)
   at org.hibernate.loader.Loader.scroll(Loader.java:2286)
   at org.hibernate.loader.hql.QueryLoader.scroll(QueryLoader.java:441)
   at org.hibernate.hql.ast.QueryTranslatorImpl.scroll(QueryTranslatorImpl.java:390)
   at org.hibernate.engine.query.HQLQueryPlan.performScroll(HQLQueryPlan.java:245)
   at org.hibernate.impl.SessionImpl.scroll(SessionImpl.java:1206)
   at org.hibernate.impl.QueryImpl.scroll(QueryImpl.java:67)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl$23.doInHibernate(HibernateNodeDaoServiceImpl.java:2745)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:372)
   at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:338)
   at org.alfresco.repo.node.db.hibernate.HibernateNodeDaoServiceImpl.getChildAssocsByChildTypes(HibernateNodeDaoServiceImpl.java:2751)
   at sun.reflect.GeneratedMethodAccessor1051.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.alfresco.repo.transaction.TransactionalDaoInterceptor.invoke(TransactionalDaoInterceptor.java:68)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.domain.hibernate.DirtySessionMethodInterceptor.invoke(DirtySessionMethodInterceptor.java:419)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invokeInternal(SingleEntryTransactionResourceInterceptor.java:163)
   at org.alfresco.repo.transaction.SingleEntryTransactionResourceInterceptor.invoke(SingleEntryTransactionResourceInterceptor.java:138)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy9.getChildAssocsByChildTypes(Unknown Source)
   at org.alfresco.repo.node.db.DbNodeServiceImpl.getChildAssocs(DbNodeServiceImpl.java:1814)
   at sun.reflect.GeneratedMethodAccessor389.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.alfresco.repo.tenant.MultiTNodeServiceInterceptor.invoke(MultiTNodeServiceInterceptor.java:110)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy11.getChildAssocs(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor389.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.service.StoreRedirectorProxyFactory$RedirectorInvocationHandler.invoke(StoreRedirectorProxyFactory.java:221)
   at $Proxy12.getChildAssocs(Unknown Source)
   at sun.reflect.GeneratedMethodAccessor389.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.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.MLPropertyInterceptor.invoke(MLPropertyInterceptor.java:309)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:275)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.node.NodeRefPropertyMethodInterceptor.invoke(NodeRefPropertyMethodInterceptor.java:275)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy11.getChildAssocs(Unknown Source)
   at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.listSimple(FileFolderServiceImpl.java:509)
   at org.alfresco.repo.model.filefolder.FileFolderServiceImpl.list(FileFolderServiceImpl.java:295)
   at sun.reflect.GeneratedMethodAccessor1071.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.alfresco.repo.model.filefolder.TempFileMarkerInterceptor.invoke(TempFileMarkerInterceptor.java:83)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.model.ml.MLContentInterceptor.invoke(MLContentInterceptor.java:131)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.model.filefolder.MLTranslationInterceptor.invoke(MLTranslationInterceptor.java:211)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at net.sf.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:80)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.security.permissions.impl.ExceptionTranslatorMethodInterceptor.invoke(ExceptionTranslatorMethodInterceptor.java:49)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.alfresco.repo.audit.AuditMethodInterceptor.proceedWithAudit(AuditMethodInterceptor.java:238)
   at org.alfresco.repo.audit.AuditMethodInterceptor.proceed(AuditMethodInterceptor.java:205)
   at org.alfresco.repo.audit.AuditMethodInterceptor.invoke(AuditMethodInterceptor.java:153)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy68.list(Unknown Source)
   at org.alfresco.web.bean.BrowseBean.queryBrowseNodes(BrowseBean.java:905)
   at org.alfresco.web.bean.BrowseBean.getNodes(BrowseBean.java:511)
   at sun.reflect.GeneratedMethodAccessor1070.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.apache.myfaces.el.PropertyResolverImpl.getProperty(PropertyResolverImpl.java:457)
   at org.apache.myfaces.el.PropertyResolverImpl.getValue(PropertyResolverImpl.java:85)
   at org.apache.myfaces.el.ELParserHelper$MyPropertySuffix.evaluate(ELParserHelper.java:535)
   at org.apache.commons.el.ComplexValue.evaluate(ComplexValue.java:145)
   at org.apache.myfaces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:386)
   at org.alfresco.web.ui.common.component.data.UIRichList.getValue(UIRichList.java:157)
   at org.alfresco.web.ui.common.component.data.UIRichList.getDataModel(UIRichList.java:518)
   at org.alfresco.web.ui.common.component.data.UIRichList.bind(UIRichList.java:454)
   at org.alfresco.web.ui.common.renderer.data.RichListRenderer.encodeChildren(RichListRenderer.java:83)
   at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:527)
   at javax.faces.webapp.UIComponentTag.encodeChildren(UIComponentTag.java:483)
   at javax.faces.webapp.UIComponentTag.doEndTag(UIComponentTag.java:364)
   at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005frichList_005f0(browse_jsp.java:2697)
   at org.apache.jsp.jsp.browse.browse_jsp._jspx_meth_a_005fpanel_005f5(browse_jsp.java:2585)
   at org.apache.jsp.jsp.browse.browse_jsp._jspService(browse_jsp.java:849)
   at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
   at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
   at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
   at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
   at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
   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 org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630)
   at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436)
   at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374)
   at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302)
   at org.apache.myfaces.context.servlet.ServletExternalContextImpl.dispatch(ServletExternalContextImpl.java:419)
   at org.apache.myfaces.application.jsp.JspViewHandlerImpl.renderView(JspViewHandlerImpl.java:211)
   at org.apache.myfaces.lifecycle.RenderResponseExecutor.execute(RenderResponseExecutor.java:41)
   at org.apache.myfaces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:132)
   at javax.faces.webapp.FacesServlet.service(FacesServlet.java:140)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at com.keembay.alfresco.web.app.servlet.CASAuthenticationFilter.doFilter(CASAuthenticationFilter.java:149)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at org.alfresco.repo.web.filter.beans.NullFilter.doFilter(NullFilter.java:74)
   at sun.reflect.GeneratedMethodAccessor720.invoke(Unknown Source)
   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
   at java.lang.reflect.Method.invoke(Method.java:597)
   at org.alfresco.repo.management.subsystems.ChainingSubsystemProxyFactory$1.invoke(ChainingSubsystemProxyFactory.java:122)
   at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
   at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
   at $Proxy220.doFilter(Unknown Source)
   at org.alfresco.repo.web.filter.beans.BeanProxyFilter.doFilter(BeanProxyFilter.java:88)
   at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
   at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
   at edu.yale.its.tp.cas.client.filter.CASFilter.doFilter(CASFilter.java:317)
   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:128)
   at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
   at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
   at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
   at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
   at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
   at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
   at java.lang.Thread.run(Thread.java:619)
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Can anybody help!

[mrogers]

exception is java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)
Caused by: java.sql.SQLException: Error writing file 'C:\WINDOWS\TEMP\MY9546.tmp' (Errcode: 28)

Has your temp folder run out of space?

[dynamolalit]

Hi Mrogers,

Thanks for your reply.'C:\WINDOWS\TEMP' folder occupies only 60 MB but my C drive is almost full leaving only ~40 MB free out of ~50 GB of space.

Can this be an issue?

[mrogers]

Yes that will be an issue for lots of software, including windows, mysql and alfresco.

The "rule of thumb" I use is to keep 10 to 20% of disk free.