【MySQL报错】 Packets larger than max_allowed_packet are not allowed

VertigozZ 2016-12-27 08:57:22

版本信息如下：

报错的信息如下：

说来奇怪，不会立马报错，一半就是插入数据时，隔上几个小时就会报这个错误，然后重启mysql服务之后，又好了，然后过上几个小时又这样了，感觉和sql没啥关系，好像是什么缓存池什么满了一样。

max_allowed_packet 原来是16MB的现在设置到了512MB，并且已经生效，然并卵，解决不了问题

...全文

676 11 打赏收藏转发到动态举报

写回复

11 条回复

切换为时间正序

请发表友善的回复…

发表回复

burningLuo_ 2017-12-22

打赏
举报

回复

你好，请问你的问题解决了吗？我现在跟你遇到一摸一样的问题了，伤不起。。。。

VertigozZ 2016-12-27

打赏
举报

回复

引用 7 楼 wangjian0228 的回复:

Qcache 最好关掉，没什么用，如果还有问题可以监控一下max_allowed_packet 这个值是否会自动变化，记得以前有个帖子说是被攻击后重置参数导致的

怎么监控这个值呢？？

致命的西瓜 2016-12-27

打赏
举报

回复

Qcache 最好关掉，没什么用，如果还有问题可以监控一下max_allowed_packet 这个值是否会自动变化，记得以前有个帖子说是被攻击后重置参数导致的

VertigozZ 2016-12-27

打赏
举报

回复

难道是这个影响的？？？

VertigozZ 2016-12-27

打赏
举报

回复

引用 4 楼 wangjian0228 的回复:

直接改配置文件，在my.ini里添加max_allowed_packet = 20M的参数

昨天就是直接添加的 max_allowed_packet = 512M 的操作但还是报这个错误

致命的西瓜 2016-12-27

打赏
举报

回复

直接改配置文件，在my.ini里添加max_allowed_packet = 20M的参数

VertigozZ 2016-12-27

打赏
举报

回复

不存在自动恢复的问题，这个还是我昨天改的512MB

VertigozZ 2016-12-27

打赏
举报

回复

引用 1 楼 zjcxc 的回复:

出错的时候这个值是不是被调整了，这个是可以即时调整的

不是立马出错，是会隔上几个小时然后报这个错误。期间一直在进行一些插入数据的操作，仅此而已

zjcxc 2016-12-27

打赏
举报

回复

出错的时候这个值是不是被调整了，这个是可以即时调整的

VertigozZ 2016-12-27

打赏
举报

回复

引用 9 楼 ACMAIN_CHM 的回复:

打开普通日志，看一下是不是程序端发送了过大的语句。

敢问版主在哪里查看普通日志？？？

ACMAIN_CHM 2016-12-27

打赏
举报

回复

打开普通日志，看一下是不是程序端发送了过大的语句。

