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.

GitHub | patrickzurek | 4 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

    GitHub comment 506#253572452

    GitHub | 4 months ago | patrickzurek
    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.
  2. 0

    Hibernate Search: GenericJDBCException: could not extract ResultSet

    Stack Overflow | 6 months ago | Humoyun
    org.hibernate.exception.GenericJDBCException: could not extract ResultSet

    1 unregistered visitors

    Root Cause Analysis

    1. 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()
    2. MySQL jdbc
      PreparedStatement.executeQuery
      1. com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2691)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1612)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
      4. com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
      5. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
      6. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1467)
      6 frames
    3. Commons DBCP
      DelegatingPreparedStatement.executeQuery
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:93)
      1 frame
    4. Spring Framework
      JdbcTemplate.query
      1. org.springframework.jdbc.core.JdbcTemplate$1.doInPreparedStatement(JdbcTemplate.java:643)
      2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:586)
      3. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
      4. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:661)
      5. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:681)
      5 frames
    5. xc.mst.services
      MetadataServiceManager.doSomeWork
      1. xc.mst.services.transformation.dao.TransformationDAO.getHoldingIdsToActivate(TransformationDAO.java:279)
      2. xc.mst.services.transformation.TransformationService.commitIfNecessary(TransformationService.java:263)
      3. xc.mst.services.GenericMetadataService.process(GenericMetadataService.java:689)
      4. xc.mst.services.MetadataServiceManager.doSomeWork(MetadataServiceManager.java:81)
      4 frames
    6. xc.mst.scheduling
      WorkerThread.run
      1. xc.mst.scheduling.WorkerThread.run(WorkerThread.java:92)
      1 frame
    7. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame