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.

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • 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)
    via by Daniele Turi,
  • MySQL server configuration issues
    via by Unknown author,
  • 'Packet for query is too large' exception you may come across
    via by Jonathan Lim-Breitbart,
  • Sonar Analysis is failing
    via by Anil Kumar,
  • SonarQube Analysis not showing code coverage
    via Stack Overflow by Prachi
    ,
    • 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(MysqlIO.java:3592)[mysql-connector-java-5.1.34.jar:5.1.34] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417)[mysql-connector-java-5.1.34.jar:5.1.34]

    Users with the same issue

    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,