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

[PS-5.5/5.6] If service is stopped with mysqladmin shutdown it can't be started again

    Details

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

      Description

      I can reproduce this on xenial/artful/stretch with 5.6.37-82.2 and 5.6.38-83.0:

      To reproduce install percona-server-server-5.6, make sure that service is running. Stop the service with mysqladmin shutdown, try to start the service.

      root@xenial:~# mysql
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 46
      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.
      
      mysql> Bye
      root@xenial:~# service mysql status
      ● mysql.service - LSB: Start and stop the mysql (Percona Server) daemon
         Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
         Active: active (running) since Fri 2017-12-08 13:26:39 UTC; 11s ago
           Docs: man:systemd-sysv-generator(8)
         CGroup: /system.slice/mysql.service
                 ├─14959 /bin/sh /usr/bin/mysqld_safe
                 └─15015 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib/mysql/plugin --user=mysql --log-error=/var/lib/mysql/xenial.err --pid-file=/var/lib/mysql/xenial.pid
      
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.func                                         OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.general_log                                  OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.help_category                                OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.help_keyword                                 OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.help_relation                                OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.help_topic                                   OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.innodb_index_stats                           OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.innodb_table_stats                           OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15115]: WARNING: mysql.user contains 4 root accounts without password!
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15116]: Triggering myisam-recover for all MyISAM tables
      root@xenial:~# mysqladmin shutdown
      root@xenial:~# mysql
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
      root@xenial:~# service mysql status
      ● mysql.service - LSB: Start and stop the mysql (Percona Server) daemon
         Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
         Active: active (exited) since Fri 2017-12-08 13:26:39 UTC; 34s ago
           Docs: man:systemd-sysv-generator(8)
      
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.func                                         OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.general_log                                  OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.help_category                                OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.help_keyword                                 OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.help_relation                                OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.help_topic                                   OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.innodb_index_stats                           OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15067]: mysql.innodb_table_stats                           OK
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15115]: WARNING: mysql.user contains 4 root accounts without password!
      Dec 08 13:26:40 xenial /etc/mysql/debian-start[15116]: Triggering myisam-recover for all MyISAM tables
      root@xenial:~# service mysql start
      root@xenial:~# mysql
      ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
      root@xenial:~# ps auxwww| grep mysql
      root     15231  0.0  0.0  14224   968 pts/0    S+   13:27   0:00 grep --color=auto mysql
      root@xenial:~#
      

        Smart Checklist

          Attachments

            Issue Links

              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:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - 0 minutes
                    0m
                    Logged:
                    Time Spent - 1 day, 2 hours
                    1d 2h