首页 新闻 会员 周边

mysql max_allowed_packet 报错,老是包超出内存错误,但是如果把这个值改成固定值,可能还会出现超出这个值的请求,所以有没有哪个大神指导为什么发送请求的值会这么大啊?

0
悬赏园豆:10 [已关闭问题] 关闭于 2017-01-03 09:53

org.springframework.dao.TransientDataAccessResourceException:
### Error updating database. Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1681 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### Cause: com.mysql.jdbc.PacketTooBigException: Packet for query is too large (1681 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
; SQL []; Packet for query is too large (1681 > 1024). 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 (1681 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.

凯伦的主页 凯伦 | 初学一级 | 园豆:186
提问于:2016-12-12 15:55
< >
分享
所有回答(2)
0

你做更新或插入等语句一次发送的太多了吧

2012 | 园豆:21230 (高人七级) | 2016-12-13 08:22
0

好奇葩的问题

凯伦 | 园豆:186 (初学一级) | 2017-01-03 09:51
清除回答草稿
   您需要登录以后才能回答,未注册用户请先注册