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

RDS Table Corrupted with ERROR 1812 (HY000): Tablespace is missing for table the_database/table_name

0

After I changed a field name a table of my RDS MySQL DB stop being accessible and I tried everything (delete, update, modify, repair, rename, etc, etc, etc), I always get the message: "RDS Table Corrupted with ERROR 1812 (HY000): Tablespace is missing for table the_database/table_name". Because it's an RDS instance, I don't have access to file to fix the namespace.

Any idea how to fix it? I don't mind about the data on the table. I can delete it and recreate it, if RDS let me.

Topics
Database
Tags
Amazon RDS Database Preview EnvironmentMySQL
Language
English
asked 2 years ago550 views
1 Answer
0
Accepted Answer

Hello,

These kind of data inconsistency issues could happen with MySQL, You could try to rebuild the schema/database to resolve this issue(by doing dump and restore) or you could move to a new instance by performing Point in Time Restore before this issue, if you are not worried about delta post this issue on your instance.

Alternatively, you could reach out to AWS Support.

AWS
answered 2 years ago
  • xtrexpt
    2 years ago

    I restored to a previous checkpoint, then mix the 2 databases to minimize data loss. I decided not to give up to fix, delete, or do anything else to address the issue in the original database. Nevertheless, I accepted your answer; it's probably the only feasible way to handle this problem because we don't have access to RDS files. Thank you for your answer.

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.

Relevant content