log event entry exceeded max_allowed_packet
来源:互联网 发布:越南教科书知乎 编辑:程序博客网 时间:2024/06/07 22:24
现象:
[ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master', Error_code: 1236
[Note] Slave I/O thread exiting, read up to log 'mysql-bin.000012', position 7985
解决办法:
1.分别在Master和slave上增加max_allowed_packet
Master:
mysql> select @@global.max_allowed_packet/1024/1024 MB;
+-------------+
| MB |
+-------------+
| 16.00000000 |
+-------------+
1 row in set (0.00 sec)
mysql>set @@global.max_allowed_packet=32*1024*1024;
mysql> select @@global.max_allowed_packet/1024/1024 MB;
+-------------+
| MB |
+-------------+
| 32.00000000 |
+-------------+
1 row in set (0.00 sec)
Slave:
mysql>stop slve;
mysql>set @@global.max_allowed_packet=32*1024*1024;
mysql>start slave;
2.分别在Master和slave的my.cnf中设置max_allowed_packet
max_allowed_packet = 32M
[ERROR] Slave I/O: Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master', Error_code: 1236
[Note] Slave I/O thread exiting, read up to log 'mysql-bin.000012', position 7985
解决办法:
1.分别在Master和slave上增加max_allowed_packet
Master:
mysql> select @@global.max_allowed_packet/1024/1024 MB;
+-------------+
| MB |
+-------------+
| 16.00000000 |
+-------------+
1 row in set (0.00 sec)
mysql>set @@global.max_allowed_packet=32*1024*1024;
mysql> select @@global.max_allowed_packet/1024/1024 MB;
+-------------+
| MB |
+-------------+
| 32.00000000 |
+-------------+
1 row in set (0.00 sec)
Slave:
mysql>stop slve;
mysql>set @@global.max_allowed_packet=32*1024*1024;
mysql>start slave;
2.分别在Master和slave的my.cnf中设置max_allowed_packet
max_allowed_packet = 32M
0 0
- log event entry exceeded max_allowed_packet
- log event entry exceeded max_allowed_packet
- Error_code: 1236 log event entry exceeded max_allowed_packet 错误解决办法
- 处理 Could not parse relay log event entry
- Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are
- Last_Error: Relay log read failure: Could not parse relay log event entry.
- sql error:Last_Error: Relay log read failure: Could not parse relay log event entry. The possible re
- 【event】tx:allocate ITL entry
- max_allowed_packet
- max_allowed_packet
- max_allowed_packet
- windows service event log
- IoWriteErrorLogEntry生成Event Log
- event-log-tags
- android event log含义
- Android event log 说明
- Android 的 Event Log
- How to dump redo log entry?
- 数据库的基本操作
- 连接池 druid(阿里巴巴的框架)
- SVN使用教程
- html5中table标签
- PS 滤镜— —Twirl Filter
- log event entry exceeded max_allowed_packet
- iOS APP上传iTunes Store 时,报错 An error occurred uploading to the iTunes Store!
- unity 3D炫酷开场动画
- 【金阳光测试独家播出】公益视频讲座:WEB自动化测试预告-7月11日更新第一集
- POJ 2192 && HDU 1501 Zipper (记忆化搜索)
- 【暑假集训专题#搜索 HDU1241】
- TCP/IP协议
- Linux修改/etc/profile配置错误command is not found自救方法
- zjwqorygdtbcxy