Service scripts for Ubuntu 12.04, 14.04 and Debian 7 do not work

[Mischa ter Smitten]

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.

[Hrvoje Matijakovic (hrvojem)]

Hi,

Can you please check why it isn't starting, it looks like upgrade didn't finish (note the 5.7.19-17 is not running vs 5.7.18-16 did not start).

I wasn't able to reproduce this:

root@wheezy:~# service mysql status
Percona Server 5.7.19-17 is running.
root@wheezy:~# dpkg -l | grep percona
ii percona-server-client-5.7 5.7.19-17-1.wheezy amd64 Percona Server database client binaries
ii percona-server-common-5.7 5.7.19-17-1.wheezy amd64 Percona Server database common files (e.g. /etc/mysql/my.cnf)
ii percona-server-server-5.7 5.7.19-17-1.wheezy amd64 Percona Server database server binaries
root@wheezy:~# ps auxww | grep mysql
mysql 5096 0.0 0.0 4184 716 ? S 09:42 0:00 /bin/sh /usr/bin/mysqld_safe
mysql 5347 5.0 13.4 592572 138048 ? Sl 09:42 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 5407 0.0 0.0 7836 880 pts/0 S+ 09:43 0:00 grep mysql

[Hrvoje Matijakovic (hrvojem)]

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.

[Hrvoje Matijakovic (hrvojem)]

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.

[Mischa ter Smitten (mischa-ter-smitten)]

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

[Mischa ter Smitten (mischa-ter-smitten)]

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

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

[Launchpad Janitor (janitor)]

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

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3744