MySQLSyntaxErrorException: Row size too large 转摘自:https://confluence.atlassian.com/display/CONFKB/MySQLSyntaxErrorException%3A+Row+size+too+large
2024-09-03 19:29:40
Symptoms
The following appears in the atlassian-confluence.log
:
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. |
Cause 1:
This is caused by the maximum allowed packet size of the MySQL server being too small.
Cause 2:
The InnoDB Log File is too small, and must be increased.
Resolution 1:
Change the packet size configuration setting this to 64MB or larger.
http://dev.mysql.com/doc/refman/5.0/en/packet-too-large.html
Resolution 2:
In your my.ini
(or my.cnf
) file, add or modify the following line:
innodb_log_file_size=256M |
You may wish to adjust this value larger or higher depending on your specific installation. After making this change, restart Confluence and MySQL.
最新文章
- Js循环读取JSON数据
- IOS和Android支持的音频编解码
- <;构建之法>;3-5章感想
- NeHe OpenGL教程 第三十二课:拾取游戏
- 《linux下sudo服务的使用》RHEL6
- Storm系列(十三)架构分析之Worker-维护ZMQ连接
- SharePoint Designer cannot open site error "; the server could not complete your request";
- 无线通信技术协议-Zigbee 3.0
- cf446C DZY Loves Fibonacci Numbers
- php采集文章中的图片获取替换到本地
- ubuntu12.04下一个samba、tftp、nfs构造
- C#:继承多态的方法实现数的简单加减乘除运算
- 正则表达式——Java程序员懂你
- CSRF跨站
- Apache的安装与配置
- 12.vue属性.监听.组件
- 从swap说引用
- Struts局部异常与全局异常处理
- nginx的访问控制
- Parallax Mapping