首页 > 数据库技术 > 详细

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

时间:2014-10-16 12:01:53      阅读:1533      评论:0      收藏:0      [点我收藏+]

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

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

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!