The size of BLOB/TEXT data inserted in one transaction is greater than 10 percent of the redo log size
Symptoms
Usually this error is shown in the log generated by the text extraction process.
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size. Increase the redo log size using innodb_log_file_sizeCause
Only OpenKM installations using MySQL or MariaDB databases might be affected by this issue. The reason is that the total data size exceeds the MySQL or MariaDB redo log configuration.
Solution
- Stop MySQL or MariaDB.
- Increase the innodb_log_file_size value, for example, innodb_log_file_size=512M.
- Start MySQL or MariaDB.
For MariaDB, the file to be modified is /etc/mysql/mariadb.conf.d/50-server.conf under the InnoDB commented section.
Properties
| Properties | |
|---|---|
|
Date |
2018-09-03 |
|
Applies to |
|
Keywords
- AllVersions