Symptoms
Plesk update fails with the following records in upgrade log:
MSI: Error! Critical action 'Upgrade data of Plesk SQL Server...' failed:
Command "C:Program Files (x86)ParallelsPleskadminbinmysqlmng_adm.exe" --upgrade-server-data failed with code 1. Output: Stop service...
Removing InnoDB log files...
Start service...
Restart service...
The process terminated unexpectedly. (Error code 1067) at Start service PleskSQLServer
at (service::startStopService line 997)
at Error occurred on starting PleskSQLServer service.
Errors in error log file:
2021-12-06 18:45:30 0 [ERROR] InnoDB: corrupted TRX_NO 801000004325c92
2021-12-06 18:45:30 0 [ERROR] InnoDB: Plugin initialization aborted with error Data structure corruption
2021-12-06 18:45:30 0 [ERROR] Plugin 'InnoDB' init function returned error.
2021-12-06 18:45:30 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2021-12-06 18:45:30 0 [ERROR] Unknown/unsupported storage engine: INNODB
2021-12-06 18:45:30 0 [ERROR] Aborting
....
ERROR: The installation of the package 'mariadb-admin' failed with code 1603. (upgrade: Upgrading Plesk SQL server...)
Cause
InnoDB corruption in Plesk SQL Server
Resolution
- Apply the steps for
PleskSQLserverservice from the article How to fix InnoDB corruption cases for the MySQL databases on Plesk for Windows? - Update Plesk once again
with