Error: Unable to execute mysql_upgrade
Fast & stable Nginx MariaDB Redis Php 8 development stack for Windows
Status: Abandoned
Brought to you by:
wtriple
Whenever I launch WinNmp (20.05), I get the following error:
[ ERROR ] Unable to execute mysql_upgrade ERROR 1030 (HY000) at line 110: Got error 176 "Read page with wrong checksum" from storage engine Aria ERROR 1030 (HY000) at line 464: Got error 176 "Read page with wrong checksum" from storage engine Aria FATAL ERROR: Upgrade failed
Nothing in the logs or FAQ appears to give any advice on how to correct these errors.
I then tried executing the same upgrade command from the command prompt:
"c:\winnmp\bin\mariadb\bin\mysql_upgrade.exe" --defaults-file="c:\winnmp\conf\mysql.ini" --force
In this case, I got the same result, but also some additional information as to what was happening:
Phase 1/7: 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/7: Installing used storage engines... Skipped Phase 3/7: Fixing views mysql.user OK Phase 4/7: Running 'mysql_fix_privilege_tables' ERROR 1030 (HY000) at line 110: Got error 176 "Read page with wrong checksum" from storage engine Aria ERROR 1030 (HY000) at line 464: Got error 176 "Read page with wrong checksum" from storage engine Aria FATAL ERROR: Upgrade failed PS C:\WinNmp>
Can you please offer some guidance on how to upgrade my database without errors?
Many thanks in advance.
- Scott
Anonymous
Not a bug.
MySql database table
mysql.users
is corrupted, you need to delete the whole database folder, so it will be re-created.