MySQLSyntaxErrorException: Row size too large 转摘自:https://confluence.atlassian.com/display/CONFKB/MySQLSyntaxErrorException%3A+Row+size+too+large

时间:2014-10-16 12:01:53   收藏:0   阅读:1532

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.

 

原文:http://www.cnblogs.com/prettyisshit/p/4028226.html

评论(0
© 2014 bubuko.com 版权所有 - 联系我们:wmxa8@hotmail.com
打开技术之扣,分享程序人生!