Details
-
Bug
-
Resolution: Won't Do
-
Critical
-
WCM 5.0 SP3
-
None
-
18881
Description
Impossible to enter the stats menu in the admin center on MYSQL (after havig performed some stress tests all the nights... so perhaps related to the size of the stats table):
2007-10-18 10:21:03,609: WARN [org.jahia.resourcebundle.JahiaResourceBundle] - Resource [org.jahia.admin.status.ManageStatus.cache.JahiaLinkManagerCacheCount.description.label] not found in administration resource bundles using locale [en]
2007-10-18 10:30:13,375: ERROR [org.hibernate.util.JDBCExceptionReporter] - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '30 jahiastati0_.year_jahia_statistics as col_0_0_, jahiastati0_.month_jahia_stat' at line
1
2007-10-18 10:30:14,640: ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/jahia].[org.jahia.jsp.jahia.war.jsp.jahia.administration.statistics_005fdisplay_jsp]] - "Servlet.service()" pour la servlet org.jahia.jsp.jahia.war.jsp.jahia.administration.statistics_005fdisplay_jsp a la
ncÚ une exception
org.hibernate.exception.GenericJDBCException: could not execute query
at org.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:92)
at org.hibernate.exception.ErrorCodeConverter.convert(ErrorCodeConverter.java:80)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:1596)
at org.hibernate.loader.Loader.list(Loader.java:1577)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:395)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:271)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:844)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
at org.jahia.hibernate.dao.JahiaStatisticsDAO.getStatisticsRecords(JahiaStatisticsDAO.java:83)
at org.jahia.hibernate.manager.JahiaStatisticsManager.getStatisticsRecords(JahiaStatisticsManager.java:115)
at org.jahia.hibernate.manager.JahiaStatisticsManager$$FastClassByCGLIB$$8dbe176d.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:57)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$FixedChainStaticTargetInterceptor.intercept(Cglib2AopProxy.java:546)
at org.jahia.hibernate.manager.JahiaStatisticsManager$$EnhancerByCGLIB$$6cdb4ac8.getStatisticsRecords(<generated>)
at org.jahia.services.statistics.JahiaStatisticsManagerDBService.getStatisticsRecords(JahiaStatisticsManagerDBService.java:125)
at org.jahia.services.statistics.JahiaStatisticsManagerDBService$$FastClassByCGLIB$$89f681ec.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.statistics.JahiaStatisticsManagerDBService$$EnhancerByCGLIB$$d703bd5.getStatisticsRecords(<generated>)
at org.jahia.services.statistics.JahiaStatisticsPaginatedList.getList(JahiaStatisticsPaginatedList.java:166)
at org.displaytag.tags.TableTag.initParameters(TableTag.java:858)
at org.displaytag.tags.TableTag.doStartTag(TableTag.java:722)
at org.displaytag.tags.el.ELTableTag.doStartTag(ELTableTag.java:349)
at org.jahia.jsp.jahia.war.jsp.jahia.administration.statistics_005fdisplay_jsp._jspService(statistics_005fdisplay_jsp.java:447)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672)
at org.apache.catalina.core.ApplicationDispatcher.doInclude(ApplicationDispatcher.java:574)
at org.apache.catalina.core.ApplicationDispatcher.include(ApplicationDispatcher.java:499)
at org.jahia.services.fetchers.JahiaFetcherBaseService.fetchServlet(JahiaFetcherBaseService.java:113)
at org.jahia.services.fetchers.JahiaFetcherBaseService$$FastClassByCGLIB$$f46e2225.invoke(<generated>)
at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:149)
at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:661)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:122)
at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:80)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:144)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:606)
at org.jahia.services.fetchers.JahiaFetcherBaseService$$EnhancerByCGLIB$$ba67c6b0.fetchServlet(<generated>)
at org.jahia.bin.JahiaAdministration.doRedirect(JahiaAdministration.java:584)
at org.jahia.admin.statistics.ManageStatistics.displayStatistics(ManageStatistics.java:251)
at org.jahia.admin.statistics.ManageStatistics.displayDefaultStatistic(ManageStatistics.java:140)
at org.jahia.admin.statistics.ManageStatistics.userRequestDispatcher(ManageStatistics.java:124)
at org.jahia.admin.statistics.ManageStatistics.<init>(ManageStatistics.java:96)
at org.jahia.bin.JahiaAdministration.userRequestDispatcher(JahiaAdministration.java:440)
at org.jahia.bin.JahiaAdministration.service(JahiaAdministration.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:619)
Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '30 jahiastati0_.year_jahia_statistics as col_0_0_, jahiastati0_.month_jahia_stat' at line 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1695)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3026)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1137)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1231)
at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:120)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1272)
at org.hibernate.loader.Loader.doQuery(Loader.java:391)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:218)
at org.hibernate.loader.Loader.doList(Loader.java:1593)
... 73 more
TestRail: Results
Attachments
Issue Links
- duplicates
-
JAHIA-2496 Root context: stats module in the Admin Center does not work any more
- Closed