My Oracle Support Banner

Sort aborted Error in MySQL Error Log (Doc ID 1331707.1)

Last updated on NOVEMBER 24, 2020

Applies to:

MySQL Server - Version 4.0 and later
Information in this document applies to any platform.

Symptoms

[ERROR] lines containing "Sort aborted" are present in the MySQL error log file.

  

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 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 shut down 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 temporary table was corrupt
 Processing of a subquery failed which was also sorting
 Wrong number of arguments for a function
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.