com.mysql.jdbc.PacketTooBigException

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.

  • GitHub comment 506#253572452
    via GitHub by patrickzurek
    ,
  • 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 (59179710 > 16776192). You can change this value on the server by setting th e max_allowed_packet' variable. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:107) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:602) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661) at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:681) 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) Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (59179710 > 16776192) . You can change this value on the server by setting the 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.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93) at org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586) ... 9 more

    Users with the same issue

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