com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1146177 > 1048576).

最新推荐文章于 2022-08-11 22:12:13 发布
最新推荐文章于 2022-08-11 22:12:13 发布
阅读量455 收藏
点赞数
分类专栏： 数据库
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/chengyuqiang/article/details/89061392
版权 
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.TransientDataAccessResourceException: 
### Error updating database.  Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1146177 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
### The error may exist in cn/hadron/doc/dao/FileDao.java (best guess)
### The error may involve cn.hadron.doc.dao.FileDao.saveFile-Inline
### The error occurred while setting parameters
### SQL: insert into files(fileName,fileSize,fileDir,category,content,md5) values(?,?,?,?,?,?)
### Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1146177 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
; Packet for query is too large (1146177 > 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 (1146177 > 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:110)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:81)
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy58.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:278)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:59)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:58)
	at com.sun.proxy.$Proxy63.saveFile(Unknown Source)
	at cn.hadron.doc.service.impl.FileServiceImpl.saveFile(FileServiceImpl.java:29)
	at cn.hadron.doc.controller.FileController.upload(FileController.java:90)
	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:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:189)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:800)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1038)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:200)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:490)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:408)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:834)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1415)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1146177 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.
	at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3683)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2512)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
	at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1242)
	at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44)
	at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:47)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:74)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:198)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:185)
	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:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:433)
	... 61 more

查看默认的max_allowed_packet值，1M

MariaDB [(none)]>  show variables like 'max_allowed_packet';
+--------------------+---------+
| Variable_name      | Value   |
+--------------------+---------+
| max_allowed_packet | 1048576 |
+--------------------+---------+
1 row in set (0.04 sec)

MariaDB [(none)]>

解决办法，增大该参数为10M

MariaDB [(none)]>  set global max_allowed_packet = 1024*1024*20;
Query OK, 0 rows affected (0.03 sec)

