Cannot start Percona Server using mysql.server due to calling mysqld_safe from absolute path

[Jaime Sicam]

How to reproduce with MySQL sandbox:

1. Setup:
mkdir ~/binaries
cd ~/binaries
wget https://www.percona.com/downloads/Percona-Server-LATEST/Percona-Server-5.7.17-11/binary/tarball/Percona-Server-5.7.17-11-Linux.x86_64.ssl100.tar.gz
make_sandbox Percona-Server-5.7.17-11/binary/tarball/Percona-Server-5.7.17-11-Linux.x86_64.ssl100.tar.gz
sudo cp ~/sandboxes/msb_5_7_17/my.sandbox.cnf /etc/my.cnf

2. Testing:
cd ~/binaries/5.7.17/support-files
./mysql.server stop
Shutting down MySQL (Percona Server)
... *

./mysql.server start
Starting MySQL (Percona Server)
.2017-03-07T07:07:50.383608Z mysqld_safe The file /usr/local/Percona-Server-5.7.17-11-Linux.x86_64.ssl100/bin/mysqld
does not exist or is not executable. Please cd to the mysql installation
directory and restart this script from there as follows:
./bin/mysqld_safe&
See http://dev.mysql.com/doc/mysql/en/mysqld-safe.html for more information
 * The server quit without updating PID file (/home/user/sandboxes/msb_5_7_17/data/mysql_sandbox5717.pid).

3. To fix:
Edit mysql.server
Find:
$bindir/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &
Change to:
bin/mysqld_safe --datadir="$datadir" --pid-file="$mysqld_pid_file_path" $other_args >/dev/null &

./mysql.server start
Starting MySQL (Percona Server)
.. *

[Sveta Smirnova (svetasmirnova)]

This is fixed in upstream version 5.7.18. See https://bugs.mysql.com/bug.php?id=84263 and https://bugs.mysql.com/bug.php?id=84173 for details

[Yura Sorokin (yura-sorokin)]

5.5 fixed as part of the 5.5.55 upstream merge
https://github.com/percona/percona-server/pull/1651

[Laurynas Biveinis (laurynas-biveinis)]

https://github.com/percona/percona-server/pull/1678

[Laurynas Biveinis (laurynas-biveinis)]

https://github.com/percona/percona-server/pull/1695

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-1787