Plesk upgrade failed: The installation of the package 'mysql56-server-configurator' failed with code 1603

Created:

2016-11-16 13:24:23 UTC

Modified:

2017-04-24 11:21:37 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk upgrade failed: The installation of the package 'mysql56-server-configurator' failed with code 1603

Applicable to:

  • Plesk for Windows

Symptoms

  • Upgrade fails:

    FATAL ERROR: Upgrade failed

    at (execExtUtilChecked line 135)
    at execute console command --upgrade-local-service(vconsoleapp::start line 100)
    at execute "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\mysqlmng.exe" --upgrade-local-service(vconsoleapp::run line 117)
    at (execPleskUtil line 104)
    at Execute C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\mysqlmng.exe --upgrade-local-service(execPleskUtil line 109)
    at doSetPackage(mysqlserver, mysql56)(VPackageManager::doSetPackage line 419)
    at setDefault(mysqlserver, mysql56)(VPackageManager::setDefault line 362)
    at (VPackageManager::setDefault line 381)
    at execute console command --set(vconsoleapp::start line 100)
    at execute "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\defpackagemng.exe" --set "--type=mysqlserver" "--default=mysql56"(vconsoleapp::run line 117)
    at (CmdAction::Commit line 415)
    at Execute action Updating MySQL Server component...(executeList line 293)
    Failed to install 'C:\\ParallelsInstaller\\parallels\\PANEL-WIN_12.5.30\\dist-msi-Microsoft-2003-i386\\mysql56-server-configurator.msi': Fatal error during installation. (Error code 1603)
    ERROR: The installation of the package 'mysql56-server-configurator' failed with code 1603. (install: configuring MySQL 5.6 server...)
    Not all packages were installed.
  • Manual execution of mysqlmng.exe fails:

    "%plesk_bin%"\\mysqlmng.exe --upgrade-local-service
    The system cannot find the file specified. (Error code 2) at RegOpenKeyEx subKey=SOFTWARE\\MySQL AB\\MySQL Server 0.0
    at (registry::open line 49)
    at execute console command --upgrade-local-service(vconsoleapp::start line 100)
    at execute mysqlmng.exe --upgrade-local-service(vconsoleapp::run line 117)
  • Manual execution of defpackagemng.exe :

    "%plesk_bin%"\\defpackagemng.exe --set "--type=mysqlserver" "--default=mysql56"
    The package MySQL 5.1 Server was not installed.
    at (VPackageManager::doSetPackage line 405)
    at doSetPackage(mysqlserver, mysql51)(VPackageManager::doSetPackage line 419)
    at Package rollback to default mysql51(VPackageManager::setDefault line 379)
    The package MySQL 5.6 Server was not installed.
    at (VPackageManager::doSetPackage line 405)
    at doSetPackage(mysqlserver, mysql56)(VPackageManager::doSetPackage line 419)
    at setDefault(mysqlserver, mysql56)(VPackageManager::setDefault line 362)
    at (VPackageManager::setDefault line 381)
    at execute console command --set(vconsoleapp::start line 100)
    at execute "C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\bin\\defpackagemng.exe" --set "--type=mysqlserver" "--default=mysql56"(vconsoleapp::run line 117)

Cause

One of customer's database is corrupted.

Resolution

  • Execute mysqlchek.exe to find out the database corruption:
    mysqlcheck -A -uadmin -p -P3306

If it fails with error like:

    database_name   
Got error: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`com`' at line 1 when executing 'CHECK TABLE ... '
  • Dump corrupted database and temporary remove it:

    "%plesk_dir%"\\mysql\\bin>mysqldump -uadmin -p -P3306 database_name > c:/database_name.sql
  • Complete the upgrade:

    "%plesk_bin%"\\ai.exe --console
  • Restore database to upgraded Plesk and repair it further:

    "%plesk_dir%"\\mysql\\bin>mysql -uadmin -p -P3306 database_name < c:/database_name.sql
Have more questions? Submit a request
Please sign in to leave a comment.