Uploaded image for project: 'Magnolia'
  1. Magnolia
  2. MAGNOLIA-1981

Unable to update item due to mysqlDataTruncation exception

    XMLWordPrintable

Details

    • Bug
    • Resolution: Not an issue
    • Major
    • None
    • 3.0.5
    • None
    • None
    • Linux Centos 5, tomcat 5.5, jdk1.5.0_09, apache 2, mod_jk, MySQL 5

    Description

      If we enter too much (textual) content on a certain page we get the following exception:

      ERROR  info.magnolia.module.admininterface.SaveHandlerImpl 19.12.2007 12:30:17 -- /: unable to update item.: failed to write property state: 55c1ea2e-ed07-4e20-b7f5-b05c720da66b/{}content
      javax.jcr.RepositoryException: /: unable to update item.: failed to write property state: 55c1ea2e-ed07-4e20-b7f5-b05c720da66b/{}content: failed to write property state: 55c1ea2e-ed07-4e20-b7f5-b05c720da66b/{}content
              at org.apache.jackrabbit.core.ItemImpl.save(ItemImpl.java:1197)
              at org.apache.jackrabbit.core.SessionImpl.save(SessionImpl.java:805)
              at info.magnolia.cms.core.HierarchyManager.save(HierarchyManager.java:525)
              at info.magnolia.module.admininterface.SaveHandlerImpl.save(SaveHandlerImpl.java:212)
              at info.magnolia.module.admininterface.DialogMVCHandler.onSave(DialogMVCHandler.java:284)
              at info.magnolia.module.admininterface.DialogMVCHandler.save(DialogMVCHandler.java:181)
              at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
              at java.lang.reflect.Method.invoke(Method.java:585)
              at info.magnolia.cms.servlets.MVCServletHandlerImpl.execute(MVCServletHandlerImpl.java:96)
              at info.magnolia.cms.servlets.MVCServlet.doPost(MVCServlet.java:111)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:710)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
       
       
       
      CAUSED by:
       
      mysqlDataTruncation: Data truncation: Data too long for column 'PROP_DATA' at row 1
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3374)
              at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3308)
              at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1837)
              at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1961)
              at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2543)
              at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1737)
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2022)
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1940)
              at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1925)
      

      It seems there is a limit in the datamodel for the storage of this content? Or maybe it is a setting in our MySQL that we need to tweak? Any help is greatly appreciated.

      Checklists

        Acceptance criteria

        Attachments

          Activity

            People

              kraft Boris Kraft
              edgar Edgar Vonk
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Checklists

                  Bug DoR
                  Task DoD