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

[Launchpad Bug Tracker]

You have been subscribed to a public bug by Robie Basak (racb):

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-5.6 (Ubuntu)
     Importance: Undecided
         Status: Incomplete

-- 
mysql stop/restart fails + breaking mysql + reboots
https://bugs.launchpad.net/bugs/1468804
You received this bug notification because you are a member of Ubuntu Server Team, which is subscribed to the bug report.