MariaDB [(none)]>
程裕强
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
【问题解决：Mysql操作容量限制问题】Error updating database. Cause: com.mysql.jdbc.PacketTooBigException: Packet fo...
weixin_34270606的博客
02-11 1880
在做查询数据库操作时，报了以上错误，还有out of memery heap hacp ,原因是mysql的max_allowed_packet设置过小引起的，我一开始设置的是1M，后来改为了20M   mysql根据配置文件会限制server接受的数据包大小。 有时候大的插入和更新会被max_allowed_packet 参数限制掉，导致失败。查看目前配置 show VARIABLE...
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驱动...
PacketTooBigException异常捕获及解决方法
LOVE_sel的博客
05-13 3477
PacketTooBigException异常捕获 一、背景 在连接数据库过程中，爆出如下错误。 原因是：提交的sql信息超过了设置max_allowed_packet参数太小。 举个例子：往数据库中插入text文本，数据库最大允许提交16M的sql,结果你提交了32M； 或者执行的sql条数太多； org.springframework.dao.TransientDataAccessResourceException: ### Error updating database. Cause: com.m
【MySQL】com.mysql.jdbc.PacketTooBigException 异常解决
Horace's Blog
05-03 453
问题 　　由于公司的业务需要，需要博主将之前爬虫爬取的数据进行导出成文件并打包加密成压缩包，同时在文件接收端进行文件解密解析和数据的入库，中间涉及到ftp传输。 　　整个流程图如下（粗略画下）： 　　 　　由于数据量比较大，所以每个Excel文件限制1W条数据，每5个Excel执行一次打包操作，定时执行。 　　前面过程一切正常执行，然而当数据进行分表入库的时候，这里执行了批量插入，控制台...
mysql 中com.mysql.jdbc.PacketTooBigException 解决办法
edgar_t的博客
12-09 520
问题：com.mysql.jdbc.PacketTooBigException: Packet for query is too large (23588610 > 20971520). You can change this value on the server by setting the max_allowed_packet’ variable. 原因: 一次性插入的数据超过了mysql 默认的server接收的数据包大小，因此需要调整mysql 默认的server接收的数据包大小。 My
com.mysql.jdbc.PacketTooBigException: Packet for query is too large 异常解决办法
pingweicheng的博客
06-06 6472
com.mysql.jdbc.PacketTooBigException: Packet for query is too large 异常解决办法：原因： 查询出的数据包过大，默认情况下mysql 的字段容量不够装，所以抛出此异常解决办法：1、首先通过SQLyog客户端查询框输入以下命令，也可以在cmd命令行窗口下登录mysql后输入以下命令：SHOW VARIABLES LIKE '%max_...
Mysql报错Packet for query is too large问题解决
12-14
今天在往mysql中插入数据时遇到的问题，翻译过来的意思是：查询数据包太大 建议修改max_allowed_packet参数值。 针对我执行的插入操作来说，意味着一次性执行的sql语句太大，超过了mysql默认设置的值（我用的是...
MySQL Packet for query is too large 问题及解决方法
01-21
Caused by: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1354 > 1024). You can change this value on the server  by setting the max_allowed_packet’ variable  MySQL根据配置...
解决Cause com.mysql.jdbc.exceptions.jdbc4.CommunicationsException
11-09
Cause com.mysql.jdbc.exceptions.jdbc4.CommunicationsException The last packet successfully received from the server was 47,795,922 milliseconds ago. The last packet sent successfully to the server was...
MySQL异常：com.mysql.jdbc.PacketTooBigException: Packet for query is too large
qq_43159578的博客
09-24 1420
### Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1169 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.; SQL []; Packet for query is too large (1169 > 1024). You can change th
com.mysql.jdbc.PacketTooBigException: Packet for query is too large
好好学java
01-23 776
一、异常信息 com.mysql.jdbc.PacketTooBigException: Packet for query is too large 二、原因 查询出的数据包过大，默认情况下mysql 的字段容量不够装，所以抛出此异常 三、解决办法 第一步： 首先通过SQLyog客户端查询框输入以下命令，也可以在cmd命令行窗口下登录mysql后输入以下命令：SHOW VARIABLES LI...
Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large ..max_ allowed_ packet
yuguang的博客
04-29 551
1、报错内容 Error querying database. Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1804 > 1024)_ You can change this value on the server by setting the max_ allowed...
com.mysql.jdbc.PacketTooBigException: 解决方案
最新发布
OldDriverSkr的博客
08-11 423
PacketTooBigException
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1086 > 1024).
u013068184的博客
08-11 431
报错：com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1086 > 1024). You can change this value on the server by setting the max_allowed_packet’ variable. 原因是mysql的max_allowed_pack...
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (11707239 > 1048576). You can c
IT小生
04-08 3209
com.mysql.jdbc.PacketTooBigException: Packet for query is too large (11707239 > 1048576). You can change this value 原因是查询数据包太大，需要手动修改mysql的配置，找到mysql安装根目录下的my.ini文件 找到元素[mysqld] 在下方增加一行 max
mysql PacketTooBigException 的处理方式
Saindy5828的专栏
08-11 3695
在本地上运行好好,然后发布到服务器上去, 总是报错,后来查了一下日志,得到了如下的错误日志: [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] Packet for query is too large (1079 > 1024). You can change this value on the server by setting the
No mapping for the Unicode charactor exists in the target multi-byte code page解决办法
TanMengyi的博客
11-02 1528
遇到的问题： No mapping for the Unicode charactor exists in the target multi-byte code page; 解决：nginx的安装目录中不能出现中文，将中文的文件夹名改成英文就可以了 其他： nginx的下载、安装、启动 1、nginx下载地址： http://nginx.org/en/download.html 我选择的是windows的稳定版本，可以视情况自己选择： 2、下载后解压，可以直接运行nginx.exe运行，也可以运行cmd
nginx启动报错(1113: No mapping for the Unicode character exists in the target multi-byte code page)
DemoTransfer
09-29 4253
使用windows版本的nginx启动时遇到如下错误: 2018/09/29 00:02:32 [emerg] 10300#8644: CreateFile() “./conf/…/center_proxy/centerProxy - 副本.conf” failed (1113: No mapping for the Unicode character exists in the target ...
CASthesis 模板编译的问题
weixin_34390105的博客
04-01 1964
使用CASthesis模板(https://github.com/xiaoyao9933/UCASthesis，介绍里说这个版本是在ThuThesis的基础上修改的)，自带的说明如下。 使用须知 ======== 1. 本模板需使用texlive 2014或以上版本编译。 2. 确定系统中存在xfig，transfig依赖(Mac OSX 系统可尝试通过port进行安装)。 3. 确...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值