Invalid query: Incorrect key file for table [closed]

It's difficult to tell what is being asked 开发者_运维百科here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center. Closed 11 years ago.

There is couple of these already. My question though is how can something like this happen? is it cause by a bug in my code or is it an apache related problem?

Invalid query: Incorrect key file for table '/tmpfs/#sql_8e2_1.MYI'; try to repair it

---

Which version of mysql are you running? Are there open bugs which could cause this problem with the version you're running? Did the server lose power or crash?

Consider using the repair table syntax:

http://dev.mysql.com/doc/refman/5.1/en/repair-table.html

Please note all the warnings about making backups before running this.