MyISAM :: Error: Incorrect key file for table try to repair it

[gabriele cicala]

Hi everybody ...

During these days we have a strange problem. Without any reason and also randomly one of our table become crashed.
No trace on the daemon log or any other and obviously this problem cause replication stopped.
Usually we do a REPAIR TABLE operation but the table become crashed randomly after few time.
Actually we don't have any solution to check and clarify what is the problem.

Did you have any suggestion??

We are using this MySQL Server version:

5.0.32-7etch11

And these are the data of the tables where we encounter this error:

1.
Data 25.944 KiB
Index 61.349 KiB
Rows 737.973

2.
DatA 6.309 KiB
Index 8.635 KiB
Rows 236.589

I hope to hear from you any idea. Thank you.


Best Regards.
Gabriele Cicala