首页 > 代码库 > MySQLSyntaxErrorException: Row size too large 转摘自：https://confluence.atlassian.com/display/CONFKB/MySQLSyntaxErrorException%3A+Row+size+too+large
MySQLSyntaxErrorException: Row size too large 转摘自：https://confluence.atlassian.com/display/CONFKB/MySQLSyntaxErrorException%3A+Row+size+too+large
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.
MySQLSyntaxErrorException: Row size too large 转摘自：https://confluence.atlassian.com/display/CONFKB/MySQLSyntaxErrorException%3A+Row+size+too+large
声明：以上内容来自用户投稿及互联网公开渠道收集整理发布，本网站不拥有所有权，未作人工编辑处理，也不承担相关法律责任，若内容有误或涉及侵权可进行投诉： 投诉/举报 工作人员会在5个工作日内联系你，一经查实，本站将立刻删除涉嫌侵权内容。