com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1157 > 1024).

最新推荐文章于 2024-04-17 16:28:12 发布
原创 最新推荐文章于 2024-04-17 16:28:12 发布 · 2.8k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#java #ThreadPoolAsynchrono

本文探讨了在使用MySQL时遇到的PacketTooBigException错误及其可能的原因，包括网络不稳定和数据库配置限制。文章还提供了解决方案，包括调整服务器端的max_allowed_packet变量和排查网络问题。

1. com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1157 > 1024).

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1157 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3592)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2417)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2530)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1907)
	at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2030)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:116)
	at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82)
	at org.hibernate.loader.Loader.getResultSet(Loader.java:2066)
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863)
	at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839)
	at org.hibernate.loader.Loader.doQuery(Loader.java:910)
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355)
	at org.hibernate.loader.Loader.doList(Loader.java:2554)
	at org.hibernate.loader.Loader.doList(Loader.java:2540)
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370)
	at org.hibernate.loader.Loader.list(Loader.java:2365)
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497)
	at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387)
	at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236)
	at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1300)
	at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103)
	at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573)
	at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449)
	at sun.reflect.GeneratedMethodAccessor64.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.orm.jpa.SharedEntityManagerCreator$DeferredQueryInvocationHandler.invoke(SharedEntityManagerCreator.java:333)
	at com.sun.proxy.$Proxy175.getResultList(Unknown Source)
	at com.fd.dao.base.impl.BaseDao.get(BaseDao.java:602)
	at com.fd.dao.base.impl.BaseDao.get(BaseDao.java:416)
	at com.fruitday.web.controller.user.UserController.login(UserController.java:271)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:291)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:239)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
	at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:616)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:521)
	at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1096)
	at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:674)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1500)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1456)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)



2. 

2016-04-07 10:21:57.897 [WARN] com.mchange.v2.async.ThreadPoolAsynchronousRunner:743 - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@56ca7f87 -- APPARENT DEADLOCK!!! Creating emergency threads for unassigned pending tasks!
2016-04-07 10:21:57.901 [WARN] com.mchange.v2.async.ThreadPoolAsynchronousRunner:759 - com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector@56ca7f87 -- APPARENT DEADLOCK!!! Complete Status: 
	Managed Threads: 3
	Active Threads: 3
	Active Tasks: 
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@552ae732
			on thread: C3P0PooledConnectionPoolManager[identityToken->1hge5a59f1u6j7zhuuoml6|35fddf9e]-HelperThread-#0
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2d2324cd
			on thread: C3P0PooledConnectionPoolManager[identityToken->1hge5a59f1u6j7zhuuoml6|35fddf9e]-HelperThread-#1
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@317179aa
			on thread: C3P0PooledConnectionPoolManager[identityToken->1hge5a59f1u6j7zhuuoml6|35fddf9e]-HelperThread-#2
	Pending Tasks: 
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@22cf0944
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@205e7958
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@146f34d2
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2e69a3dc
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@74361a7c
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@2771391b
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@4ad54083
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@29416d46
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@6d6077e8
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@43f732be
Pool thread stack traces:
	Thread[C3P0PooledConnectionPoolManager[identityToken->1hge5a59f1u6j7zhuuoml6|35fddf9e]-HelperThread-#0,5,RMI Runtime]
		java.net.DualStackPlainSocketImpl.connect0(Native Method)
		java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
		java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
		java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
		java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
		java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
		java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
		java.net.Socket.connect(Socket.java:589)
		com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:213)
		com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:297)
		com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2232)
		com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2265)
		com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2064)
		com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
		com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
		sun.reflect.GeneratedConstructorAccessor16.newInstance(Unknown Source)
		sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
		java.lang.reflect.Constructor.newInstance(Constructor.java:422)
		com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
		com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:395)
		com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:325)
		com.mchange.v2.c3p0.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:146)
		com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:195)
		com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:184)
		com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:200)
		com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1086)
		com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1073)
		com.mchange.v2.resourcepool.BasicResourcePool.access$800(BasicResourcePool.java:44)
		com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1810)
		com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:648)

报以上的两个错误还有可能是网络问题，并不是数据库配置问题。


最近公司网络不太稳定老是报这个问题，过一会又好了。

