Uploaded image for project: 'Offre de formation'
  1. Offre de formation
  2. ODF-1010

[Export SQL] : Packet for query is too large

    • Icon: Bug Bug
    • Resolution: Invalid
    • Icon: Major Major
    • 4.7.0
    • 2.3.0
    • None
    • None

      C'est un bug ou c'est de la conf serveur à ajuster ?

      ERROR [org.ametys.odf.export.ODFExportEngine] (ODFExportEngine;/plugins/core/servercomm/messages.xml) ODF export has failed
      java.sql.BatchUpdateException: Packet for query is too large (5390708 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
      	at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1666)
      	at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1082)
      	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      	at org.apache.commons.dbcp.DelegatingStatement.executeBatch(DelegatingStatement.java:297)
      	at org.ametys.odf.export.ExportManager.fillTableForRepeater(ExportManager.java:1111)
      	at org.ametys.odf.export.ExportManager.fillMetadata(ExportManager.java:1268)
      	at org.ametys.odf.export.ExportManager.fillCompositeMetadata(ExportManager.java:1143)
      	at org.ametys.odf.export.ODFExportManager.fillCompositeMetadata(ODFExportManager.java:448)
      	at org.ametys.odf.export.ExportManager.fillTableForContentType(ExportManager.java:1066)
      	at org.ametys.odf.export.ExportManager.insertValues(ExportManager.java:1024)
      	at org.ametys.odf.export.ExportManager.export(ExportManager.java:218)
      	at org.ametys.odf.export.ODFExportEngine.export(ODFExportEngine.java:186)
      	at org.ametys.odf.export.ODFExportEngine.run(ODFExportEngine.java:104)
      	at java.lang.Thread.run(Thread.java:662)
      
      

            Unassigned Unassigned
            lperier Laurence Perier
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: