Issue Got error 176 "Read page with wrong checksum" from storage engine Aria

[iForced]

Server operating system version

Windows Server 2022

Plesk version and microupdate number

18.0.61 Update #3

When upgrading mariadb:


Upgrading Plesk SQL server...
MSI: Error! Critical action 'Upgrade data of Plesk SQL Server...' failed:
Command "C:\Program Files (x86)\Plesk\admin\bin\mysqlmng_adm.exe" --upgrade-server-data failed with code 1. Output: Stop service...
Start service...
Upgrade only the system tables...
Restart service...
Execute C:\Program Files (x86)\Plesk\MySQL\bin\mysql_upgrade.exe "--defaults-file=\"D:\Program" Files "(x86)\Plesk\MySQL\my.ini --force --upgrade-system-tables --host=. --protocol=pipe --socket=d6f0e74e-5259-4aae-9647-dbdbca3605a0" failed[1]: The --upgrade-system-tables option was used, user tables won't be touched.
Phase 1/8: Checking and upgrading mysql database
Processing databases
mysql
mysql.column_stats OK
mysql.columns_priv OK
mysql.db OK
mysql.event OK
mysql.func OK
mysql.global_priv OK
mysql.gtid_slave_pos OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.index_stats OK
mysql.innodb_index_stats OK
mysql.innodb_table_stats OK
mysql.plugin OK
mysql.proc OK
mysql.procs_priv OK
mysql.proxies_priv OK
mysql.roles_mapping OK
mysql.servers OK
mysql.table_stats OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.transaction_registry OK
Phase 2/8: Installing used storage engines... Skipped
Phase 3/8: Running 'mysql_fix_privilege_tables'
ERROR 1030 (HY000) at line 35: Got error 176 "Read page with wrong checksum" from storage engine Aria
FATAL ERROR: Upgrade failed

at (execExtUtilChecked line 160)
at Launch mysql_upgrade(mysqlmng_adm::upgradeServerData line 411)
at (mysqlmng_adm::upgradeServerData line 436)
at Unable to execute console command: '--upgrade-server-data'(vconsoleapp::start line 95)
at Unable to execute command: '"C:\Program Files (x86)\Plesk\admin\bin\mysqlmng_adm.exe" --upgrade-server-data'(vconsoleapp::run line 117)

at (CmdAction::Commit line 389)
at Execute action Upgrade data of Plesk SQL Server...(executeList line 269)
Failed to install 'C:\ProgramData\Plesk\Installer\cache\pool\release\PLESK-WIN_18.0.61_14582\dist-windows\mariadb-admin.msi': Fatal error during installation. (Error code 1603)
Sub-action 'InstallMsiPackage' failed with error code: 1603(0x00000643)
Launching component and product checkers...
Downloading file pool/release/PLESK-WIN_18.0.61_14582/reportupdate.exe: 0%
Downloading file pool/release/PLESK-WIN_18.0.61_14582/reportupdate.exe: 100% was finished.

ERROR: The installation of the package 'mariadb-admin' failed with code 1603. (upgrade: Upgrading Plesk SQL server...)
Not all packages were installed.
Visit https://support.plesk.com/ to search for a solution.
exit status 1

 

[Kaspar@Plesk]

This usually is an indication that one or more tables are corrupted. You can try to run mysqlcheck.exe -uadmin -p -P8306 --auto-repair --check to repair any corrupted tables. Alternatively you can try repairing following the method(s) descripted in this Stackoverflow article: #1030 - Got error 176 "Read page with wrong checksum" from storage engine Aria