The size of BLOBTEXT data inserted in one transaction is greater than 10 percent of redo log size

Symptons

Usually this error is shown in the log raised by 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_size

Cause

Only OpenKM with MySQL or MariaDB databases might be affected by this issue. The reason is the total amount of data size is higher than MySQL or MariaDB redo log configuration.

Solution

• Stop MySQL or MariaDB.
• Increase the innodb_log_file_size value, por example innodb_log_file_size=512M.
• Start MySQL or MariaDB.

Properties

Keywords