maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #06031
mysql_upgrade fails
-
To:
"maria-discuss@xxxxxxxxxxxxxxxxxxx" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
-
From:
Majed Zouhairy <majedzouhairy@xxxxxxxxxxx>
-
Date:
Wed, 21 Apr 2021 12:29:43 +0000
-
Accept-language:
en-US
-
Arc-authentication-results:
i=1; mx.microsoft.com 1; spf=none; dmarc=none; dkim=none; arc=none
-
Arc-message-signature:
i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=hYUd6u5oa9n+hmuFUDJFsBUkVJNYA5er+kzMuDtFiV4=; b=D4CU+EWg8ER2KDnD+3QWtaBgMOkBwOoSG/Wc/fLvSdhdIWZk7yddxs4D5ZEBnisXkKIGb9y/8GbCylBPDf1sENPTRyXk8d5lhE3Vya+yrgrJHH7jGdAJkNvrduzgbpfSUhzp5++p5xt5E0f4oV8zi3lo8z/drLZUvT73INAxaJRFsVOFjoxBJa4CXSOL3I4is5+TEw81PiePUBkXbwt5dla+maHH8MN92zyhgW7kITV6hVDZOeZKFF0RZPBLeAMKQEN7RwJpyYYUQ4Tq4ArHJeEGAv/uufHHppUoO3hWpbhgF6nyeE4CMIM4SenQgFOpAhbvwpCzIqbvp8z+Ggo9PA==
-
Arc-seal:
i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=ZrTcBvE9/STuD64BVOmcb8VrHYP8wrEkg1YwUa8l9eZtyl4VkfRThMmI3pugI8b9Pqrzk+VvZLcjkdel7+xrTqZeaE0+aRQUupfoHA1G1HXDvfp2FTY7t44It3JvNcihyX1JPr1a8sb4t1o++/cWZm7/kxhnQshUPEH0EtDxfLBMjZfCTYO2YC9DT3KkbxqE/aYxy/RyGnuFluMxoDzH2v7xyhkqNCXYgG5XZlAF/On5qfDM7mFWxdRZ9weodctmh7s5E0aqZM1WnMCnFnzst7bkTTKDtnpS02h0YJkLIWnC7TZrPW/1RpClybEGNk7SwzbLTsgX9uv6miC9/z7C3Q==
-
Thread-index:
AQHXNqnf/uuxD6kAw0Gy+X06d9RLEg==
-
Thread-topic:
mysql_upgrade fails
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?
Follow ups
