stopping mysql with inet script doesn't work if pid-file is provided as pid_file in my.cnf
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL Server |
Unknown
|
Unknown
|
||||
Percona Server moved to https://jira.percona.com/projects/PS | Status tracked in 5.7 | |||||
5.1 |
Won't Fix
|
Medium
|
Unassigned | |||
5.5 |
Triaged
|
Medium
|
Unassigned | |||
5.6 |
Triaged
|
Medium
|
Unassigned | |||
5.7 |
Triaged
|
Medium
|
Unassigned | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Fix Released
|
Medium
|
Raghavendra D Prabhu |
Bug Description
When you define the pid-file in my.cnf using (underscore) instead of -, it won't stop.
in my.cnf:
pid_file = /mysql/
mysqld print-defaults output:
mysqld --print-defaults
mysqld would have been started with the following arguments:
--user=mysql --default_
[...]
--wsrep_
mysqld --print-defaults \
> | tr " " "\n" \
> | grep -- "--pid-file" \
> | tail -n 1 \
> | cut -d= -f2
---> nothing
mysqld --print-defaults \
> | tr " " "\n" \
> | grep -- "--pid_file" \
> | tail -n 1 \
> | cut -d= -f2
/mysql/
Related branches
Changed in percona-xtradb-cluster: | |
status: | New → Fix Committed |
assignee: | nobody → Raghavendra D Prabhu (raghavendra-prabhu) |
importance: | Undecided → Medium |
milestone: | none → 5.5.32-23.7.6 |
Changed in percona-xtradb-cluster: | |
status: | Fix Committed → Fix Released |
tags: | added: upstream |
tags: | added: pkg |
Percona Server 5.1 and 5.6 are also affected:
[openxs@chief ~]$ cd /tmp/Percona- Server- 5.1.72- rel14.10 Server- 5.1.72- rel14.10] $ grep -- --pid-file support- files/mysql. server. sh pid_file= `echo "$arg" | sed -e 's/^[^=]*=//'` ;;
--pid- file="$ pid_file" >/dev/null 2>&1 & bindir/ mysqld_ safe --datadir=$datadir --pid-file= $server_ pid_file $other_args >/dev/null 2>&1 & Server- 5.1.72- rel14.10] $ grep -- --pid_file support- files/mysql. server. sh
[openxs@chief Percona-
--pid-file=*) server_
--pid-file=*) pid_file=`echo "$arg" | sed -e 's/^[^=]*=//'` ;;
$
[openxs@chief Percona-
[openxs@chief Percona- Server- 5.6.14- rel62.0] $ grep -- --pid_file support- files/mysql. server. sh Server- 5.6.14- rel62.0] $ grep -- --pid-file support- files/mysql. server. sh pid_file_ path=`echo "$arg" | sed -e 's/^[^=]*=//'` ;; bindir/ mysqld_ safe --datadir= "$datadir" --pid-file= "$mysqld_ pid_file_ path" $other_args >/dev/null 2>&1 &
[openxs@chief Percona-
--pid-file=*) mysqld_
$
This is what we see in current cluster code (with the fix, I assume):
[openxs@chief percona- xtradb- cluster] $ bzr version-info xtradb- cluster xtradb- cluster] $ grep -- --pid-file Percona- Server/ support- files/mysql. server. sh -pid-file= *|--pid_ file=*) mysqld_ pid_file_ path=`echo "$arg" | sed -e 's/^[^=]*=//'` ;; bindir/ mysqld_ safe --datadir= "$datadir" --pid-file= "$mysqld_ pid_file_ path" $other_args >/dev/null 2>&1 &
revision-id: <email address hidden>
date: 2013-12-03 17:43:41 +0100
build-date: 2013-12-04 13:03:18 +0200
revno: 590
branch-nick: percona-
[openxs@chief percona-
-
$