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

          Activity

            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.