由于系统维护,有时候需要将mysql重启,之前都没有问题,但是最近遇到:
$ sudo service mysqld restart
Stopping mysqld: [ OK ]
Starting mysqld: [ OK ]
但是事实上mysql并未重启,如果使用指令:
$ sudo service mysqld restart
Stopping mysqld: [ OK ]
mysql依然未关闭,可正常的连接和操作,show processlist的结果与之前完全一样。
查看error:
120227 20:01:27 [Note] /usr/libexec/mysqld: Normal shutdown
120227 20:01:27 [ERROR] Event Scheduler: [dba@%][objects.POI] Server shutdown in progress
120227 20:01:27 [Note] Event Scheduler: [dba@%].[objects.POI] event execution failed.
120227 20:01:27 [Note] Event Scheduler: Killing the scheduler thread, thread id 1
120227 20:01:27 [Note] Event Scheduler: Waiting for the scheduler thread to reply
120227 20:01:27 [ERROR] Event Scheduler: [dba@%][objects.trip_2] Server shutdown in progress
120227 20:01:27 [Note] Event Scheduler: [dba@%].[objects.trip_2] event execution failed.
120227 20:01:27 [ERROR] Event Scheduler: [dba@%][objects.ctp4] Server shutdown in progress
120227 20:01:27 [ERROR] Event Scheduler: [dba@%][objects.ctp4] Server shutdown in progress
120227 20:01:27 [ERROR] Event Scheduler: [dba@%][objects.ctp4] Server shutdown in progress
120227 20:01:27 [Note] Event Scheduler: [dba@%].[objects.ctp4] event execution failed.
120227 20:01:28 [ERROR] Event Scheduler: [dba@%][objects.ctp3] Server shutdown in progress
120227 20:01:28 [ERROR] Event Scheduler: [dba@%][objects.ctp3] Server shutdown in progress
120227 20:01:28 [ERROR] Event Scheduler: [dba@%][objects.ctp3] Server shutdown in progress
120227 20:01:28 [Note] Event Scheduler: [dba@%].[objects.ctp3] event execution failed.
120227 20:01:29 [ERROR] Event Scheduler: [dba@%][objects.ctp2] Server shutdown in progress
120227 20:01:29 [Note] Event Scheduler: [dba@%].[objects.ctp2] event execution failed.
120227 20:02:00 [Note] Event Scheduler: Stopped
120227 20:02:01 [Note] Event Scheduler: Purging the queue. 10 events
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 82466 user: 'dba'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 81766 user: 'dba'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 78165 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 78162 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 78159 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 72520 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 72452 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 48202 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 48200 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 48198 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 48196 user: 'ws'
120227 20:02:03 [Warning] /usr/libexec/mysqld: Forcing close of thread 48195 user: 'ws'
这是什么原因呢?