MySQL Forums
Forum List  »  Merge Storage Engine

Repair on merge table causes data loss
Posted by: Rene Vogt
Date: May 06, 2007 05:53AM

I have a merge table that contains about 25 sub-tables. Each contains about half a million entries. In general this works great.
However today I detected that if I do a repair on one of the 25 sub-tables while someone else is doing a select on the main merge table the repair fails with status code 13. And all the data in the corresponding sub-table are lost. (the MYD-file is missing and there is a 0 byte TMD file) Subsequent repairs to this table fails with the message File '.\dbname\tablename.MYD' not found (Errcode: 2)

Subsequent select queries on the merge table gives the following error message:
ERROR 144 (HY000): Table '.\dbname\tablename' is marked as crashed and
last (automatic?) repair failed

Anybody else with this problem? Is there a workaround to prevent this from happening?

This is reproducible and only happens if I make a select query on the merge table while repairing.
Tested against mysql 5.0.37 on windows 2003 server.

Edited 1 time(s). Last edit at 05/06/2007 06:12AM by Rene Vogt.

Options: ReplyQuote

Written By
Repair on merge table causes data loss
May 06, 2007 05:53AM

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.