org.hibernate.exception.GenericJDBCException: could not extract ResultSet

Stack Overflow | Humoyun | 4 months ago
  1. 0

    Hibernate Search: GenericJDBCException: could not extract ResultSet

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

    GitHub comment 506#253572452

    GitHub | 2 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.
  3. 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.
  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.

    1 unregistered visitors
    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 (7501 > 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
      PreparedStatement.executeQuery
      1. com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3671)
      2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2508)
      3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
      4. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
      5. com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
      6. com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1962)
      6 frames
    3. Hibernate
      CriteriaImpl.list
      1. org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
      2. org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
      3. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
      4. org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
      5. org.hibernate.loader.Loader.doQuery(Loader.java:910)
      6. org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
      7. org.hibernate.loader.Loader.doList(Loader.java:2554)
      8. org.hibernate.loader.Loader.doList(Loader.java:2540)
      9. org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
      10. org.hibernate.loader.Loader.list(Loader.java:2365)
      11. org.hibernate.loader.criteria.CriteriaLoader.list(CriteriaLoader.java:126)
      12. org.hibernate.internal.SessionImpl.list(SessionImpl.java:1718)
      13. org.hibernate.internal.CriteriaImpl.list(CriteriaImpl.java:380)
      13 frames
    4. Hibernate Search ORM
      FullTextQueryImpl.list
      1. org.hibernate.search.query.hibernate.impl.CriteriaObjectsInitializer.initializeObjects(CriteriaObjectsInitializer.java:110)
      2. org.hibernate.search.query.hibernate.impl.QueryLoader.executeLoad(QueryLoader.java:93)
      3. org.hibernate.search.query.hibernate.impl.AbstractLoader.load(AbstractLoader.java:75)
      4. org.hibernate.search.query.hibernate.impl.FullTextQueryImpl.list(FullTextQueryImpl.java:217)
      4 frames
    5. full_text_search_modul
      SearchApp.main
      1. full_text_search_modul.FullTextSearchClass.search(FullTextSearchClass.java:87)
      2. full_text_search_modul.FullTextSearchClass.printTweets(FullTextSearchClass.java:120)
      3. full_text_search_modul.SearchApp.main(SearchApp.java:38)
      3 frames