Skip to content

MySQL: what shall be repaired?

A website shows the following error message:

SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_1898_0.MYI'; try to repair it

So, MySQL: which table is to repair? The error message is not a table, it's just the temp file.

Stupid and useless error message ...

  • Twitter
  • Bookmark MySQL: what shall be repaired? at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg MySQL: what shall be repaired?
  • Bloglines MySQL: what shall be repaired?
  • Technorati MySQL: what shall be repaired?
  • Fark this: MySQL: what shall be repaired?
  • Bookmark MySQL: what shall be repaired? at YahooMyWeb
  • Bookmark MySQL: what shall be repaired? at Furl.net
  • Bookmark MySQL: what shall be repaired? at reddit.com
  • Bookmark MySQL: what shall be repaired? at blinklist.com
  • Bookmark MySQL: what shall be repaired? at Spurl.net
  • Bookmark MySQL: what shall be repaired? at Simpy.com
  • Bookmark MySQL: what shall be repaired? at blogmarks
  • Bookmark MySQL: what shall be repaired? with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca

MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)

If you run MySQL and this error occurs:

 SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/MYh0VgDS' (Errcode: 28)

then check if your server isn't using the famous "overflow" filesystem for /tmp, limited to 1 MB space.

The MySQL error message is - as usual - misleading and non-descriptive.

There are many other possible causes for this error code, so this one here might just be a hint.

  • Twitter
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at del.icio.us
  • Facebook
  • Google Bookmarks
  • FriendFeed
  • Digg MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)
  • Bloglines MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)
  • Technorati MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)
  • Fark this: MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28)
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at YahooMyWeb
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at Furl.net
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at reddit.com
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at blinklist.com
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at Spurl.net
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at Simpy.com
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) at blogmarks
  • Bookmark MySQL: SQLSTATE[HY000]: General error: 3 Error writing file '/tmp/xyz' (Errcode: 28) with wists
  • wong it!
  • Bookmark using any bookmark manager!
  • Stumble It!
  • Identi.ca