Packet for query is too large
来源:互联网 发布:seo课程大纲 编辑:程序博客网 时间:2024/04/29 23:59
错误环境:activemq原本用文本文件存储队列中数据,当在activemq中改为用mysql中存储数据时,当向某队列中传输数据量过大,会报以下错误:
错误现象:org.springframework.jms.UncategorizedJmsException: Uncategorized exception occured during JMS processing; nested exception is javax.jms.JMSException: Packet for query is too large (2491451 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable
解决办法:MySQL的一个系统参数:max_allowed_packet,其默认值为1048576(1M),
查询:show VARIABLES like '%max_allowed_packet%';
修改此变量的值:MySQL安装目录下的my.ini文件中的[mysqld]段中的"max_allowed_packet = 1M",如更改为4M(如果没有这行内容,增加一行),保存,重起MySQL服务。现在可以load大于1M的文件了
- MYSQL Packet for query is too large
- Packet for query is too large
- MYSQL Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- MySQL Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- 【解决】Packet for query is too large
- Packet for query is too large
- Packet for query is too large
- Packet for query is too large (mysql)
- PacketTooBigException: Packet for query is too large
- Packet for query is too large(Packet>1048576)
- Packet for query is too large(mysql写入数据过大)
- ISO8583包简介和源代码
- Android开发(一) Hello Android
- JBOSS 集群配置
- Fermat小定理的证明(摘自Matrix67大牛的blog)
- 数组
- Packet for query is too large
- HTTP协议——请求格式及方法
- Adroid源码下载备忘录
- 申请Google map API
- 删除逻辑驱动器后的数据恢复操作方法(CYD原创教程)
- HTTP协议——通信机制
- Pinyin4J 实现前台搜索框智能提示效果
- Linux下安装配置MemCached(以及libevent)
- HttpClient基础