Repair on merge table causes data loss

[Rene Vogt]

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.