Applicable to:
- Plesk for Linux
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
-
Connect to the target (destination) Plesk server via SSH.
- 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
-
-
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
-
-
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
[...] -
Save the changes and close the file.
-
Restart the MySQL service:
# service mysql restart || service mariadb restart
-
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.
Comments
0 comments
Please sign in to leave a comment.