Uploaded image for project: 'CMS'
  1. CMS
  2. CMS-12618

Unable to store cache statistics for page with too long URL

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • 4.9.5, 4.10.0
    • None
    • None
    • None

      2025-12-12 00:15:00,026 ERROR [org.ametys.web.cache.monitoring.process.access.ResourceAccessComponent] (AmetysRuntimeScheduler_Worker-2;) Exception exception while inserting new records to 
      the database
      org.apache.ibatis.exceptions.PersistenceException: 
      ### Error updating database.  Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'Page_Id' at row 1
      ### The error may exist in /org/ametys/web/cache/monitoring/process/access/cache-monitoring-access.xml
      ### The error may involve defaultParameterMap
      ### The error occurred while setting parameters
      ### SQL: INSERT INTO Cache_RA_Back (Internal_Uuid, Page_Id, Page_Path_Hash, Page_Path, Rendering_Context, Workspace_JCR, Cacheable, Created_At)         VALUES (?, ?, ?, ?, ?, ?, ?, ?)
      ### Cause: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'Page_Id' at row 1
              at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30)
              at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199)
              at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
              at org.ametys.web.cache.monitoring.process.access.ResourceAccessComponent._fillDatabase(ResourceAccessComponent.java:111)
              at org.ametys.web.cache.monitoring.process.access.ResourceAccessComponent._fillDatabase(ResourceAccessComponent.java:96)
              at org.ametys.web.cache.monitoring.process.access.ResourceAccessComponent.exportPendings(ResourceAccessComponent.java:79)
              at org.ametys.web.cache.monitoring.process.CacheMonitoringSchedulable.execute(CacheMonitoringSchedulable.java:56)
              at org.ametys.core.schedule.AmetysJob.execute(AmetysJob.java:157)
              at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
              at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
      Caused by: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Data too long for column 'Page_Id' at row 1
              at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:104)
              at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
              at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:95)
              at org.apache.commons.dbcp2.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:95)
              at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48)
              at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75)
              at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
              at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
              at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
              at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
              ... 8 more
      

            Unassigned Unassigned
            cedric Cédric Damioli
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated: