javascript python java c# php android html jquery c++ css ios mysql sql r node.js arrays reactjs c asp.net json ruby-on-rails .net sql-server swift python-3.x objective-c django angular angularjs excel regex pandas ruby iphone ajax linux xml vba asp.net-mvc spring laravel database wordpress typescript string wpf mongodb windows xcode postgresql bash oracle git vb.net amazon-web-services multithreading list firebase flutter eclipse spring-boot dataframe azure react-native algorithm docker macos forms image visual-studio scala powershell function twitter-bootstrap numpy api performance selenium winforms python-2.7 matlab vue.js sqlite apache hibernate entity-framework loops rest shell facebook express android-studio csv linq maven qt swing unit-testing file tensorflow

[ACCEPTED]-MySQL Error: Sort aborted-mysql

Accepted answer
Score: 22

There are at least a few known things to 2 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 1 your issue will be resolved.

Score: 0

Please check that you have enough free disk 2 space that MySQL can write to. 'Sort aborted' commonly 1 occurs when there is no disk space left.

Source: stackoverflow.com

More Related questions

Best way to archive live MySQL database

Foreign keys in MySQL?

Store GUID in MySQL from C#

MySQL backup and restore from command line

Creating your own TinyURL

What is the best way to bind decimal / double / float values with PDO in PHP?

Unique constraint that allows empty values in MySQL

Why I am getting Cannot pass parameter 2 by reference error when I am using bindParam with a constant value?

How do I view the warning(s) after a SELECT query using the MySQL command line?

MySQL remove duplicates from big database quick