Reef.ro - Cos cumparaturi

Categorii

Produs Nou

Error

Error	PreparedStatementCallback; uncategorized SQLException for SQL [SELECT * FROM ( select p.products_id, p.es_code, s.specials_new_products_price, s.specials_id, s.status as special_status, s.expires_date, p.products_quantity,products_model, p.products_image, p.products_price,p.products_date_added, p.products_last_modified, p.products_date_available , p.products_weight, p.products_status, p.products_tax_class_id , p.es_product_availability_id, p.es_images, p.es_documents, epa.es_product_availability_displayable, epa.es_product_availability_can_order, epad.es_product_availability_name, epad.es_product_availability_description, p.manufacturers_id, p.products_ordered, pd.language_id ,pd.products_name , pd.products_description , pd.products_url , pd.products_viewed, c.categories_id ,c.categories_image , c.parent_id , c.sort_order , c.categories_status, concat(pd.products_name,pd.products_description) as products_name_description, pd.products_friendly_url from products p left join (specials s) on (p.products_id = s.products_id and (s.expires_date > now() or s.expires_date is null)), categories as c,products_to_categories as pc, products_description as pd, es_product_availability as epa, es_product_availability_description as epad where c.categories_id=pc.categories_id and pc.products_id = p.products_id and p.products_id = pd.products_id and epa.es_product_availability_id=epad.es_product_availability_id and p.es_product_availability_id = epa.es_product_availability_id and pd.language_id=epad.es_language_id order by p.products_id ) s where products_status = ? and language_id = ? and categories_status = ? order by products_date_added desc]; SQL state [HY000]; error code [126]; Incorrect key file for table '/var/tmp/#sql_852_0.MYI'; try to repair it; nested exception is java.sql.SQLException: Incorrect key file for table '/var/tmp/#sql_852_0.MYI'; try to repair it
Error Type	org.springframework.jdbc.UncategorizedSQLException
Stacktrace	org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710) org.springframework.jdbc.core.simple.SimpleJdbcTemplate.query(SimpleJdbcTemplate.java:187) ro.esolutions.generic.dao.impl.GenericReadOnlyDAOImpl$3.create(GenericReadOnlyDAOImpl.java:123) ro.esolutions.generic.dao.impl.GenericReadOnlyDAOImpl$3.create(GenericReadOnlyDAOImpl.java:105) ro.esolutions.util.cache.CacheTemplate.search(CacheTemplate.java:39) ro.esolutions.util.cache.ListCacheTemplate.search(ListCacheTemplate.java:17) ro.esolutions.generic.dao.impl.GenericReadOnlyDAOImpl.listByFilter(GenericReadOnlyDAOImpl.java:105) ro.esolutions.shopportlet.app.impl.ViewsManagerImpl.fillBoxRandomNewProductView(ViewsManagerImpl.java:490) ro.esolutions.shopportlet.struts.catalogRandomNewProduct.CatalogRandomNewProductAction.view(CatalogRandomNewProductAction.java:40) sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) java.lang.reflect.Method.invoke(Method.java:597) org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) org.apache.struts.actions.DispatchAction.execute(DispatchAction.java:187) ro.esolutions.shopportlet.struts.PageAction.execute(PageAction.java:106) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) org.apache.portals.bridges.struts.PortletTilesRequestProcessor.process(PortletTilesRequestProcessor.java:50) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535) org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472) com.liferay.portal.apache.bridges.struts.LiferayRequestDispatcher.invoke(LiferayRequestDispatcher.java:170) com.liferay.portal.apache.bridges.struts.LiferayRequestDispatcher.include(LiferayRequestDispatcher.java:99) org.apache.portals.bridges.struts.StrutsPortlet.processRequest(StrutsPortlet.java:375) org.apache.portals.bridges.struts.StrutsPortlet.doView(StrutsPortlet.java:274) javax.portlet.GenericPortlet.doDispatch(GenericPortlet.java:328) javax.portlet.GenericPortlet.render(GenericPortlet.java:233) com.sun.portal.portletcontainer.appengine.filter.FilterChainImpl.doFilter(FilterChainImpl.java:126) com.liferay.portal.kernel.portlet.PortletFilterUtil.doFilter(PortletFilterUtil.java:69) com.liferay.portal.kernel.servlet.PortletServlet.service(PortletServlet.java:100) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535) org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472) com.liferay.portlet.InvokerPortletImpl.invoke(InvokerPortletImpl.java:618) com.liferay.portlet.InvokerPortletImpl.invokeRender(InvokerPortletImpl.java:700) com.liferay.portlet.InvokerPortletImpl.render(InvokerPortletImpl.java:419) org.apache.jsp.html.portal.render_005fportlet_jsp._jspService(render_005fportlet_jsp.java:1467) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535) org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472) com.liferay.portal.util.PortalImpl.renderPortlet(PortalImpl.java:2884) com.liferay.portal.util.PortalUtil.renderPortlet(PortalUtil.java:897) com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:170) com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processPortlet(RuntimePortletUtil.java:103) com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:281) com.liferay.portlet.layoutconfiguration.util.RuntimePortletUtil.processTemplate(RuntimePortletUtil.java:190) org.apache.jsp.html.portal.layout.view.portlet_jsp._jspService(portlet_jsp.java:831) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:535) org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:472) com.liferay.portal.action.LayoutAction.includeLayoutContent(LayoutAction.java:294) com.liferay.portal.action.LayoutAction.processLayout(LayoutAction.java:471) com.liferay.portal.action.LayoutAction.execute(LayoutAction.java:195) org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431) org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) com.liferay.portal.struts.PortalRequestProcessor.process(PortalRequestProcessor.java:157) org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:414) javax.servlet.http.HttpServlet.service(HttpServlet.java:617) com.liferay.portal.servlet.MainServlet.callParentService(MainServlet.java:608) com.liferay.portal.servlet.MainServlet.service(MainServlet.java:846) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) com.liferay.portal.servlet.FriendlyURLServlet.service(FriendlyURLServlet.java:143) javax.servlet.http.HttpServlet.service(HttpServlet.java:717) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) com.liferay.portal.servlet.filters.strip.StripFilter.processFilter(StripFilter.java:142) com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:94) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) com.liferay.portal.servlet.filters.gzip.GZipFilter.processFilter(GZipFilter.java:140) com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) com.liferay.portal.servlet.filters.secure.SecureFilter.processFilter(SecureFilter.java:282) com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:94) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) com.liferay.portal.servlet.filters.cache.CacheFilter.processFilter(CacheFilter.java:368) com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) com.liferay.portal.kernel.servlet.BaseFilter.processFilter(BaseFilter.java:154) com.liferay.portal.servlet.filters.autologin.AutoLoginFilter.processFilter(AutoLoginFilter.java:257) com.liferay.portal.kernel.servlet.BaseFilter.doFilter(BaseFilter.java:91) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:630) org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:436) org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:374) org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:302) org.tuckey.web.filters.urlrewrite.RewrittenUrl.doRewrite(RewrittenUrl.java:176) org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:728) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) com.esol.MyServletFilter.doFilter(MyServletFilter.java:35) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:433) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:437) org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:366) org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) java.lang.Thread.run(Thread.java:619)