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 | 7 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

    GitHub comment 506#253572452

    GitHub | 7 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 | 9 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