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 | 8 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

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

    mysql.com | 8 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