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!
The reason is in MySQL config file changing. If custom value is specified for innodb_log_file_size parameter in
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.
To prevent the issue you should:
Move INNODB logs (
"%plesk_dir%\MySQL\Data\my.ini", and set the parameter:
- 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.