com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1146177 > 1048576).
程裕强的专栏
04-06 543
2019-04-06 17:06:25.628 WARN 1564 --- [nio-8080-exec-1] o.a.pdfbox.pdmodel.font.PDSimpleFont : No Unicode mapping for null (0) in font TitilliumMaps29L-400wt org.springframework.dao.TransientData...
MySQL：com.mysql.jdbc.PacketTooBigException: Packet for query is too large(4223215 ＞ 4194304) 异常处理方式
被生活耽误的旅行者
10-12 2658
有一批10W左右的excel数据要导入mysql数据库，excel文件大小为15M左右，后台代码在导入过程中报：Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (5,985,512 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable.\
解决MySQL中 Packet for query is too large的问题
热门推荐
qq_41900340的博客
10-26 1万+
项目场景：     同步大数据出现批量更新或批量插入失败 问题描述：     Caused by:com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (3,456,888 > 1,048,576). You can change this value on the server by setting the ' max_al
PacketTooBigException异常捕获及解决方法
LOVE_sel的博客
05-13 4128
PacketTooBigException异常捕获 一、背景 在连接数据库过程中，爆出如下错误。 原因是：提交的sql信息超过了设置max_allowed_packet参数太小。 举个例子：往数据库中插入text文本，数据库最大允许提交16M的sql,结果你提交了32M； 或者执行的sql条数太多； org.springframework.dao.TransientDataAccessResourceException: ### Error updating database. Cause: com.m
Caused by: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large
zhanghailang1的博客
04-28 1434
最近在学习爬一个网站的时候，存入爬起的信息到本地数据库中报了这么一个错· ; Packet for query is too large (7,465,380 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable.; nested exception is com.mysql.cj.jdbc.exceptions.PacketTooBigException:
com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large
梦想不会灭
08-07 569
在做查询数据库操作时，报了以上错误，还有out of memery heap hacp ,原因是mysql的max_allowed_packet设置过小引起的， mysql根据配置文件会限制server接受的数据包大小。 有时候大的插入和更新会被max_allowed_packet 参数限制掉，导致失败。 [修改mysql配置中my.conf中max_allowed_packet变量] 查看目前配置 show VARIABLES like ‘%max_allowed_packet%’; 显示的结果为： ±-
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (11087 > 102
08-13
本文将深入探讨“com.mysql.jdbc.PacketTooBigException: Packet for query is too large (11087 > 102)”这一异常，分析其原因，并提供相应的解决方案。 `com.mysql.jdbc.PacketTooBigException` 是MySQL JDBC驱动...
-  Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (40 > -1)
07-16
<think>首先，用户的问题是关于解决MySQL异常：com.mysql.jdbc.PacketTooBigException: Packet for query is too large (40 > -1)。用户提供了多个引用，这些引用讨论了类似的问题和解决方案。 关键点： - 异常信息...
-  Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (40 > -1)，检查max_allowed_packet是32M,应该如何解决这个报错
07-16
<think>我们面对的是MySQL的PacketTooBigException异常，具体信息是：Packet for query is too large (40 > -1)。这个异常表明查询的数据包大小为40字节，但服务器允许的最大数据包大小（max_allowed_packet）被识别...
2025-08-20T02:51:10.154428685Z Caused by: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (26,255,725 > 16,777,216). You can change this value on the server by setting the 'max_allowed_packet' variable.
最新发布
08-21
<think>首先，用户的问题是关于解决MySQL的PacketTooBigException异常，具体是"com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large"。我需要基于提供的引用内容来回答。 从引用中...
mysql：Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large
种麦南山下的博客
05-18 2470
### Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (4,246,837 > 4,194,304). You can change this value on the server by setting the 'max_allowed_packet' variable. ; Packet for query is too large (4,246,837 > 4
Cause: com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large
theflowerofac^MQLYES的专栏
04-17 854
查阅后发现问题是由于max_allowed_packet参数引起的，该参数是指mysql服务器端和客户端在一次传送数据包的过程当中最大允许的数据包大小。一次插入的数据超过了max_allowed_packet，则会数据库保存失败，报出异常。我这里是批量插入多条数据，数据条数目测有个几千条，数据大小超过了阈值。网上解决方案是修改max_allowed_packet的值，调大这个值，临时修改或者永久修改都可以。比如之前一次插入5000条数据，我这里改成一次插入500条，分10次插入就ok了。
com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (52,886 ＞ 1,024).
任立伟的博客
05-08 581
这个原因就是mysql的max_allowed_packet设置过小 1.找到mysql安装位置 2.进图mysql 3.登录 4.查询当前配置 5.重新设置一下
com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large (10,892 > 1,024).
myme95的博客
04-04 8314
在做查询数据库操作时，报了以上错误，还有out of memery heap hacp ,原因是mysql的max_allowed_packet设置过小引起的， mysql根据配置文件会限制server接受的数据包大小。 有时候大的插入和更新会被max_allowed_packet 参数限制掉，导致失败。 1.进入mysql：mysql -uroot -p 2.查看当前配置信息：s...
解决com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large
日常笔记 | 干货分享 | 毕设源码 | 毕设指导 | 答辩指导
03-11 743
如果数据量太大，直接插入数据库，就会报这个错误。需要修改数据库可存数据的大小。
om.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large
gys9895的博客
04-22 779
om.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large
解决 com.mysql.cj.jdbc.exceptions.PacketTooBigException: Packet for query is too large
程序圆的博客
04-23 4421
前景概要 测试插入批量数据发送的sql语句太大。 //INSERT INTO `stress_test_table`(`id`, `name`, `age`, `sex`, `email`) VALUES //(NULL, 'name', age, sex, 'email'), .... ....... //(NULL...
评论 1
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值