Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.1.10
-
CentOS 7.2
-
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
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} |
Assignee | Nirbhay Choubey [ nirbhay_c ] |
Fix Version/s | 10.1 [ 16100 ] |
Labels | systemd |
Sprint | 10.1.12 [ 36 ] |
Status | Open [ 1 ] | In Progress [ 3 ] |
Status | In Progress [ 3 ] | Stalled [ 10000 ] |
Labels | systemd | need_feedback systemd |
Fix Version/s | N/A [ 14700 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Resolution | Incomplete [ 4 ] | |
Status | Stalled [ 10000 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 73326 ] | MariaDB v4 [ 149940 ] |
I tried some permutations on centos70-x86-64 and couldn't reproduce this. Could you try running the failing command under sh -x? I need to see what going on with the pid file.
[root@centos70-x86-64 ~]# service mysql start
Starting mysql (via systemctl): [ OK ]
[root@centos70-x86-64 ~]# mysqladmin -uroot ping
mysqld is alive
[root@centos70-x86-64 ~]# service mysql status
SUCCESS! MySQL running (11341)
[root@centos70-x86-64 ~]# systemctl status mysql
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Tue 2015-12-29 09:28:34 EST; 28s ago
Main PID: 11341 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─11341 /usr/sbin/mysqld
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: 2015-12-29 9:28:34 140552782350080 [Note] WSREP: wsrep_notify_c...tion.
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: 2015-12-29 9:28:34 140552782350080 [Note] WSREP: REPL Protocols...3, 2)
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: 2015-12-29 9:28:34 140552544712448 [Note] WSREP: Service thread...shed.
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: 2015-12-29 9:28:34 140552782350080 [Note] WSREP: Assign initial...on: 3
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: 2015-12-29 9:28:34 140552544712448 [Note] WSREP: Service thread...shed.
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: 2015-12-29 9:28:34 140552782350080 [Note] WSREP: Synchronized w...tions
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: 2015-12-29 9:28:34 140552782350080 [Note] WSREP: wsrep_notify_c...tion.
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: 2015-12-29 9:28:34 140552782657664 [Note] /usr/sbin/mysqld: rea...ions.
Dec 29 09:28:34 centos70-x86-64 mysqld[11341]: Version: '10.1.10-MariaDB' socket: '/var/lib/mysql/mysql.sock' ...erver
Dec 29 09:28:34 centos70-x86-64 systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@centos70-x86-64 ~]# systemctl stop mysql
[root@centos70-x86-64 ~]# service mysql status
ERROR! MySQL is not running
[root@centos70-x86-64 ~]# systemctl status mysql
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: inactive (dead) since Tue 2015-12-29 09:29:54 EST; 12s ago
Process: 11341 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER (code=exited, status=0/SUCCESS)
Main PID: 11341 (code=exited, status=0/SUCCESS)
Status: "MariaDB server is down"
Dec 29 09:29:52 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:52 140552781612800 [Note] WSREP: wsdb trx map u...age 0
Dec 29 09:29:52 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:52 140552781612800 [Note] WSREP: MemPool(LocalT...ol: 0
Dec 29 09:29:52 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:52 140552781612800 [Note] WSREP: MemPool(SlaveT...ol: 0
Dec 29 09:29:52 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:52 140552781612800 [Note] WSREP: Shifting CLOSE...O: 0)
Dec 29 09:29:52 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:52 140552781612800 [Note] WSREP: Flushing memor...sk...
Dec 29 09:29:52 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:52 140551793899264 [Note] InnoDB: FTS optimize ...ting.
Dec 29 09:29:52 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:52 140552781612800 [Note] InnoDB: Starting shutdown...
Dec 29 09:29:54 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:54 140552781612800 [Note] InnoDB: Shutdown comp...17009
Dec 29 09:29:54 centos70-x86-64 mysqld[11341]: 2015-12-29 9:29:54 140552781612800 [Note] /usr/sbin/mysqld: Shu...plete
Dec 29 09:29:54 centos70-x86-64 systemd[1]: Stopped MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@centos70-x86-64 ~]# systemctl status mysql
mariadb.service - MariaDB database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: active (running) since Tue 2015-12-29 09:30:38 EST; 5s ago
Main PID: 11424 (mysqld)
Status: "Taking your SQL requests now..."
CGroup: /system.slice/mariadb.service
└─11424 /usr/sbin/mysqld
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: 2015-12-29 9:30:38 140254956128000 [Note] WSREP: wsrep_notify_c...tion.
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: 2015-12-29 9:30:38 140254956435584 [Note] /usr/sbin/mysqld: rea...ions.
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: Version: '10.1.10-MariaDB' socket: '/var/lib/mysql/mysql.sock' ...erver
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: 2015-12-29 9:30:38 140254956128000 [Note] WSREP: REPL Protocols...3, 2)
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: 2015-12-29 9:30:38 140254719768320 [Note] WSREP: Service thread...shed.
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: 2015-12-29 9:30:38 140254956128000 [Note] WSREP: Assign initial...on: 3
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: 2015-12-29 9:30:38 140254719768320 [Note] WSREP: Service thread...shed.
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: 2015-12-29 9:30:38 140254956128000 [Note] WSREP: Synchronized w...tions
Dec 29 09:30:38 centos70-x86-64 mysqld[11424]: 2015-12-29 9:30:38 140254956128000 [Note] WSREP: wsrep_notify_c...tion.
Dec 29 09:30:38 centos70-x86-64 systemd[1]: Started MariaDB database server.
Hint: Some lines were ellipsized, use -l to show in full.
[root@centos70-x86-64 ~]# service mysql status
SUCCESS! MySQL running (11424)