Menu

#29 Error: Unable to execute mysql_upgrade

wont-fix
nobody
None
True
2020-12-18
2020-06-10
Anonymous
No

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

2 Attachments

Discussion

  • WTriple

    WTriple - 2020-12-18
    • status: open --> wont-fix
     
  • WTriple

    WTriple - 2020-12-18

    Not a bug.
    MySql database table mysql.users is corrupted, you need to delete the whole database folder, so it will be re-created.

     

Anonymous
Anonymous

Add attachments
Cancel





Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.