Mysqld_safe choose wrong MY_PWD
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
New
|
Undecided
|
EvgeniyPatlan |
Bug Description
In upgrading from :
Percona-
to
Percona-
I had an issue and MySQL (PXC) did not start.
[mysql@galera1h1n5 galera1]$ 2017-10-
2017-10-
2017-10-
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://
I am currently running PXC using TAR binaries and NON standard location.
Debugging a bit I found that mysqld_safe in the newest release is currently picking up the wrong path at line 579:
case "$0" in
580 /*)
581 MY_PWD=
582 ;;
583 *)
584 MY_PWD=`dirname $0`
585 MY_PWD=`dirname $MY_PWD`
586 ;;
587 esac
While the OLD version at line 531:
530
531 MY_PWD=`pwd`
532 # Check for the directories we would expect from a binary release install
533 if test -n "$MY_BASEDIR_
534 then
NEW execution (bash with -x)
Cluster-
+ relpkgdata=./share
+ case "$0" in
+ MY_PWD=
er-5.7.
+ test -n '' -a -d ''
OLD execution (bash -x)
+ relpkgdata=./share
++ pwd
+ MY_PWD=
+ test -n '' -a -d ''
Commenting the new code and set the old assignment will make the mysqld_safe work correctly.
But I assume you were trying to do something with that change.
Changed in percona-xtradb-cluster: | |
assignee: | nobody → EvgeniyPatlan (evgeniy-patlan) |
forgot the paths are set like:
[mysql@galera1h1n5 galera1]$ cat start
#! /bin/bash --
MYSQL_CMD_ DIR=/opt/ mysql_templates /PXC-57 /opt/mysql_ instances/ galera1 PORT=$MYSQL_ DIR/mysql. sock
MYSQL_DIR=
MYSQL_UNIX_
MYSQL_TCP_PORT=3306
export MYSQL_UNIX_PORT MYSQL_TCP_PORT MYSQL_DIR
cd $MYSQL_CMD_DIR CMD_DIR/ bin/mysqld_ safe --defaults- file=$MYSQL_ DIR/my. cnf --basedir= /opt/mysql_ templates/ PXC-57 &
$MYSQL_