MySQLSyntaxErrorException: Row size too large 转摘自:https://confluence.atlassian.com/display/CONFKB/MySQLSyntaxErrorException%3A+Row+size+too+large
时间:2022-03-14 01:06
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.
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.