- Newest
- Most votes
- Most comments
Hello,
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.
Hello,
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.
Thank you.
Relevant content
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 3 years ago
Thank you. I had already created a support case with much of the information presented here. I would point out that even in block comments the character combination of "desc" is also considered an error if the stored procedure has a "GROUP BY" anywhere in the stored procedure.
I look forward to the resolution as I'm sure countless people are.
On a side note, any idea when in-place upgrades (5.7 to 8) will happen?
Thanks again.