Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9328

service mysql status returns an error

Details

    • 10.1.12

    Description

      This issue is marked as fixed for 10.1.10 but it apparently is not fixed.

      [root@server ~]# service mysql status
      		 
       ERROR! MySQL is running but PID file could not be found
      		 
      [root@server ~]# systemctl status mysql
      		 
      ● mariadb.service - MariaDB database server
      		 
         Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      		 
        Drop-In: /etc/systemd/system/mariadb.service.d
      		 
                 └─mdb101.conf, migrated-from-my.cnf-settings.conf
      		 
         Active: active (running) since Sa 2015-12-26 22:05:25 UTC; 37min ago
      		 
       Main PID: 9026 (mysqld)
      		 
         Status: "Taking your SQL requests now..."
      		 
         CGroup: /system.slice/mariadb.service
      		 
                 └─9026 /usr/sbin/mysqld
      		 
       
      		 
      Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Starting MariaDB database server...
      		 
      Dez 26 22:05:25 server.absolutehacks.com mysqld[9026]: 2015-12-26 22:05:25 140136908179584 [Note] /usr/sbin/m......
      		 
      Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Started MariaDB database server.
      		 
      Hint: Some lines were ellipsized, use -l to show in full.
      		 
      [root@server ~]# service mariadb status
      		 
      Redirecting to /bin/systemctl status  mariadb.service
      		 
      ● mariadb.service - MariaDB database server
      		 
         Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
      		 
        Drop-In: /etc/systemd/system/mariadb.service.d
      		 
                 └─mdb101.conf, migrated-from-my.cnf-settings.conf
      		 
         Active: active (running) since Sa 2015-12-26 22:05:25 UTC; 37min ago
      		 
       Main PID: 9026 (mysqld)
      		 
         Status: "Taking your SQL requests now..."
      		 
         CGroup: /system.slice/mariadb.service
      		 
                 └─9026 /usr/sbin/mysqld
      		 
       
      		 
      Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Starting MariaDB database server...
      		 
      Dez 26 22:05:25 server.absolutehacks.com mysqld[9026]: 2015-12-26 22:05:25 140136908179584 [Note] /usr/sbin/m......
      		 
      Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Started MariaDB database server.
      		 
      Hint: Some lines were ellipsized, use -l to show in full.

      Attachments

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. MDEV-9227 Both CentOS service names mysql and mariadb exist ?

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            Ahmad Ahmad El-Bardan created issue -
            Ahmad Ahmad El-Bardan made changes -
            Field Original Value New Value
            Ahmad Ahmad El-Bardan made changes -
            Description This [issue|https://mariadb.atlassian.net/browse/MDEV-9227] is marked as fixed for 10.1.10 but it apparently is not fixed.

            {code:java}
            [root@server ~]# service mysql status
             ERROR! MySQL is running but PID file could not be found
            [root@server ~]# systemctl status mysql
            ● mariadb.service - MariaDB database server
               Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
              Drop-In: /etc/systemd/system/mariadb.service.d
                       └─mdb101.conf, migrated-from-my.cnf-settings.conf
               Active: active (running) since Sa 2015-12-26 22:05:25 UTC; 37min ago
             Main PID: 9026 (mysqld)
               Status: "Taking your SQL requests now..."
               CGroup: /system.slice/mariadb.service
                       └─9026 /usr/sbin/mysqld

            Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Starting MariaDB database server...
            Dez 26 22:05:25 server.absolutehacks.com mysqld[9026]: 2015-12-26 22:05:25 140136908179584 [Note] /usr/sbin/m......
            Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Started MariaDB database server.
            Hint: Some lines were ellipsized, use -l to show in full.
            [root@server ~]# service mariadb status
            Redirecting to /bin/systemctl status mariadb.service
            ● mariadb.service - MariaDB database server
               Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
              Drop-In: /etc/systemd/system/mariadb.service.d
                       └─mdb101.conf, migrated-from-my.cnf-settings.conf
               Active: active (running) since Sa 2015-12-26 22:05:25 UTC; 37min ago
             Main PID: 9026 (mysqld)
               Status: "Taking your SQL requests now..."
               CGroup: /system.slice/mariadb.service
                       └─9026 /usr/sbin/mysqld

            Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Starting MariaDB database server...
            Dez 26 22:05:25 server.absolutehacks.com mysqld[9026]: 2015-12-26 22:05:25 140136908179584 [Note] /usr/sbin/m......
            Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Started MariaDB database server.
            Hint: Some lines were ellipsized, use -l to show in full.
            [root@server ~]#
            {code}
            		 This [issue|https://mariadb.atlassian.net/browse/MDEV-9227] is marked as fixed for 10.1.10 but it apparently is not fixed.

            {code}
            [root@server ~]# service mysql status
             ERROR! MySQL is running but PID file could not be found
            [root@server ~]# systemctl status mysql
            ● mariadb.service - MariaDB database server
               Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
              Drop-In: /etc/systemd/system/mariadb.service.d
                       └─mdb101.conf, migrated-from-my.cnf-settings.conf
               Active: active (running) since Sa 2015-12-26 22:05:25 UTC; 37min ago
             Main PID: 9026 (mysqld)
               Status: "Taking your SQL requests now..."
               CGroup: /system.slice/mariadb.service
                       └─9026 /usr/sbin/mysqld

            Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Starting MariaDB database server...
            Dez 26 22:05:25 server.absolutehacks.com mysqld[9026]: 2015-12-26 22:05:25 140136908179584 [Note] /usr/sbin/m......
            Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Started MariaDB database server.
            Hint: Some lines were ellipsized, use -l to show in full.
            [root@server ~]# service mariadb status
            Redirecting to /bin/systemctl status mariadb.service
            ● mariadb.service - MariaDB database server
               Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
              Drop-In: /etc/systemd/system/mariadb.service.d
                       └─mdb101.conf, migrated-from-my.cnf-settings.conf
               Active: active (running) since Sa 2015-12-26 22:05:25 UTC; 37min ago
             Main PID: 9026 (mysqld)
               Status: "Taking your SQL requests now..."
               CGroup: /system.slice/mariadb.service
                       └─9026 /usr/sbin/mysqld

            Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Starting MariaDB database server...
            Dez 26 22:05:25 server.absolutehacks.com mysqld[9026]: 2015-12-26 22:05:25 140136908179584 [Note] /usr/sbin/m......
            Dez 26 22:05:25 server.absolutehacks.com systemd[1]: Started MariaDB database server.
            Hint: Some lines were ellipsized, use -l to show in full.
            {code}
            elenst Elena Stepanova made changes -
            Assignee Nirbhay Choubey [ nirbhay_c ]
            elenst Elena Stepanova made changes -
            Fix Version/s 10.1 [ 16100 ]
            elenst Elena Stepanova made changes -
            Labels systemd
            serg Sergei Golubchik made changes -
            Sprint 10.1.12 [ 36 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Labels systemd need_feedback systemd
            nirbhay_c Nirbhay Choubey (Inactive) made changes -
            Fix Version/s N/A [ 14700 ]
            Fix Version/s 10.1 [ 16100 ]
            Resolution Incomplete [ 4 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 73326 ] MariaDB v4 [ 149940 ]

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              Ahmad Ahmad El-Bardan
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.