Error Upgrading MySQL 5.7 to 8.0

Question

I am upgrading from AWS 2.11.2 to 3.03.1 in order to upgrade our database from MySQL 5.7 to 8.0.26.

On running the upgrade, I am getting the error below:
`        {
            "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 mysql database cannot be modified. How can I get around this issue to upgrade the database from 5.7 to 8.0.26?

Accepted Answer

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.

Answer

I'm facing the same issue. Do I really have to purchase a support plan to continue?

Answer

what is the impact of  dropping the "mysql.flush_rewrite_rules" stored procedure

Answer

Hi RDS internal team, I am also facing with this issue. Can you help to drop the procedure for us as well? Thanks!

Answer

We're having the same issue, but unsure how to do this without having to purchase the support plan?

Error Upgrading MySQL 5.7 to 8.0

Relevant content