Applicable to:
- Plesk for Linux
- Plesk for Windows
Symptoms
-
The following error appears during a migration pre-check on the target server:
CONFIG_TEXT: In InnoDB 5.6 (both in MySQL 5.6 and MariaDB 10.0/10.1) server has variable innodb_strict_mode=0 by default.
So you can create table with wrong ROW_FORMAT option and warning will be reported.
In InnoDB 5.7 (both in MySQL 5.7 and MariaDB 10.2) server has variable innodb_strict_mode=1 by default.
Migration from source, hosted with previous version of InnoDB will not be possible to target
with current version of InnoDB and error will be issued if innodb_strict_mode is set to default.
Set variable innodb_strict_mode to OFF on target to avoid the migration errors.
Here is the link describing the problem
https://jira.mariadb.org/browse/MDEV-11305
Here is a list of affected subscriptions:
- example.com
Cause
Strict mode is enabled on the newer versions of MySQL/MariaDB by default.
Resolution
Note: Once the migration will finish, it is safe to enable back the innodb_strict_mode option in Plesk Obsidian.
-
Connect to the target server via SSH.
-
Add innodb_strict_mode to MySQL configuration:
2.1. Open MySQL configuration file/etc/my.cnf
in a text editor, for example, in the vi editor:CONFIG_TEXT: vi /etc/my.cnf
Note: For Debian/Ubuntu the path is /etc/mysql/my.cnf
2.2. Add innodb_strict_mode=OFF
under the [mysqld] section:
CONFIG_TEXT: [mysqld]
innodb_strict_mode=OFF
<...>
2.3. Save the changes and close the file.
- Restart MySQL service:
# service mysql restart || service mariadb restart || service mysqld restart
- Proceed with the migration.
- Connect to the target server via RDP.
- Open MySQL configuration file
%plesk_dir%Databases\MySQL\my.ini
in a text editor.
2.1 Addinnodb_strict_mode=OFF
under the [mysqld] section:CONFIG_TEXT: [mysqld]
innodb_strict_mode=OFF
<...>2.3. Save the changes and close the file
-
Restart MySQL service via Plesk Services Monitor (it can be found in the system tray).
-
Proceed with the migration
Comments
2 comments
Thanks! It helps me a lot.
For Linux
Some comment for - 2.2. Add innodb_strict_mode=OFF under the [mysqld] section
To edit text, you need to enter the insert mode by pressing i key. Go back to normal mode by pressing Esc key again.
Some comment for - 2.3. Save the changes and close the file.
To save the changes and close the file Press the ESC key ---> Type :wq ---> Press the ENTER key
Exit without saving changes Press the ESC key ---> Type :q! ---> Press the ENTER key
Eriks Bass Hello Erik,
Thank you for sharing the details. We have this information mentioned in our article How to edit a file using the vi utility
I made sure to add a link to this article in the resolution for Linux.
Please sign in to leave a comment.