Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5279

[PS-5.6] mysqladmin shutdown doesn't stop the service on CentOS 7

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Packaging
    • Labels:
      None

      Description

      [root@centos7 ~]# service mysql start
      Redirecting to /bin/systemctl start mysql.service
      [root@centos7 ~]# service mysql status
      Redirecting to /bin/systemctl status mysql.service
      ● mysqld.service - MySQL Percona Server
         Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
         Active: active (running) since Fri 2017-12-08 14:16:07 UTC; 7s ago
        Process: 3337 ExecStartPost=/usr/bin/mysql-systemd post (code=exited, status=0/SUCCESS)
        Process: 3309 ExecStartPre=/usr/bin/mysql-systemd pre (code=exited, status=0/SUCCESS)
       Main PID: 3336 (mysqld_safe)
         CGroup: /system.slice/mysqld.service
                 ├─3336 /bin/sh /usr/bin/mysqld_safe
                 └─3488 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
      
      Dec 08 14:16:05 centos7 systemd[1]: Starting MySQL Percona Server...
      Dec 08 14:16:06 centos7 mysqld_safe[3336]: 171208 14:16:06 mysqld_safe Logging to '/var/log/mysqld.log'.
      Dec 08 14:16:06 centos7 mysqld_safe[3336]: 171208 14:16:06 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
      Dec 08 14:16:07 centos7 systemd[1]: Started MySQL Percona Server.
      [root@centos7 ~]# mysqladmin shutdown
      [root@centos7 ~]# service mysql status
      Redirecting to /bin/systemctl status mysql.service
      ● mysqld.service - MySQL Percona Server
         Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
         Active: active (running) since Fri 2017-12-08 14:16:26 UTC; 1s ago
        Process: 3558 ExecStartPost=/usr/bin/mysql-systemd post (code=exited, status=0/SUCCESS)
        Process: 3531 ExecStartPre=/usr/bin/mysql-systemd pre (code=exited, status=0/SUCCESS)
       Main PID: 3557 (mysqld_safe)
         CGroup: /system.slice/mysqld.service
                 ├─3557 /bin/sh /usr/bin/mysqld_safe
                 └─3710 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/lib/mysql/mysql.sock
      
      Dec 08 14:16:25 centos7 systemd[1]: mysqld.service holdoff time over, scheduling restart.
      Dec 08 14:16:25 centos7 systemd[1]: Starting MySQL Percona Server...
      Dec 08 14:16:25 centos7 mysqld_safe[3557]: 171208 14:16:25 mysqld_safe Logging to '/var/log/mysqld.log'.
      Dec 08 14:16:25 centos7 mysqld_safe[3557]: 171208 14:16:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
      Dec 08 14:16:26 centos7 systemd[1]: Started MySQL Percona Server.
      
      [root@centos7 ~]# mysql
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 2
      Server version: 5.6.37-82.2 Percona Server (GPL), Release 82.2, Revision d1eb51005df
      
      Copyright (c) 2009-2017 Percona LLC and/or its affiliates
      Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved.
      
      Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.
      
      Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
      

      Installed packages:

      [root@centos7 ~]# rpm -qa | grep Percona
      Percona-Server-server-56-5.6.37-rel82.2.el7.x86_64
      Percona-Server-shared-56-5.6.37-rel82.2.el7.x86_64
      Percona-Server-client-56-5.6.37-rel82.2.el7.x86_64
      

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                evgeniy.patlan Evgeniy Patlan
                Reporter:
                hrvoje.matijakovic Hrvoje Matijakovic
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: