5.6.22 (built from source) won't stop on-demand
I've got mysql 5.6.22 built from source on CentOS 6.3 x86_64. Using the standard (/etc/rc.d/init.d/mysql) script, I'm noticing that the server won't shut down cleanly. Both the mysqld_safe and mysqld processes hang around.. there is no disk activity (from what I can tell) and no activity from mysqld on `top`. The log shows:
2014-12-22 19:27:50 28608 [Note] /usr/libexec/mysqld: Normal shutdown
2014-12-22 19:27:50 28608 [Note] Giving 5 client threads a chance to die gracefully
2014-12-22 19:27:50 28608 [Note] Event Scheduler: Purging the queue. 0 events
2014-12-22 19:27:50 28608 [Note] Shutting down slave threads
2014-12-22 19:27:52 28608 [Note] Forcefully disconnecting 5 remaining clients
After which nothing else happens until I kill -9 the process(es).
When I restart the server, I get:
2014-12-22 19:29:05 29395 [Note] InnoDB: Database was not shutdown normally!
2014-12-22 19:29:05 29395 [Note] InnoDB: Starting crash recovery.
Is there any way to debug what's going on when mysqld is seemingly hung? I can't connect to it via a client..
This is a production VM, so there's only so much playing around I can do.
Thank you.
Subject
Written By
Posted
5.6.22 (built from source) won't stop on-demand
December 22, 2014 07:45PM
December 22, 2014 07:51PM
December 23, 2014 06:48PM
December 23, 2014 08:41PM
December 24, 2014 05:02PM
December 25, 2014 07:54PM
December 30, 2014 03:28PM
December 31, 2014 11:34AM
February 02, 2015 12:05PM
February 02, 2015 10:19PM
February 04, 2015 12:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.