Plesk upgrade fail: mysqlcheck.exe: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... FOR UPGRADE'

Created:

2016-11-16 12:55:36 UTC

Modified:

2017-08-08 13:17:18 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk upgrade fail: mysqlcheck.exe: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... FOR UPGRADE'

Applicable to:

  • Plesk for Windows

Symptoms

Plesk upgrade fails with:

Failed to install 'C:\\ParallelsInstaller\\parallels\\PANEL-WIN_12.0.18\\dist-msi-Microsoft-2003-i386\\mysql-server-configurator.msi': Fatal error during installation. (Error code 1603)
Error: The installation of the package 'mysql-server-configurator' failed with code 1603. (upgrade: update configuration of MySQL server...)
Not all packages were installed.

Additionally C:\\ParallelsInstaller\\autoinstaller3.log file contains the following information:

...
update configuration of MySQL server...
MSI: Error! Critical action 'Upgrading MySQL Server system database...' failed:
Command "C:\\Parallels\\Plesk\\admin\\bin\\mysqlmng.exe" --upgrade-local-service failed with code 1.
Output:
Starting MySQL server...
Upgrading MySQL server data...
Execute C:\\Parallels\\Plesk\\Databases\\MySQL51\\bin\\mysql_upgrade.exe --force --user=local_mysql_root --password=XXXXXXXXXX failed[1]: Looking for 'mysql.exe' as: C:\\Parallels\\
Plesk\\Databases\\MySQL51\\bin\\mysql.exe
Looking for 'mysqlcheck.exe' as: C:\\Parallels\\Plesk\\Databases\\MySQL51\\bin\\mysqlcheck.exe
Running 'mysqlcheck with default connection arguments
Running 'mysqlcheck with default connection arguments
C:\\Parallels\\Plesk\\Databases\\MySQL51\\bin\\mysqlcheck.exe: Got error: 2013: Lost connection to MySQL server during query when executing 'CHECK TABLE ... FOR UPGRADE'
FATAL ERROR: Upgrade failed
DATABASE_NAME.TABLE_NAME OK

Cause

Database corruption

Resolution

To locate a corrupted table try to check database table next to reported in alphabetical order with mysqlcheck . As soon as corrupted table was located try to fix it with mysql REPAIR TABLE or contact system administrator to fix the issue.

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