I understand upgrade failed when upgrading from Amazon Aurora DB Cluster version MySQL 5.7 to MySQL 8.
From the upgrade-prechecks.log, I believe you are seeing the below error message which indicate that there are some keywords present which are not supported in version 8.0.
Error: The following routines contain keywords like 'QUERY CACHE', 'GROUP BY' with 'ASC' or 'DESC', 'SQL_CACHE', 'SQL_NO_CACHE' which are not supported in major version 8.0. It is recommended to drop these routines or rebuild routines without any of the above keywords before upgrade.",
Based on your findings and from my investigation, it seems the keyword is also reading from objects such as the stored procedure (e.g update_fcdescription()) which have the keyword DESC present in the stored procedure name.
Therefore, please note that I will escalate this behavior internally so that it can be investigated and rectified to avoid same issue from occurring in future. If further investigation is required on your DB Cluster, I would advise creating a support case.
Thank you for bringing this information to our attention. Your feedback is always appreciated.
Thank you for writing back. I understand you want to know when the in-pace upgrade from 5.7 to 8.0 will be available.
Please note that I have no ETA for when an in-place upgrade from Aurora MySQL version 5.7 to 8.0 will be available. However, I would recommend that you refer to the links below for feature releases and latest announcement. Once in-place upgrade is implemented, information will be announced in the links below :
[-] What's New with Database? - https://aws.amazon.com/about-aws/whats-new/database/?whats-new-content.sort-by=item.additionalFields.postDateTime&whats-new-content.sort-order=desc&awsf.whats-new-products=*all
[-] Category: Amazon RDS - https://aws.amazon.com/blogs/aws/category/database/amazon-rds/
Additionally, please note that I have no ETA for when the issue with the keywords during upgrade would be fixed. However, since you have a case created for this issue, I would recommend that you continue to address the issue via the case you have created.
Aurora MySQL Upgrade From 2.10.1 to 3.01.0 (MySQL 5.7 to 8) failingasked 7 months ago
Minimize the downtime of Aurora mysql engine Upgrade.asked 22 days ago
Aurora MySQL Upgrade From 2.10.1 to 3.01.0 (MySQL 5.7 to 8) Failingasked 7 months ago
Aurora 3 MySQL / The value of the `partial_revokes` parameter in the parameter group is different from the value of the same variable in MySQLasked a month ago
Need help in upgrading the aurora MYSQL 5.7 to MYSQL 8 [URGENT]asked 8 months ago
Migrate MySQL 8 to Aurora MySQL 8asked 5 months ago
Aurora upgrade 2 to 3 / MySql 5.7 to 8.0: potential bug in pre-check validationasked 5 months ago
How to debug In-place upgrade of the engine to the new target version 8.0.mysql_aurora.3.01.0 is not supported.asked 6 months ago
Aurora upgrade 2 to 3 / MySql 5.7 to 8.0: potential bug in pre-check validation (depreciated words)asked 2 months ago
MySQL upgrade to version 5.7asked 3 years ago