{"id":1952,"date":"2015-02-27T04:38:47","date_gmt":"2015-02-27T04:38:47","guid":{"rendered":"https:\/\/qbytes.cloud\/?p=1952"},"modified":"2015-02-27T04:38:47","modified_gmt":"2015-02-27T04:38:47","slug":"error-usrlibexecmysqld-sort-aborted","status":"publish","type":"post","link":"https:\/\/www.qbytes.cloud\/index.php\/2015\/02\/27\/error-usrlibexecmysqld-sort-aborted\/","title":{"rendered":"[ERROR] \/usr\/libexec\/mysqld: Sort aborted"},"content":{"rendered":"

Checking the log shows:<\/p>\n

\n\n# [ERROR] \/usr\/libexec\/mysqld: Sort aborted\n\n<\/pre>\n
Check the processlist on a plesk server:<\/p>\n
\n# mysqladmin -u admin -p`cat \/etc\/psa\/.psa.shadow` processlist\n<\/pre>\n
\n\n+---------+----------------+----------------------+----------------+---------+------+-------+------------------+\n| Id      | User           | Host                 | db             | Command | Time | State | Info             |\n+---------+----------------+----------------------+----------------+---------+------+-------+------------------+\n| 1926335 | user           | 108.xx.xx.xxx:17599  | databasename   | Update  | 0    | Locked| select * from..' |\n|         |                |                      |                |         | 0    |       |                  |\n+---------+----------------+----------------------+----------------+---------+------+-------+------------------+\n\n<\/pre>\n
Kill the process:<\/p>\n
\n# mysqladmin -u admin -p`cat \/etc\/psa\/.psa.shadow` kill [thread_id]\n<\/pre>\n
Create an index on the table<\/p>\n","protected":false},"excerpt":{"rendered":"
Checking the log shows: # [ERROR] \/usr\/libexec\/mysqld: Sort aborted Check the processlist on a plesk server: # mysqladmin -u admin -p`cat \/etc\/psa\/.psa.shadow` processlist +———+—————-+———————-+—————-+———+——+——-+——————+ | Id | User | Host | db | Command | Time | State | Info | +———+—————-+———————-+—————-+———+——+——-+——————+ | 1926335 | user | 108.xx.xx.xxx:17599 | databasename | Update | 0 | … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[70],"tags":[],"class_list":["post-1952","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/1952","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/comments?post=1952"}],"version-history":[{"count":0,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/posts\/1952\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/media?parent=1952"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/categories?post=1952"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.qbytes.cloud\/index.php\/wp-json\/wp\/v2\/tags?post=1952"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}