mysql - 添加 appcenter 应用程序时行大小太大 (> 8126) 异常

Question

我正在尝试在 Windows 8.1 上的 Websphere Liberty 服务器上部署适用于 iOS 的 worklight 应用程序中心。但是当我尝试通过 appcenter 控制台添加 IBMAppCenter.ipa 时，服务器日志中出现以下异常。

Caused by: org.apache.openjpa.lib.jdbc.ReportingSQLException: Row size too large (> 8126). Changing some columns to TEXT or BLOB may help. In current row format, BLOB prefix of 0 bytes is stored inline. {prepstmnt 1563792952 INSERT INTO APPLICATION_STORAGE (CONTENT, AP_FK) VALUES (?, ?) [params=(InputStream) java.io.ByteArrayInputStream@5987916, (null) null]} [code=1118, state=42000]

这里是重现我的问题的场景:

1. 通过 mysql 社区安装程序安装 mysql 5.6.2
2. 安装 Websphere Liberty 应用服务器 v8.5.5
3. 安装 Worklight Server v6.2
4. 通过 XCode 生成 IBMAppCenter.ipa
5. 登录appcenterconsole，尝试添加应用

我尝试按照 hjpotter92 在 Change limit for "Mysql Row size too large" 上的建议为表 APPLICATION_STORAGE 启用压缩但没有任何运气。任何帮助将不胜感激。

编辑

这是导致问题的 APPLICATION_STORAGE 表的定义:

CREATE TABLE APPLICATION_STORAGE (ID INTEGER NOT NULL AUTO_INCREMENT, CONTENT LONGBLOB, AP_FK INTEGER, PRIMARY KEY (ID)) ENGINE = innodb;

Answer 1

将 innodb_log_file_size 属性增加到 256M 解决了我的问题。显然，重做日志会覆盖大 blob 的最新检查点，如此处解释:http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-20.html

Important Change: Redo log writes for large, externally stored BLOB fields could overwrite the most recent checkpoint. The 5.6.20 patch limits the size of redo log BLOB writes to 10% of the redo log file size. The 5.7.5 patch addresses the bug without imposing a limitation. For MySQL 5.5, the bug remains a known limitation.

As a result of the redo log BLOB write limit introduced for MySQL 5.6, innodb_log_file_size should be set to a value greater than 10 times the largest BLOB data size found in the rows of your tables plus the length of other variable length fields (VARCHAR, VARBINARY, and TEXT type fields). Failing to do so could result in “Row size too large” errors. No action is required if your innodb_log_file_size setting is already sufficiently large or your tables contain no BLOB data. (Bug #16963396, Bug #19030353, Bug #69477)