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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by patrickzurek
, 1 year ago
Packet for query is too large (59179710 > 16776192). You can change this value on the server by setting th e max_allowed_packet' variable.
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (59179710 > 16776192). You can change this value on the server by setting th e max_allowed_packet' variable.
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
at xc.mst.services.transformation.dao.TransformationDAO.getHoldingIdsToActivate(TransformationDAO.java:279)
at xc.mst.services.transformation.TransformationService.commitIfNecessary(TransformationService.java:263)
at xc.mst.services.GenericMetadataService.process(GenericMetadataService.java:689)
at xc.mst.services.MetadataServiceManager.doSomeWork(MetadataServiceManager.java:81)
at xc.mst.scheduling.WorkerThread.run(WorkerThread.java:92)
at java.lang.Thread.run(Thread.java:619)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 2 years ago

Know the solutions? Share your knowledge to help other developers to debug faster.