Skip navigation links

MySQL Forums :: Merge Storage Engine :: New merge table issue with underlying table


Advanced Search

New merge table issue with underlying table
Posted by: Rob Brown ()
Date: April 09, 2013 05:16AM

I have inherited a database running on 5.0.96 with some merge tables that are showing errors when trying to upgrade to 5.1.67

Even when trying to drop the existing merge table and recreate it, I still get the same errors with the underlying tables, which appear to be fine...

mysql> repair table foo_20070101;
+------------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+------------------------+--------+----------+----------+
| s123.r2_click_20070101 | repair | status | OK |
+------------------------+--------+----------+----------+
1 row in set (40.35 sec)

Hence, this table is healthy.


CREATE TABLE foo_20070131 LIKE foo_20070101;

ALTER TABLE foo_20070131 DROP PRIMARY KEY, ADD KEY (click_id);

ALTER TABLE foo_20070131 ENGINE=MERGE;

ALTER TABLE foo_20070131 UNION=(foo_20070101);

ERROR 1168 (HY000): Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist.

Is there anything more I can do to investigate the issue, or to try and "fix" the apparently-fine underlying table?

Thanks,
Rob

Options: ReplyQuote


Subject Views Written By Posted
New merge table issue with underlying table 1456 Rob Brown 04/09/2013 05:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.