[MDEV-9328] service mysql status returns an error - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Major
Resolution: Incomplete
Affects Version/s: 10.1.10
Fix Version/s: N/A
Component/s: Platform RedHat
Labels:
- need_feedback
- systemd
Environment:
CentOS 7.2

Sprint:
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

MDEV-9227 Both CentOS service names mysql and mariadb exist ?

Closed

Activity

Ascending order - Click to sort in descending order

Ahmad El-Bardan created issue - 2015-12-27 00:43

Ahmad El-Bardan made changes - 2015-12-27 00:43

Field	Original Value	New Value
Link		This issue blocks ~~MDEV-9227~~ [ ~~MDEV-9227~~ ]

Ahmad El-Bardan made changes - 2015-12-27 00:44

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}

Elena Stepanova made changes - 2015-12-29 02:26

Assignee

Nirbhay Choubey [ nirbhay_c ]

Elena Stepanova made changes - 2015-12-29 02:26

Fix Version/s

10.1 [ 16100 ]

Elena Stepanova made changes - 2015-12-29 02:27

Labels

systemd

Sergei Golubchik made changes - 2016-02-16 17:28

Sprint

10.1.12 [ 36 ]

Nirbhay Choubey (Inactive) made changes - 2016-02-18 22:30

Status

Open [ 1 ]

In Progress [ 3 ]

Nirbhay Choubey (Inactive) made changes - 2016-02-19 00:20

Status

In Progress [ 3 ]

Stalled [ 10000 ]

Nirbhay Choubey (Inactive) made changes - 2016-02-19 00:24

Labels

systemd

need_feedback systemd

Nirbhay Choubey (Inactive) made changes - 2016-11-02 14:51

Fix Version/s		N/A [ 14700 ]
Fix Version/s	10.1 [ 16100 ]
Resolution		Incomplete [ 4 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:42

Workflow

MariaDB v3 [ 73326 ]

MariaDB v4 [ 149940 ]

People

Assignee:: Nirbhay Choubey (Inactive)

Reporter:: Ahmad El-Bardan

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2015-12-27 00:43

Updated:: 2016-11-02 14:51

Resolved:: 2016-11-02 14:51

Git Integration

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

MariaDB Server

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration