FreeMarker template error (HTML_DEBUG mode; use RETHROW in production!)
Java method "com.bupticet.cms.web.action.ContentAction.getCategoryWithoutSonByUrlTitle(String)" threw an exception when invoked on com.bupticet.cms.web.action.ContentAction object "com.bupticet.cms.web.action.ContentAction@1f155d26"; see cause exception in the Java stack trace.
----
FTL stack trace ("~" means nesting-related):
- Failed at: #if action.getCategoryWithoutSonByUrl... [in template "WEB-INF/config/site_templates/default/site.ftl" at line 137, column 49]
----
Java stack trace (for programmers):
----
freemarker.core._TemplateModelException: [... Exception message was already printed; see it above ...]
at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:311)
at freemarker.ext.beans._MethodUtil.newInvocationTemplateModelException(_MethodUtil.java:275)
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:80)
at freemarker.core.MethodCall._eval(MethodCall.java:62)
at freemarker.core.Expression.eval(Expression.java:78)
at freemarker.core.ExistsExpression._eval(ExistsExpression.java:45)
at freemarker.core.Expression.eval(Expression.java:78)
at freemarker.core.Expression.evalToBoolean(Expression.java:118)
at freemarker.core.Expression.evalToBoolean(Expression.java:110)
at freemarker.core.ConditionalBlock.accept(ConditionalBlock.java:46)
at freemarker.core.Environment.visit(Environment.java:312)
at freemarker.core.MixedContent.accept(MixedContent.java:62)
at freemarker.core.Environment.visit(Environment.java:312)
at freemarker.core.EscapeBlock.accept(EscapeBlock.java:48)
at freemarker.core.Environment.visit(Environment.java:312)
at freemarker.core.Environment.process(Environment.java:290)
at freemarker.template.Template.process(Template.java:312)
at org.apache.struts2.views.freemarker.FreemarkerResult.doExecute(FreemarkerResult.java:223)
at org.apache.struts2.dispatcher.StrutsResultSupport.execute(StrutsResultSupport.java:191)
at com.opensymphony.xwork2.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:372)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:276)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:229)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
at com.filter.XssJsoupInterceptor.intercept(XssJsoupInterceptor.java:24)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:189)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:245)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:575)
at org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:81)
at org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:99)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:153)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.bupticet.filter.SetClientInfoFilter.doFilterInternal(SetClientInfoFilter.java:60)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:153)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.bupticet.clickstream.filter.VisitRecordFilter.doFilterInternal(VisitRecordFilter.java:126)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:153)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.bupticet.filter.ForceNoCacheFilter.doFilterInternal(ForceNoCacheFilter.java:98)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:153)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:140)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.bupticet.filter.LoginModuleFilter.doFilterInternal(LoginModuleFilter.java:104)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:153)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
at com.filter.SwitchoverFilter.doFilterInternal(SwitchoverFilter.java:57)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:153)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
at com.bupticet.educonfig.filter.TermConfigFilter.doFilterInternal(TermConfigFilter.java:32)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:153)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at com.bupticet.filter.WrapperFilter.doFilter(WrapperFilter.java:153)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:101)
at com.bupticet.ilab.filter.IlabFilter.doFilterInternal(IlabFilter.java:103)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:690)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.ID as ID17_2_, this_.EXTENDED_INFO as EXTENDED2_17_2_, this_.ARTICLE_TYPE as ARTICLE3_17_2_, this_.AUDITOR_NAME as AUDITOR4_17_2_, this_.AUDITOR_NUMBER_ID as AUDITOR5_17_2_, this_.AUDITOR_STATE as AUDITOR6_17_2_, this_.AUDITOR_ID as AUDITOR7_17_2_, this_.DESCRIPTION as DESCRIPT8_17_2_, this_.DISPLAY_AREA as DISPLAY9_17_2_, this_.FATHER_ID as FATHER19_17_2_, this_.KEYWORDS as KEYWORDS17_2_, this_.NAME as NAME17_2_, this_.ORDER_NUM as ORDER12_17_2_, this_.PIC_ID as PIC20_17_2_, this_.SITE_ID as SITE21_17_2_, this_.SUB_PATH_CACHE as SUB13_17_2_, this_.TEMPLATE_NAME as TEMPLATE14_17_2_, this_.THEME_NAME as THEME15_17_2_, this_.TYPE as TYPE17_2_, this_.URL as URL17_2_, this_.URL_TITLE as URL18_17_2_, categorypi2_.ID as ID18_0_, categorypi2_.CREATED_TIME as CREATED2_18_0_, categorypi2_.CREATOR_IP as CREATOR3_18_0_, categorypi2_.DOWNLOAD_TIMES as DOWNLOAD4_18_0_, categorypi2_.EXTENSION as EXTENSION18_0_, categorypi2_.FILE_ADDR as FILE6_18_0_, categorypi2_.INTRO as INTRO18_0_, categorypi2_.NAME as NAME18_0_, categorypi2_.SIZE as SIZE18_0_, categorypi2_.STUDENT_NUM as STUDENT10_18_0_, sons3_.FATHER_ID as FATHER19_17_4_, sons3_.ID as ID4_, sons3_.ID as ID17_1_, sons3_.EXTENDED_INFO as EXTENDED2_17_1_, sons3_.ARTICLE_TYPE as ARTICLE3_17_1_, sons3_.AUDITOR_NAME as AUDITOR4_17_1_, sons3_.AUDITOR_NUMBER_ID as AUDITOR5_17_1_, sons3_.AUDITOR_STATE as AUDITOR6_17_1_, sons3_.AUDITOR_ID as AUDITOR7_17_1_, sons3_.DESCRIPTION as DESCRIPT8_17_1_, sons3_.DISPLAY_AREA as DISPLAY9_17_1_, sons3_.FATHER_ID as FATHER19_17_1_, sons3_.KEYWORDS as KEYWORDS17_1_, sons3_.NAME as NAME17_1_, sons3_.ORDER_NUM as ORDER12_17_1_, sons3_.PIC_ID as PIC20_17_1_, sons3_.SITE_ID as SITE21_17_1_, sons3_.SUB_PATH_CACHE as SUB13_17_1_, sons3_.TEMPLATE_NAME as TEMPLATE14_17_1_, sons3_.THEME_NAME as THEME15_17_1_, sons3_.TYPE as TYPE17_1_, sons3_.URL as URL17_1_, sons3_.URL_TITLE as URL18_17_1_ from VO_CATEGORIES this_ left outer join VO_CATEGORY_PICS categorypi2_ on this_.PIC_ID=categorypi2_.ID left outer join VO_CATEGORIES sons3_ on this_.ID=sons3_.FATHER_ID where this_.SITE_ID=? and this_.URL_TITLE=? order by sons3_.ORDER_NUM asc]; 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.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
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.doExecute(HibernateTemplate.java:411)
at org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:339)
at com.bupticet.base.dao.BaseHibernateDao.joinGetObjects(BaseHibernateDao.java:351)
at com.bupticet.base.dao.BaseHibernateDao.joinGetObjects(BaseHibernateDao.java:319)
at com.bupticet.cms.dao.impl.CategoryDaoImpl.getCategoryWithoutSonByUrlTitle(CategoryDaoImpl.java:95)
at com.bupticet.cms.service.impl.CategoryManagerImpl.getCategoryWithoutSonByUrlTitle(CategoryManagerImpl.java:277)
at com.bupticet.cms.service.impl.CategoryManagerImpl$$FastClassByCGLIB$$6424fde0.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:698)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at com.alibaba.druid.support.spring.stat.DruidStatInterceptor.invoke(DruidStatInterceptor.java:72)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:96)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:260)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:631)
at com.bupticet.cms.service.impl.CategoryManagerImpl$$EnhancerByCGLIB$$51894a83.getCategoryWithoutSonByUrlTitle(<generated>)
at com.bupticet.cms.web.action.ContentAction.getCategoryWithoutSonByUrlTitle(ContentAction.java:582)
at sun.reflect.GeneratedMethodAccessor82.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at freemarker.ext.beans.BeansWrapper.invokeMethod(BeansWrapper.java:1458)
at freemarker.ext.beans.SimpleMethodModel.exec(SimpleMethodModel.java:71)
... 103 more
Caused by: java.sql.SQLException: Got error 28 from storage engine
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3376)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:894)
at com.mysql.jdbc.MysqlIO.nextRow(MysqlIO.java:1382)
at com.mysql.jdbc.MysqlIO.readSingleRowSet(MysqlIO.java:2697)
at com.mysql.jdbc.MysqlIO.getResultSet(MysqlIO.java:459)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:2411)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1657)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2036)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1888)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2714)
at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_executeQuery(FilterEventAdapter.java:465)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2711)
at com.alibaba.druid.wall.WallFilter.preparedStatement_executeQuery(WallFilter.java:621)
at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_executeQuery(FilterChainImpl.java:2711)
at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.executeQuery(PreparedStatementProxyImpl.java:145)
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeQuery(DruidPooledPreparedStatement.java:227)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
at org.hibernate.loader.Loader.doQuery(Loader.java:802)
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.criteria.CriteriaLoader.list(CriteriaLoader.java:119)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1716)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:347)
at com.bupticet.base.dao.BaseHibernateDao$5.doInHibernate(BaseHibernateDao.java:401)
at org.springframework.orm.hibernate3.HibernateTemplate.doExecute(HibernateTemplate.java:406)
... 128 more