Error when upgrading Aurora MySQL from v2 (5.7) to v3 (8.0)

0

When I try to upgrade Aurora MySQL 5.7 to Aurora MySQL 8.0, I got this pre-check error

{ "id":"routinesSyntaxCheck", "title":"MySQL 8.0 syntax check for routine-like objects", "status":"OK", "description":"The following objects did not pass a syntax check with the latest MySQL 8.0 grammar. A common reason is that they reference names that conflict with new reserved keywords. You must update these routine definitions and quote any such references before upgrading.", "documentationLink":"https://dev.mysql.com/doc/refman/en/keywords.html", "detectedProblems":[ { "level":"Error", "dbObject":"mysql.flush_rewrite_rules", "description":"at line 5,8: unexpected token 'QUERY'" } ] }

The routine is owned by rdsadmin, so I cannot touch it. What can I do? When I did a test at the end of May, the upgrade worked perfectly

asked 10 months ago2093 views
1 Answer
1

Perhaps the same thing is happening with the following.
I think the solution is to contact AWS support as follows and have the mysql.flush_rewrite_rules procedure removed by the AWS RDS development team.
https://repost.aws/questions/QU_jfgd2gURk6TzL8JcQCO9Q/error-upgrading-mysql-5-7-to-8-0#ANLOZpV0AWQcusXooIc62zEQ

Update: I reached out to AWS Support and they mentioned that the mysql.flush_rewrite_rules procedure had to be dropped by the internal AWS RDS development team. I had them drop the procedure and was able to upgrade the database successfully after that.

profile picture
EXPERT
answered 10 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions