Shulou(Shulou.com)06/01 Report--

In the morning, I found that there was an error in the mysql database errlog:

[ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress

#err-log Error exception found

~]$ sudo tail -f /data/mysql/data/DBanalysis02.err|grep -i error

2016-02-19 16:51:13 8769 [ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress

#But check mysql instance uptime and find that it has not been restarted, and there is no instance restart information in errlog

~]$ mysql -uroot -p -e "status"|grep time

Enter password:

Uptime: 160 days 12 hours 26 min 8 sec

#Database version 5.6.11

?~]$ mysql -V

mysql Ver 14.14 Distrib 5.6.11, for Linux (x86_64) using EditLine wrapper

~]$ mysql -uroot -p -e "select version()"

Enter password:

+------------+

| version() |

+------------+

| 5.6.11-log |

+------------+

#OS version

~]$ cat /etc/redhat-release

Red Hat Enterprise Linux Server release 6.1 (Santiago)

[ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress exception:

1. The instance was indeed restarted during query sorting, resulting in query interruption.

2. In the process of query execution sorting, the query session is terminated through the kill thread function.

So, try it in the test environment, as follows:

#Mysql version 5.6.11

In the SQL procedure with Using filesort operation, see the thread id of the SQL statement being executed in other sessions through processlist, use kill threaded operation to terminate the query, and display ERROR 2013 (HY000): Lost connection to MySQL server during query

At the same time, under errlog, it throws:

2016-03-23 14:09:32 2414 [ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress abnormal.

#Mysql 5.6.22 version repeat the above operation, errlog throw exception is:

And during the SQL execution of the Using filesystem operation, the errlog of restart mysql throws the same error.

Final Conclusions In some versions of Mysql

[ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress There are two possible ways to throw an exception:

1. The instance was indeed restarted during query sorting, resulting in query interruption.

2. In the process of query execution sorting, the query session is terminated through the kill thread function.

When this exception occurs, you can check the uptime and errlog information of mysql instance to determine whether mysqld has really crashed. If there is no crash (case 2), it is the exception information thrown by Mysql Bug, which can be ignored.

Reference:

https://www.percona.com/blog/2013/12/30/error-mysqld-sort-aborted-server-shutdown-in-progress/

http://bugs.mysql.com/bug.php? id=18256

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.