mysql.host table preventing upgrade from Aurora mysql 5.7 to 8

Hello,

Is it failing due to "its failing because a table mysql.host exists." or "its failing because a table mysql.host do not exists."

In the Aurora MySQL upgrade prechecks

• There must be no InnoDB metadata inconsistency in the mysql.host table.

can you confirm the error message as following

"id": "checkTableOutput", "title": "Issues reported by 'check table x for upgrade' command", "status": "OK", "detectedProblems": [ { "level": "Error", "dbObject": "mysql.host", "description": "Table 'mysql.host' doesn't exist" } ] },

With master user please try this

mysql> use mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A

Database changed

• mysql> show tables like 'host'; +------------------------+ | Tables_in_mysql (host) | +------------------------+ | host | +------------------------+ 1 row in set (0.26 sec)

• mysql> describe host;

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquiries in repost/aws guide..

Hello,

Yes, the 'mysql.host' is causing the issue, during the checkTableOutput pre-check it is failing and will not upgrade , although you can create BG with same version but during upgrade it will fail again .

As you do not have access to mysql and storage , I'll suggest of you reach out to AWS support to work on this table or precheck mitigation so this precheck can pass .

Another option you may try , i haven't tested as i do not have any cluster with this issue , (but please test and take a snapshot of present cluster)

1. Upgrade is failing due to the presence of 'mysql.host' table in the Aurora clusters.

2. Try to clone the cluster , and check the mysql.host table

3. i expect the clone should not have this table , and try to upgrade the clone .

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquiries in repost/aws guide..