mysqld: Sort aborted: Server shutdown in progress
上午發現mysql資料庫errlog裡面有報錯:
[ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress
相關如下
#err-log發現有ERROR異常
~]$ 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
#但是檢視mysql例項uptime發現並沒有重啟過,而且errlog裡面也看不到例項restart的資訊
~]$ mysql -uroot -p -e "status"|grep time
Enter password:
Uptime: 160 days 12 hours 26 min 8 sec
# 資料庫版本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版本
~]$ cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.1 (Santiago)
說明
查閱相關錯誤資料,發現這是Mysql的bug,在之前某些版本中有下面2種情況會丟擲[ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress異常:
1、在查詢執行排序的過程中例項確實進行了重啟,導致查詢中斷。
2、在查詢執行排序的過程中,透過 kill thread功能終止了查詢的會話。
於是,在測試環境試了一把,如下:
#Mysql 5.6.11版本下
在執行有Using filesort操作的SQL過程中,在別的會話透過processlist看到正在執行的SQL語句的thread id,使用kill threaded 操作終止查詢,在執行查詢的語句下面會顯示:ERROR 2013 (HY000): Lost connection to MySQL server during query
同時,在errlog下則丟擲了:
2016-03-23 14:09:32 2414 [ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress 異常。
#Mysql 5.6.22版本下
重複上面的操作,errlog丟擲的異常是:
並且 在Using filesort操作SQL執行的過程中,restart mysql的errlog也是丟擲同樣的錯誤。
最終結論
在某些Mysql版本中
[ERROR] /usr/sbin/mysqld: Sort aborted: Server shutdown in progress可能有2種情況丟擲異常:
1、在查詢執行排序的過程中例項確實進行了重啟,導致查詢中斷。
2、在查詢執行排序的過程中,透過 kill thread功能終止了查詢的會話。
當出現此異常時,可以檢視mysql例項的uptime和errlog等資訊來確定mysqld是否真的crash過,如果沒有crash(第2種情況),則是Mysql的Bug導致丟擲的異常資訊,可以忽略。
參考:
https://www.percona.com/blog/2013/12/30/error-mysqld-sort-aborted-server-shutdown-in-progress/
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/27000195/viewspace-2062549/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Server shutdown in progressServer
- ORA-01089: immediate shutdown in progress - no operations are permittedMIT
- ORA-01033: ORACLE initialization or shutdown in progress錯誤Oracle
- ora-01033:oracle initialization or shutdown in progress 解決方法Oracle
- OGG OCI Error ORA-01089: immediate shutdown in progressError
- DG配置錯誤:ORA-01033: ORACLE initialization or shutdown in progressOracle
- ORA-01033:ORACLE initialization or shutdown in progress錯誤解決Oracle
- MYSQL The Server Shutdown Process(筆記)MySqlServer筆記
- ORA-01033: ORACLE initialization or shutdown in progress 實用的處理方法Oracle
- Error:ORA-01033:ORACLE initialization or shutdown in progress錯誤解決(轉)ErrorOracle
- mysqld_safe和mysqldMySql
- mysqld和mysqld_safeMySql
- mysqld與mysqld_safeMySql
- R session AbortedSession
- ERROR 2002 (HY000): Can't connect server socket /var/run/mysqld/mysqld.sockErrorServerMySql
- tidb Error: Operation aborted by user answer '' (cliutil.operation_aborted)TiDBError
- Slave: received 0 length packet from server, apparent master shutdownServerAPPAST
- Starting MySQL * Couldn't find MySQL server (/usr/bin/mysqld_safe)MySqlServer
- Out of sort memory, consider increasing server sort buffer size的兩種情況IDEServer
- mysqld --verboseMySql
- Progress語法
- MySQL報錯Slave: received end packet from server, apparent master shutdownMySqlServerAPPAST
- HTML <progress> 進度條HTML
- [Angular] Progress HTTP Events with 'HttpRequest'AngularHTTP
- Oracle shutdown and startupOracle
- mysqld --skip-grant-tablesMySql
- mysqld got signal 8MySqlGo
- 關閉資料庫遇到SHUTDOWN: Active processes prevent shutdown operation資料庫
- CSS 設定 <progress>樣式CSS
- How to move progress database to different OSDatabase
- SORT (UNIQUE STOPKEY)/ SORT GROUP BY STOPKEYTopK
- Mysqld_safe支援選項MySql
- mysql 5.0.41 mysqld 引數大全MySql
- JavaScript sort()JavaScript
- 排序sort排序
- Sort排序排序
- sort命令
- Queue Sort