Plesk Migrator shows warning: The size of BLOB/TEXT data inserted in one transaction is greater than 10% of redo log size

Symptoms

The following error message is shown in Plesk Migrator after subscription migration:

CONFIG_TEXT: Failed to copy content of database 'db_example'
<...>
stdout: 
stderr: ERROR 1118 (42000) at line 421: 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

Database was not migrated due to insufficient limit for the innodb_log_file_size parameter in MySQL configuration.

Resolution

1. Connect to the target (destination) Plesk server via SSH.

2. Create a backup of the MySQL configuration file my.cnf:

   • On CentOS/RHEL-based distributions:

     # cp -a /etc/my.cnf /etc/my.cnf.back

   • On Debian/Ubuntu-based distributions:

     # cp -a /etc/mysql/my.cnf /etc/mysql/my.cnf.back

3. Open the original my.cnf file in any text editor. In this example, we are using the vi editor:

   • On CentOS/RHEL-based distributions:

     # vi /etc/my.cnf

   • On Debian/Ubuntu-based distributions:

     # vi /etc/mysql/my.cnf

4. Increase the limit of the innodb_log_file_size parameter (or set it anew if it does not exist) under the [mysqld] section:

   CONFIG_TEXT: [mysqld]
   innodb_log_file_size=50M
   [...]

5. Save the changes and close the file.

6. Restart the MySQL service:

   # service mysql restart || service mariadb restart

7. Re-sync the subscription in Plesk Migrator at Tools & Settings > Migration & Transfer Manager > select the current migration and click Re-sync next to the subscription in question.

   Note: If the issue remains, increase the innodb_log_file_size limit to a greater value.