By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

RDS mysql 5.6 to 5.7 upgrade facing issue

0

when we are trying RDS MySQL 5.6 to 5.7 upgrade facing issue: "MySQL 5.7 preupgrade check to catch orphan table issue, datadir or frm file was removed or corrupted"
Please help me what to do for this issue ? and how to delete this frm file (we do not have access for directory)

Topics
Migration & ModernizationAnalyticsDatabase
Tags
Amazon Relational Database ServiceDatabaseSQL Migrations
Language
English
AWS-User-9400660
asked 3 years ago685 views
1 Answer
0
Accepted Answer

It looks like some or one of the regular or temp tables in the databases are orphaned. Meaning, they exist in the data dictionary but do not have respective files on the storage. This is what I am assuming at this point.

Best bet would be to reach out AWS Support so that they can fix it for you.

AWS
D-Rao
answered 3 years ago
profile picture
EXPERT
Giovanni Lauria
reviewed a year 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

Relevant content