maria-discuss team mailing list archive

[Vicențiu Ciorbaru <cvicentiu@xxxxxxxxx>]

Hi Majed,

What MariaDB version is this? What is the previous version and what is the
current version you are upgrading to?

Is this from a linux distro, or where did you get the MariaDB binary from?
If it's a distro, which one?

Vicențiu

On Wed, 21 Apr 2021 at 15:31, Majed Zouhairy <majedzouhairy@xxxxxxxxxxx>
wrote:

> in last time's upgrade and today i got:
> sudo mysql_upgrade -u root -p
> Enter password:
> 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.help_category                                OK
> mysql.help_keyword                                 OK
> mysql.help_relation                                OK
> mysql.help_topic                                   OK
> mysql.host                                         OK
> mysql.index_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.user                                         OK
> Phase 2/7: Installing used storage engines... Skipped
> Phase 3/7: Fixing views
> Phase 4/7: Running 'mysql_fix_privilege_tables'
> ERROR 1813 (HY000) at line 77: Tablespace for table
> '`mysql`.`innodb_table_stats`' exists. Please DISCARD the tablespace before
> IMPORT
> ERROR 1813 (HY000) at line 81: Tablespace for table
> '`mysql`.`innodb_index_stats`' exists. Please DISCARD the tablespace before
> IMPORT
> ERROR 1813 (HY000) at line 85: Tablespace for table
> '`mysql`.`transaction_registry`' exists. Please DISCARD the tablespace
> before IMPORT
> ERROR 1813 (HY000) at line 153: Tablespace for table
> '`mysql`.`gtid_slave_pos`' exists. Please DISCARD the tablespace before
> IMPORT
> ERROR 1146 (42S02) at line 642: Table 'mysql.innodb_index_stats' doesn't
> exist
> ERROR 1243 (HY000) at line 643: Unknown prepared statement handler (stmt)
> given to EXECUTE
> ERROR 1146 (42S02) at line 645: Table 'mysql.innodb_table_stats' doesn't
> exist
> ERROR 1243 (HY000) at line 646: Unknown prepared statement handler (stmt)
> given to EXECUTE
> ERROR 1146 (42S02) at line 650: Table 'mysql.innodb_index_stats' doesn't
> exist
> ERROR 1146 (42S02) at line 654: Table 'mysql.innodb_table_stats' doesn't
> exist
> ERROR 1146 (42S02) at line 657: Table 'mysql.innodb_table_stats' doesn't
> exist
> FATAL ERROR: Upgrade failed
>
> what to do?
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>