Got error 28 from table handler

[irc]

A query that has seem to work fine for some time suddenly pooped out on me. I'm getting the error:

Got error 28 from table handler

Anyone know what this means?

[Scott MacVicar]

F:\mysql\bin>perror 28
Error code 28: No space left on device

[irc]

Why might it affect one query, but not all queries to a table or database?

[eva2000]

i'd check your disk space or mysql partition for free space as well as if any one single file on a linux system has hit the linux 2GB or 4GB file size limit (i.e. log files etc)

[eva2000]

Why might it affect one query, but not all queries to a table or database?
so queries create temporary tables on disk

i generally like to have at least twice the amount of free space available as your largest mysql database table size