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

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

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

Error Upgrading MySQL 5.7 to 8.0

Relevant content