Systemd Mysql won't stop

Question

After upgrading to 15.04, I have had lots of fun getting to know systemd. I think I have everything working except I am unable to stop mysql.service; the systemctl command just hangs and mysql just keeps on running. Has anyone else experienced this or might know what's going on?

By default, it nukes the service with SIGKILL after 3 minutes (if the service fails to terminate normally). Probably you'll have to read the configs of mysql.service. — Velkan, Apr 29 '15 at 11:06
Which version of MySQL are you running? Did you use their native mysql.service script or did you roll your own? — Jos, Apr 30 '15 at 12:37
It's 5.6 which comes out of the official vivid repo. I am using the script that comes with that package. — Craig Dunford, May 02 '15 at 01:13

score 27 · Accepted Answer · edited Apr 23 '16 at 16:22

27

I had the same problem (upgrade to 15.04, using official files and config).

I had to make the following changes to be able to stop the mysql daemon manually with sytemctl and automatically on system reboot/shutdown:

Make /etc/mysql/debian.cnf readable for the mysql user with

sudo chgrp mysql /etc/mysql/debian.cnf; sudo chmod 640 /etc/mysql/debian.cnf

Provide a slightly modified mysql.service file:

sudo cp /lib/systemd/system/mysql.service /etc/systemd/system/
sudo chmod 755 /etc/systemd/system/mysql.service

Provide an explicit stop command by opening the copied file in an editor:
```
sudo nano /etc/systemd/system/mysql.service
```
and adding the following line under the [Service] section:
```
ExecStop=/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf shutdown
```
In Nano, use Ctrl+O to save (Linux way!), Ctrl+X to exit.
Make the new service file known to system:
```
sudo systemctl daemon-reload
```

edited Apr 23 '16 at 16:22

Community

1

answered May 16 '15 at 22:32

Udo

386

My Kubuntu started to freeze during shutdown with A stop job is running for MySQL Community Server [1min 16s / 10min]. This answer resolved the issue, thank you so much. – lolmaus - Andrey Mikhaylov May 20 '15 at 14:22
My 14.10 -> 15.04 upgrade (which moved MySQL 5.5 to 5.6) caused the same issue. Although MySQL 'works' it doesn't shutdown correctly, so Ubuntu hangs on shutdown. Looks like the issue relates to the MySQL version change combined with systemd replacing upstart.
This link covers some of the updates to MySQL config to sort out warnings, etc.

Starting MySQL always complains about incorrect shutdown too, as systemd just kills the process after 10 minutes, if you can wait that long.
– Mike Jul 02 '15 at 12:36
1

Same problem in Debian Jessie / Testing with MySQL 5.6 - fixed thanks to you :) – Majenko Sep 20 '15 at 10:43
I hate having to do this but I'm so glad it works, thanks Udo! – Gabriel Baker Oct 20 '15 at 09:14
It didn't solve the issue on LinuxMint 18. – sivaprasadreddy.k Jul 31 '16 at 02:48
1

Worked perfectly for me on Ubuntu 16.04. I was looking at A stop job is running for MySQL Community Server [1min 16s / 10min] every time I shutdown my system. – Gaurav Shetty Sep 28 '16 at 04:43

score 1 · Answer 2 · answered Dec 22 '15 at 12:56

1

I had the same problem with Ubuntu 15.10 Desktop and I found way to fix it:

log_error parameter in /etc/mysql/mysql.conf.d/mysqld.cnf was commented out. After uncommenting the parameter, systemd does mysqld shutdown without problems.

answered Dec 22 '15 at 12:56

mikko356

11

I had the same problem on Ubuntu LTS 16.04. Only disabling of the error.log was working. Now mysqld writes via the --log-syslog option to the journal. Maybe a reason: the root filesystem was btrfs. – ingopingo Mar 25 '17 at 15:46

score 1 · Answer 3 · answered Apr 07 '16 at 12:07

Your problem is thread_pool_size. If it's much higher than the number of cores/threads, you'll not be able to shutdown properly unless by using mysqladmin shutdown command.

Eg.: You have 2 cores CPU with 4 threads. If you set it 1-4 - it will work fine. If you set it to 16, as advised in many 'high performance' blogs, it'll get pooched.

zero-day · Answer 4 · 2017-01-22T11:16:05.780

I had a similar issue with mysql / mariadb failing to stop when instructed by systemd, either on shutdown or called manually with sudo service mysql stop.

In my case I am dual-booting Ubuntu / Windows in UEFI mode, and these OS interpret different hardware time, so both OSs sync against Internet time servers when they start up.

MySQL (and Mariadb) was failing to stop if the hardware time changed while it are running.

You need to defer starting MySQL until after the timesync. Ideally this would be done by inserting a temporal dependency on mysql with After: time-sync but that didn't work for me.

The solution that worked for me (You can replace mysql with mariadb for the same effect):

Disable mysql with sudo systemctl disabled mysql.service
Create a script (ensure it's executable) that will start mysql after some delay /usr/bin/delay_mysql with contents:
```
#!/bin/sh
sleep 30s
/etc/init.d/mysql start
```

Create a systemd service to run your new script /etc/systemd/system/delay_mysql.service with contents:

[Unit]
Description=Delay start of MySQL / MariaDB

[Service]
Type=oneshot
ExecStart=/usr/bin/delay_mysql

[Install]
WantedBy=multi-user.target

Register your new service with sudo systemctl enable delay_mysql.service

This will cause your script to run at multi-user levels, which on Ubuntu are 3,4,5.

It's solved my problem. However it is very important to note, that before reinstalling MySql you should disable delay_mysql.service, otherwise you got an error. — SiGe, Oct 09 '17 at 09:42

score 0 · Answer 5 · edited Nov 19 '15 at 15:19

0

Just when copying mysql.service you'll have to do a chmod after.

cp /lib/systemd/system/mysql.service /etc/systemd/system/
chmod 755 /etc/systemd/system/mysql.service

edited Nov 19 '15 at 15:19

A.B.

92,275

answered Nov 19 '15 at 15:03

Martin

1

score 0 · Answer 6 · edited Jul 08 '16 at 11:57

in my case it was password mismatch for maintenance user debian-sys-maint between one in /etc/mysql/debian.cnf and one in MySQL database.

This user is used for MySQL shutdown and other functions. After MySQL update it might happened that there is a pass mismatch between file and database. This could also happen if you move your database from one MySQL to another. If you will import all databases and users from other MySQL on different machine you need to re-sync your maintenance user ( debian-sys-maint ) password.

You need to do: check your current password in ubuntu/debian file:

sudo cat /etc/mysql/debian.cnf

# Automatically generated for Debian scripts. DO NOT TOUCH!
[client]
host     = localhost
user     = debian-sys-maint
password = n4aSHUP04s1J32X5
socket   = /var/run/mysqld/mysqld.sock
[mysql_upgrade]
user     = debian-sys-maint
password = n4aSHUP04s1J32X5
socket   = /var/run/mysqld/mysqld.sock
basedir  = /usr

You can see your password that system will use here: password = n4aSHUP04s1J32X5

Next step is to update MySQL to same password: Log into MySQL:

~$ mysql -u root -p

Type your password to access MySQL

mysql> GRANT ALL PRIVILEGES ON *.* TO 'debian-sys-maint'@'localhost' IDENTIFIED BY 'n4aSHUP04s1J32X5';**

After that no more issues with shutdown, no 10 min wait, no issues with installing apps that use this maintenance account like phpmyadmin.

UPDATE: So unfortunately this did not solve the issue. It made it kind of random - sometimes I can stop the service without issue another time it will freeze on service stop.

Systemd Mysql won't stop

6 Answers6