RDS mysql 5.6 to 5.7 upgrade facing issue


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)

1 Answer
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.

answered 2 years ago
profile picture
reviewed 3 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