Upgrade to Plesk 11.5 fails with error: mysql-admin.msi: Fatal error during installation. (Error code 1603)

Created:

2016-11-16 13:13:05 UTC

Modified:

2016-12-21 20:12:58 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Upgrade to Plesk 11.5 fails with error: mysql-admin.msi: Fatal error during installation. (Error code 1603)

Symptoms

Upgrade to Plesk 11.5 fails with error:

MSI: Error! Service 'Plesk SQL Server' (PleskSQLServer) failed to start.  Verify that you have sufficient privileges to start system services.
Failed to install 'C:\\ParallelsInstaller\\parallels\\PANEL-WIN_11.5.30\\dist-msi-Microsoft-2003-i386\\mysql-admin.msi': Fatal error during installation. (Error code 1603)

ERROR: The installation of the package 'mysql' failed with code 1603. (upgrade: upgrading Parallels Panel SQL server...)
Not all packages were installed.
Please, contact product technical support.

The MySQL error log file C:\\Program Files (x86)\\Parallels\\Plesk\\MySQL\\Data\\<hostname>.err contains the following:

InnoDB: Error: log file .\\ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 10485760 bytes!

Cause

The reason is in MySQL config file changing. If custom value is specified for innodb_log_file_size parameter in "%plesk_dir%\\MySQL\\Data\\my.ini" like:

innodb_log_file_size=5M

Default valuse is 10Mb.

The problem is that autoinstaller cnahges the value of innodb_log_file_size to default 10 MB, however the logs are remained 5 MB. This conflict prevents MySQL service from starting and upgrade fails. After it is failed, the configuration file are being rolled back and then MySQL service can be started.

The issue is confirmed as a bug #PPPM-1646 .

Resolution

To prevent the issue you should:

  1. Move INNODB logs ( ib_logfile0 and ib_logfile1 ) from "%plesk_dir%\\MySQL\\Data\\

  2. Open "%plesk_dir%\\MySQL\\Data\\my.ini" , and set the parameter:

    innodb_log_file_size=10M
  3. Restart MySQL service.

NOTE : You should set the parameter exactly 10 MB size so that it will not be changed by autoinstaller, and no conflict will happen.

Have more questions? Submit a request
Please sign in to leave a comment.