Plesk

Plesk update fails: InnoDB: corrupted TRX_NO 801000004325c92

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

  1. Apply the steps for PleskSQLserver service from the article How to fix InnoDB corruption cases for the MySQL databases on Plesk for Windows? 
  2. Update Plesk once again
Exit mobile version