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 <[email protected]> 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 : [email protected] > Unsubscribe : https://launchpad.net/~maria-discuss > More help : https://help.launchpad.net/ListHelp >
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
