LP #1719817: Service scripts for Ubuntu 12.04, 14.04 and Debian 7 do not work

Description

**Reported in Launchpad by Mischa ter Smitten last update 27-11-2017 04:17:33

root@ansible-percona-server-ubuntu-1404:~# service mysql status

  • Percona Server 5.7.19-17 is not running

While it is running, same for Debian 7

root@ansible-percona-server-ubuntu-1204:~# service mysql start
........................................................................................................................ * Percona Server 5.7.18-16 did not start. Please check logs for more details.

Nothing in the log

Ubuntu 16.04, Debian 8 and 9 seems to work just fine.

Environment

None

Smart Checklist

Activity

lpjirasync January 24, 2018 at 11:40 AM

**Comment from Launchpad by: Launchpad Janitor on: 27-11-2017 04:17:33

[Expired for Percona Server because there has been no activity for 60 days.]

lpjirasync January 24, 2018 at 11:40 AM

**Comment from Launchpad by: Mischa ter Smitten on: 27-09-2017 12:42:54

Multiple mysql processes indeed, that shouldn't be possible right?

Is service mysql stop non-blocking (since 5.7)?

lpjirasync January 24, 2018 at 11:40 AM

**Comment from Launchpad by: Mischa ter Smitten on: 27-09-2017 12:38:02

root@ansible-percona-server-ubuntu-1404:~# service mysql stop

  • Percona Server 5.7.19-17 is already stopped
    root@ansible-percona-server-ubuntu-1404:~# ps auxww | grep mysql
    mysql 12304 0.0 0.0 4452 8 ? S 12:23 0:00 /bin/sh /usr/bin/mysqld_safe
    mysql 12560 0.2 0.6 1124204 1608 ? Sl 12:23 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306

lpjirasync January 24, 2018 at 11:40 AM

**Comment from Launchpad by: Hrvoje Matijakovic on: 27-09-2017 12:23:38

Can you try running:

service mysql stop

and then:

ps auxww | grep mysql

to make sure that service isn't running anymore, before trying to start the service again. It looks that you have two mysql processes running.

lpjirasync January 24, 2018 at 11:40 AM

**Comment from Launchpad by: Hrvoje Matijakovic on: 27-09-2017 09:48:59

I've just noticed that you've provided tests for two different distros. But again checking the error log would probably provide more information why the service is failing to start.

root@wheezy:~# service mysql restart
Stopping Percona Server 5.7.19-17.
...
Percona Server 5.7.19-17 is stopped.
Re-starting Percona Server 5.7.19-17.
root@wheezy:~# service mysql status
Percona Server 5.7.19-17 is running.
root@wheezy:~# ps auxww | grep mysql
mysql 5513 0.0 0.0 4184 728 ? S 09:46 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 5762 13.6 13.4 592572 138040 ? Sl 09:46 0:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --log-error=/var/log/mysql/error.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306
root 5816 0.0 0.0 7836 884 pts/0 S+ 09:46 0:00 grep mysql

root@wheezy:~# service mysql stop
....
Percona Server 5.7.19-17 is stopped.
root@wheezy:~# service mysql status
Percona Server 5.7.19-17 is not running.
root@wheezy:~# service mysql start
root@wheezy:~# service mysql status
Percona Server 5.7.19-17 is running.

Done

Details

Assignee

Reporter

Priority

Smart Checklist

Created January 24, 2018 at 11:40 AM
Updated January 24, 2018 at 11:40 AM
Resolved January 24, 2018 at 11:40 AM