There are at least a few known things tocause this message:
· Insufficient disk space in tmpdir prevented tmpfile frombeing created.
· Insufficient memory for sort_buffer_size to be allocated.
· Somebody ran KILL in the middle of a filesort.
· The server was shutdown while some queries were sorting.
· A transaction got rolled back or aborted due to lock waittimeout or deadlock.
· Unexpected errors, such as source table or even tmp tablewas corrupt.
· Processing of a subquery failed which was also sorting.
参考自:http://stackoverflow.com/questions/5165112/mysql-error-sort-aborted