[Bug 1468804] [NEW] mysql stop/restart fails + breaking mysql + reboots

[David Favor]

Public bug reported:

This is a huge problem.

After several iterations of - service mysql {start|stop|restart} - the
mysql service becomes broken + unrecoverable.

The problem becomes - service mysql stop - hangs forever, upon
attempting...

     exec systemctl stop mysql.service

What's required then is one of these...

     mysqladmin -uroot -p shutdown
     pkill mysqld

Neither of these is acceptable.

The biggest problem is this breakage also breaks reboots.

The reboot sequence depends on services doing what's expected, so when
systemctl stop mysql.service hangs, reboot hangs too.

Because of the lunacy of the entire systemctl subsystem, sshd is
correctly killed off while msqld hangs.

At this point, there's no way to ssh into system + a power recycle must
be done to complete a reboot sequence.

/bin/systemctl is an executable with no apparent way to debug it's
logic.

Please update this bug with details about how to debug /bin/systemctl +
I'll post output.

** Affects: mysql-dfsg-5.1 (Ubuntu)
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server Team, which is subscribed to mysql-dfsg-5.1 in Ubuntu.
https://bugs.launchpad.net/bugs/1468804

Title:
  mysql stop/restart fails + breaking mysql + reboots

To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/mysql-dfsg-5.1/+bug/1468804/+subscriptions