Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.16
-
None
Description
One partition of a very large partitioned table suffered corruption by a corrupted primary key index page.
Selecting data from the other partitions is still possible, but only a few rows out of the range of the affected partition can be read.
As data for that specific partition can still be re-imported the plan was to drop and re-create the partition, but any attempt to do DML on the table now end with "table does not exist in engine"
We tried:
- DROP PARTITION to get rid of the partition
- ALTER TABLE REPLACE PARTITION WITH TABLE both for the bad partition and the good ones
- FLUSH TABLES ... FOR EXPORT to then be able to move "good" tablespace files over to a new partitioned table one by one
but every time it fails with "table does not exist in engine"