LP #1080829: Using xtrabackup sst fails due to mktemp error

Description

**Reported in Launchpad by MentalPower last update 31-05-2013 18:04:57

Whenever a joining cluster node tries to join a cluster and its setup to do so via SST it will fail due to an issue when calling the mktemp helper program.

Older versions of mktemp allowed trailing characters after the string of XXXXXX for the template. Version 7.4 does not and exits with an error of "mktemp: too few X's in template `wsrep_sst_xtrabackupXXXX.pid'" if you try. Newer versions have a --suffix option to address this, but that is not an option on a default ubuntu 10.04 system.

We're fixing the issue manually by changing line 118 in wsrep_sst_xtrabackup from "XTRABACKUP_PID=$(mktemp --tmpdir wsrep_sst_xtrabackupXXXX.pid)" to just "XTRABACKUP_PID=$(mktemp --tmpdir wsrep_sst_xtrabackupXXXX)"

Environment

None

Smart Checklist

Activity

lpjirasync January 12, 2018 at 1:18 PM

**Comment from Launchpad by: Alex Yurchenko on: 17-12-2012 19:46:33

Joe, please try an updated wsrep_sst_xtrabackup - https://launchpad.net/codership-mysql/5.5/5.5.28-23.7/+download/wsrep_sst_xtrabackup

The very idea of using mktmp turned out to be wrong.

lpjirasync January 12, 2018 at 1:18 PM

**Comment from Launchpad by: nntp on: 17-12-2012 08:43:25

Sorry missed the mktemp version in SuSE Enterprise Linux 11 SP2

mktemp 8.12

lpjirasync January 12, 2018 at 1:18 PM

**Comment from Launchpad by: nntp on: 17-12-2012 08:40:26

Alex,

We have same problem when deploy on SuSE Enterprise Linux 11 SP2 (x86_64). (Install from source)

But it is strange the problem doesn't happen when deploy the same thing inside virtualbox with the same Linux OS and patch level.

Joe

lpjirasync January 12, 2018 at 1:17 PM

**Comment from Launchpad by: Raghavendra D Prabhu on: 13-12-2012 12:28:58

@Alex,

I tested and yes, you need to kill both.

lpjirasync January 12, 2018 at 1:17 PM

**Comment from Launchpad by: Vadim Tkachenko on: 06-12-2012 17:05:54

Alex,

You can read a difference there
http://www.percona.com/doc/percona-xtrabackup/manual.html

We need to kill both of them if a caller died.

Done

Details

Assignee

Reporter

Priority

Smart Checklist

Created January 12, 2018 at 1:17 PM
Updated December 25, 2018 at 5:25 PM
Resolved December 15, 2023 at 2:26 PM