errno 144

[supun edirisinghe]

last night we had a really strange occurrance in our system.

we started seeing this error: Can't open file: 'Top5.MYI' (errno: 144)

Top5 is a table we used. I'm assuming this is a mysql index file. The error started happening about an hour after I rebuilt that table from a mysql dump file. And our system was down from that point on because we do a lot of queries off that table.

Since I was not sure what else to do, I dumped the table again from the same mysqldump file. And then poof, everything is working again.

My hypothesis is that there was a file system level problem when that file was piped in. And then rerunning it fixed it somehow. I'm just trying to brainstorm what could have possibly happened.

any ideas or experiences with an errno144 is appreciated.

thanks