MySQL Packet for query is too large


500, Server error. 糟糕,服务器异常,您可以点击这里 返回首页或刷新页面重试! Error:服务运行异常, ### Error querying database. Cause: com.mysql.jdbc.PacketTooBigException:
Packet
for query is too large (8208 > 1024). You can change this value on the server by setting the max_allowed_packet' variable.
### The error may exist in file [D:\szkj\newproject\ruichi\target\classes\com\vacomall\mapper\xml\SysMenuMapper.xml]
### The error may involve defaultParameterMap ### The error occurred while setting parameters ###
SQL: SELECT id,menuName,pid,url,icon,sort,deep,code,`resource` FROM sys_menu WHERE (pid = ? AND id IN

参考博客:http://blog.csdn.net/linhaiguo/article/details/50763104

show VARIABLES like '%max_allowed_packet%';

set global max_allowed_packet = 1*1024*10

 

posted @ 2017-09-11 10:44  个子  阅读(496)  评论(0编辑  收藏  举报