sort aborted 에러 발생시 해결법

에러 로그에 보면 sort aborted 에러가 찍히는 경우가 있습니다

그땐 아래의 내용을 점검해 보면 해결 되는 경우가 많습니다

There is at least few known things to cause this message:

• Insufficient disk space in tmpdir prevented tmpfile from being 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 wait timeout or deadlock.
• Unexpected errors, such as source table or even tmp table was corrupt.
• Processing of a subquery failed which was also sorting.

Check these, and I bet your issue will be resolved.