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.