{ datetime.inc}{ version.inc}const helplines=120;helpdata:array[1..helplines] of pchar=(‘RealMedia Analyzer, Version ‘+Version+‘ build ‘+_DATETIME_,‘Copyleft (C) 2000-2003 Virtual Research‘,‘‘,‘Usage: rma [command] ‘,‘‘,‘Command must start with a hyphen.‘,‘All commands and arguments are case-sensitive.‘,‘Available commands are:‘,‘‘,‘ -c[arguments] = check file integrity (default)‘,‘ arguments:‘,‘ d = set maximum allowed timestamp difference to n (0..32767)‘,‘ milliseconds, 0 means don‘‘t care, default is 2000‘,‘ s = set maximum allowed packet size to n (1..32767) kilobytes,‘,‘ default is don‘‘t care‘,‘ t = disable timestamps checking‘,‘ v = lower verbosity level (disable packets counter)‘,‘ z = stop on timestamp errors‘,‘‘,‘ -f[arguments] = try to fix broken file‘,‘ arguments:‘,‘ a = exclude n (0..64) packets after first found intact packet‘,‘ (but not more than the number used with ‘‘c‘‘ argument),‘,‘ default is 0‘,‘ b = exclude n (0..64) packets before last intact packet, default is 0‘,‘ c = use minimal size of n (2..32767) packets chain when searching for‘,‘ unbroken stream parts, default is 4‘,‘ d = set maximum allowed timestamp difference to n (0..32767)‘,‘ milliseconds, 0 means don‘‘t care, default is 2000‘,‘ m[suppresion level] = suppress logging, 1 means do not update log,‘,‘ 2 means mark only, 3 means suppress completely (default)‘,‘ n = only fix n (1..32767) broken packets, default is all‘,‘ p = force maximum packet size (intact packet criterion) to‘,‘ n (16..32767) bytes, default is take from header‘,‘ s = set maximum allowed packet size (broken packet criterion) to‘,‘ n (1..32767) kilobytes, default is don‘‘t care‘,‘ t = disable timestamps checking‘,‘ v = lower verbosity level (disable packets counter)‘,‘ z = try to fix timestamp errors‘,{ __UNIX__}‘ undo filename = create an undo file with the specified pathname‘,{}‘ /undo filename/ = create an undo file with the specified pathname‘,{}‘‘,‘ -d[argument] = dump some information about the file‘,‘ arguments (mutually exclusive):‘,‘ b = dump brief information about the file‘,‘ g = dump general information (default)‘,‘ l = display operations log only‘,‘ i = dump file index‘,‘‘,‘ -i[arguments] = rebuild index sections‘,‘ arguments:‘,‘ a = index all keyframe packets‘,‘ m[suppression level] = suppress logging‘,‘ v = lower verbosity level (disable packets counter)‘,‘‘,‘ -j[arguments] = join (multiplex) two RealMedia streams‘,‘ arguments:‘,{ __UNIX__}‘ firstfilename = pathname of the file containing first stream,‘,‘ default is stream00.rm‘,‘ secondfilename = pathname of the file containing second stream,‘,‘ default is stream01.rm‘,{}‘ /firstfilename/ = pathname of the file containing first stream,‘,‘ default is stream00.rm‘,‘ /secondfilename/ = pathname of the file containing second stream,‘,‘ default is stream01.rm‘,{}‘ i = build index after join‘,‘ m[suppression level] = suppress logging‘,‘ o = write old-style file header‘,‘ p = paste instead of multiplex‘,‘ s = try to synchronize streams‘,‘ q[l] = set relative stream 0 to stream 1 skew in milliseconds‘,‘ (0..10000, signed). ql means set logical skew,‘,‘ otherwise set physical skew‘,‘ v = lower verbosity level (disable packets counter)‘,‘‘,‘ -l = strip operations log and RealMedia Analyzer mark, if any‘,‘‘,‘ -p = display RealMedia Analyzer use and (re)distribution policy‘,‘‘,‘ -s[arguments] = split (demultiplex) stream‘,‘ arguments:‘,‘ m[suppression level] = suppress logging‘,‘ o = write old-style file header‘,{ __UNIX__}‘ p = use specified drive/directory for output files‘,‘ (default is current directory)‘,{}‘ p = use specified drive/directory for output files‘,‘ (default is current directory)‘,{}‘ x = extract n‘‘th stream from the file‘,‘ v = lower verbosity level (disable packets counter)‘,‘‘,‘ -u[arguments] = discard changes according to specified undo file‘,‘ (in this case, is the undo file pathname)‘,‘ arguments:‘,‘ m[suppression level] = suppress logging‘,‘‘,‘ -x[arguments] = extract part of stream‘,‘ (this command only works with the single-stream files)‘,‘ arguments:‘,‘ / (default is 00:00:00.00)‘,‘ (default is end of stream)‘,‘ d = delete part of stream instead of extract‘,‘ k = ignore keyframes‘,‘ m[suppression level] = suppress logging‘,‘ o = write old-style file header‘,{ __UNIX__}‘ p = use specified drive/directory for output file‘,‘ (default is current directory)‘,{}‘ p = use specified drive/directory for output file‘,‘ (default is current directory)‘,{}‘ t = ignore timestamps‘,‘‘,‘examples:‘,‘‘,‘ rma test.rm‘,‘ check integrity of test.rm‘,‘‘,‘ rma -f test.rm‘,‘ try to fix errors in test.rm with default settings‘,‘‘,‘ rma -fb2n1 test.rm‘,‘ try to fix errors in test.rm, seek two packets back‘,‘ when broken packet is found, only fix first broken packet‘,‘‘,‘ rma -sx1 test.rm‘,‘ extract stream 1 from test.rm‘,‘‘,{ __UNIX__}‘ rma -jaudio.rmvideo.rm test.rm‘,{}‘ rma -j/audio.rm//video.rm/ test.rm‘,{}‘ join streams from audio.rm and video.rm and write‘,‘ multiplexed stream to test.rm.‘,‘‘);

MySQL报错packets larger than max_allowed_packet are not allowed MySQL报错packets larger than max_allowed_packet are not allowed MySQL根据配置文件会限制Server接受的数据包大小。有时候大的插入和更新会受 max_allowed_packet 参数限制,导致写入或者更新失败修复方法： 1.修改配置文件my.ini max_allowed_packet = 10M 2.使用命令修改

今天使用mysql数据库存储数据发现报错：Packets larger than max_allowed_packet are not allowed.windows操作如下打开mysql CMD窗口输入命名： show VARIABLES like '%max_allowed_packet%'; 查看接收数据包大小我的是4M 如果过小请通过命令修改 set global ...

在导大容量数据特别是CLOB数据时，可能会出现异常：“Packets larger than max_allowed_packet are not allowed”。这是由于MySQL数据库有一个系统参数max_allowed_packet，其默认值为1048576(1M) 可以通过如下语句在数据库中查询其值： show VARIABLES like '%max_allowed_packe...

通常通过MySQL的"load data local infile"语句将一个文本文件中的内容导入到数据库中，这样速度会很快，但今天发现如果文本的大小超过1M时，出现异常：“Packets larger than max_allowed_packet are not allowed” MySQL的一个系统参数：max_allowed_packet，其默认值为1048576(

56,864

社区成员

56,753

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章