MySQL Forums
Forum List  »  MyISAM

'Incorrect key file for table ...' caused crash
Posted by: Dimitri Beckers
Date: March 11, 2009 01:39AM

Hi,

One morning our mysqlserver got out of disk space (yeah I know, pretty stupid).
All queries got locked and I don't even know what our db-administrater did to solve the problem.

But, in the logs of my application I noticed the following error (this occurred immediately when the server started up):
'Incorrect key file for table article. try to repair it'
On other tables, there were also errors:
'x client(s) is/are using or hasn't closed the table properly'

Nobody noticed the problems in the logs, and 14 hours later, this article-table crashed so no queries could get executed.
'Table article is marked as crashed and should be repaired'.

I can only guess that the incorrect key file caused the table to crash. But how's that possible? And, is this the cause of the crash? Can queries make a table crash and whys that?

Thank you for your reply!

Options: ReplyQuote


Subject
Views
Written By
Posted
'Incorrect key file for table ...' caused crash
4260
March 11, 2009 01:39AM


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.