Procedure for getting mysql.flush_rewrite_rules removed

0

We're beginning the process of upgrading all of our RDS MySQL 5.7 instances to MySQL 8. As part of doing this, we've run in an issue where these databases all have a stored procedure defined, mysql.flush_rewrite_rules, that uses syntax incompatible with MySQL 8. Because it's in the mysql schema, I know we didn't put it there. It appears that in order to be able to upgrade these databases, the procedure in question needs to be dropped (or rewritten, but in our case dropped is fine). However, as these procedures are in the mysql schema, we can't drop them ourselves. I've seen from other re:Post questions that other people have been able to get the RDS internals team to drop the offending procedures for them, however, we're not able to open a technical support case on our support plan, so I'm not sure how we're supposed to proceed at this point.

2개 답변
0

In this specific scenario, I would recommend to open a support case under Basic support plan itself under "Account & Billing" inquiries, further it can be analyzed on use case basis if this can be further troubleshooted by the technical team.

Hope it helps and if it does, I would appreciate if answer can be accepted so that community can benefit for clarity when searching for similar enquirers in Repost, thank you ;)

AWS
답변함 8달 전
0

Here are a few things you can try to resolve the preupgrade check failure:

  • Review the upgradeFailure.log file closely to understand the specific error messages. This will help identify the root cause.
  • Check if the error is related to any database objects like stored procedures that may be incompatible with MySQL 8.0. You may need to drop or modify such objects before upgrading.
  • Take a backup of the database, restore to a test instance and run preupgrade checks there to isolate issues. Drop/recreate incompatible objects and test upgrade.
  • Open an AWS Support case. For RDS instances, support engineers may be able to further investigate internal issues and help resolve the failure.
  • As a last resort, try performing a DB snapshot and creating a new instance from the snapshot to get a clean state. Then attempt the upgrade.
profile picture
전문가
답변함 7달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