xtrabackup sst fails if tmpdir is specified more than once in my.cnf
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
Undecided
|
Alex Yurchenko | ||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC |
Fix Released
|
Undecided
|
Raghavendra D Prabhu |
Bug Description
wsrep_sst_
A possible solution would be to add "|tail -n1" to this
TMPDIR=$(grep -E '^\s*tmpdir' $WSREP_SST_OPT_CONF | awk -F = '{ print $2 }' | sed 's/^\s//g' | sed 's/\s.*//g' )
So would be
TMPDIR=$(grep -E '^\s*tmpdir' $WSREP_SST_OPT_CONF | awk -F = '{ print $2 }' | sed 's/^\s//g' | sed 's/\s.*//g' |tail -n1)
Still could be that the last tmpdir is not the right one (could be under a different options group other than [mysqld]). I think the following line should work always:
grep -E '^\s*tmpdir' $WSREP_SST_OPT_CONF | awk -F = '{ print $2 }' | sed 's/^\s//g' | sed 's/\s.*//g'
Related branches
Changed in percona-xtradb-cluster: | |
status: | New → Triaged |
Changed in percona-xtradb-cluster: | |
assignee: | nobody → Raghavendra D Prabhu (raghavendra-prabhu) |
Changed in percona-xtradb-cluster: | |
milestone: | none → 5.5.30-23.7.4 |
status: | Triaged → Fix Released |
Changed in codership-mysql: | |
assignee: | nobody → Alex Yurchenko (ayurchen) |
milestone: | none → 5.5.30-23.7.4 |
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
I think this entire segment
if [ -z "${TMPDIR}" ]; then
# try to get it from my.cnf
# if failed default to /tmp
[ -z "${TMPDIR}" ] && TMPDIR="/tmp"
fi
is not required. If a separate tmpdir for xtrabackup is required
(by default it will use mysql's), then it can be passed through
tmpdir variable under [xtrabackup] in my.cnf