Uploaded image for project: 'Jahia Community'
  1. Jahia Community
  2. JAHIA-2552

Admin Center: Stats menu: impossible to enter the menu on MYSQL

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Critical
    • WCM 5.0 SP3
    • 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

            Activity

              People

                ktlili Khaled Tlili (Inactive)
                scroisier Stephane Croisier (Inactive)
                Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases

                      Packages

                        Version Package
                        WCM 5.0 SP3