RDS mysql 5.6 to 5.7 upgrade facing issue

Question

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)

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.

RDS mysql 5.6 to 5.7 upgrade facing issue

相關內容