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.

mysql.com | 4 months ago
  1. 0

    MySQL Bugs: #76177: Packet for query is too large (1094 > 1024)

    mysql.com | 4 months ago
    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.
  2. 0

    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)

    JIRA | 10 years ago | Daniele Turi
    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.
  3. 0

    Hibernate Search: GenericJDBCException: could not extract ResultSet

    Stack Overflow | 4 months ago | Humoyun
    org.hibernate.exception.GenericJDBCException: could not extract ResultSet
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Dataimport fails for large data in SOLR

    Stack Overflow | 4 years ago | John Smith
    com.mysql.jdbc.PacketTooBigException: Packet for query is too large (7959657 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
  6. 0

    I wanted to publish all my documents, so I did a branch-wide search, created a Worklist, then I removed some fields I didn't need to make room for the Publish Date field -- which I was informed I needed when I tried to approve them all -- I manually selected today as the publish date (with the default 00:00 time) and when I hit "Save" I got the exception. {noformat} ******************Stack Trace-Only shown when not in production***************** org.springframework.dao.TransientDataAccessResourceException: OJB operation; SQL []; Packet for query is too large (1486406 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1486406 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:106) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springmodules.orm.ojb.OjbAccessor.convertJdbcAccessException(OjbAccessor.java:107) at org.springmodules.orm.ojb.OjbAccessor.convertOjbAccessException(OjbAccessor.java:89) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:144) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.store(PersistenceBrokerTemplate.java:244) at org.kuali.rice.kew.routeheader.dao.impl.DocumentRouteHeaderDAOOjbImpl.saveRouteHeader(DocumentRouteHeaderDAOOjbImpl.java:77) at org.kuali.rice.kew.routeheader.service.impl.RouteHeaderServiceImpl.saveRouteHeader(RouteHeaderServiceImpl.java:63) at sun.reflect.GeneratedMethodAccessor573.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at sun.proxy.$Proxy453.saveRouteHeader(Unknown Source) at org.kuali.rice.kew.service.impl.WorkflowDocumentActionsWebServiceImpl.saveDocumentContent(WorkflowDocumentActionsWebServiceImpl.java:357) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at sun.proxy.$Proxy308.saveDocumentContent(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at sun.proxy.$Proxy309.saveDocumentContent(Unknown Source) at org.kuali.rice.kew.service.WorkflowDocument.saveDocumentContent(WorkflowDocument.java:1179) at org.kuali.rice.kew.service.WorkflowDocument.createDocumentIfNeccessary(WorkflowDocument.java:1004) at org.kuali.rice.kew.service.WorkflowDocument.saveDocument(WorkflowDocument.java:473) at org.kuali.rice.kns.workflow.service.impl.KualiWorkflowDocumentImpl.saveDocument(KualiWorkflowDocumentImpl.java:180) at org.kuali.rice.kns.workflow.service.impl.WorkflowDocumentServiceImpl.save(WorkflowDocumentServiceImpl.java:288) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at sun.proxy.$Proxy259.save(Unknown Source) at org.kuali.rice.kns.service.impl.DocumentServiceImpl.saveDocument(DocumentServiceImpl.java:127) at org.kuali.rice.kns.service.impl.DocumentServiceImpl.saveDocument(DocumentServiceImpl.java:109) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at sun.proxy.$Proxy266.saveDocument(Unknown Source) at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.save(KualiDocumentActionBase.java:544) at org.kuali.kits.kms.worklist.WorkListAction.save(WorkListAction.java:594) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:601) at org.apache.struts.actions.DispatchAction.dispatchMethod(DispatchAction.java:270) at org.kuali.rice.kns.web.struts.action.KualiAction.dispatchMethod(KualiAction.java:172) at org.kuali.rice.kns.web.struts.action.KualiAction.execute(KualiAction.java:123) at org.kuali.rice.kns.web.struts.action.KualiDocumentActionBase.execute(KualiDocumentActionBase.java:118) at org.kuali.kits.kms.worklist.WorkListAction.execute(WorkListAction.java:143) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor$1.doInTransaction(KualiRequestProcessor.java:503) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.processActionPerform(KualiRequestProcessor.java:499) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236) at org.kuali.rice.kns.web.struts.action.KualiRequestProcessor.process(KualiRequestProcessor.java:101) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432) at javax.servlet.http.HttpServlet.service(HttpServlet.java:641) at javax.servlet.http.HttpServlet.service(HttpServlet.java:722) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kew.web.UserLoginFilter.doFilter(UserLoginFilter.java:92) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:273) at org.kuali.rice.kew.web.DummyLoginFilter.doFilter(DummyLoginFilter.java:86) at org.kuali.rice.kew.web.BootstrapFilterChain.doFilter(BootstrapFilter.java:266) at org.kuali.rice.kew.web.BootstrapFilter.doFilter(BootstrapFilter.java:164) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.displaytag.filter.ResponseOverrideFilter.doFilter(ResponseOverrideFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.kuali.rice.kns.web.filter.HideWebInfFilter.doFilter(HideWebInfFilter.java:69) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:722) Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1486406 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3778) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2471) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2683) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2144) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2444) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2362) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2347) at org.enhydra.jdbc.core.CorePreparedStatement.executeUpdate(CorePreparedStatement.java:102) at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeUpdate(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.storeToDb(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.PersistenceBrokerImpl.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.apache.ojb.broker.core.DelegatingPersistenceBroker.store(Unknown Source) at org.springmodules.orm.ojb.PersistenceBrokerTemplate$9.doInPersistenceBroker(PersistenceBrokerTemplate.java:246) at org.springmodules.orm.ojb.PersistenceBrokerTemplate.execute(PersistenceBrokerTemplate.java:141) ... 116 more {noformat}

    Kuali JIRA | 4 years ago | Steven Black
    org.springframework.dao.TransientDataAccessResourceException: OJB operation; SQL []; Packet for query is too large (1486406 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.; nested exception is com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1486406 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. MySQL jdbc
      MysqlIO.sendCommand
      1. com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3592)[mysql-connector-java-5.1.34.jar:5.1.34]
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417)[mysql-connector-java-5.1.34.jar:5.1.34]
      2 frames