com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1122 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.

mysql.com | 7 months ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    MySQL Bugs: #76177: Packet for query is too large (1094 > 1024)

    mysql.com | 7 months ago
    com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1122 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
  2. 0

    When running the workflow ncbi/nuc_test.xml and omim_test.xml I get the following com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2654341 > 1 047552). You can change this value on the server by setting the max_allowed_pack et' variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2635) at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2621) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1552) at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedSt atement.java:1124) at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPrepared Statement.java:676) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1166) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1082) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java :1067) at uk.org.mygrid.provenance.dataservice.MySQLDataService.insertData(MySQ LDataService.java:227) at uk.org.mygrid.provenance.dataservice.AbstractJDBCDataService.storeDat aThing(AbstractJDBCDataService.java:341) at uk.ac.man.cs.img.mygrid.provenance.knowledge.taverna.ProvenanceGenera tor.store(ProvenanceGenerator.java:1395) at uk.ac.man.cs.img.mygrid.provenance.knowledge.taverna.ProvenanceGenera tor.workflowCompleted(ProvenanceGenerator.java:422) at org.embl.ebi.escience.scufl.enactor.implementation.WorkflowEventDispa tcher.sendAnEvent(WorkflowEventDispatcher.java:199) at org.embl.ebi.escience.scufl.enactor.implementation.WorkflowEventDispa tcher.fireEvents(WorkflowEventDispatcher.java:184) at org.embl.ebi.escience.scufl.enactor.implementation.WorkflowEventDispa tcher$NotifyThread.run(WorkflowEventDispatcher.java:250)

    JIRA | 1 decade ago | Daniele Turi
    com.mysql.jdbc.PacketTooBigException: Packet for query is too large (2654341 > 1 047552). You can change this value on the server by setting the max_allowed_pack et' variable.

    Root Cause Analysis

    1. com.mysql.jdbc.PacketTooBigException

      Packet for query is too large (1122 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.

      at com.mysql.jdbc.MysqlIO.send()
    2. MySQL jdbc
      MysqlIO.sendCommand
      1. com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3592)[mysql-connector-java-5.1.34.jar:5.1.34]
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417)[mysql-connector-java-5.1.34.jar:5.1.34]
      2 frames