incremental backup fails with relative path / xtrabackup doesn't expand tilde

[Muhammad Irfan]

When using relative path with incremental backup. Xtrabackup fails to read xtrabackup_checkpoint file and it exit with error. That's how I reproduced it.

# xtrabackup --version
xtrabackup version 2.2.13 based on MySQL server 5.6.24 Linux (x86_64) (revision id: 70f4be3)

FULL BACKUP:
# innobackupex --no-timestamp backup/full/

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
.
.
innobackupex: Using server version 5.6.29-76.2
.
.
innobackupex: Backup created in directory '/root/backup/full'
161118 11:16:11 innobackupex: Connection to database server closed
161118 11:16:11 innobackupex: completed OK!

INCREMENTAL BACKUP:
# innobackupex --no-timestamp --incremental ~/backup/inc_1 --incremental-basedir=~/backup/full
.
.
innobackupex: Using server version 5.6.29-76.2

innobackupex: Created backup directory /root/backup/inc_1

161118 11:26:20 innobackupex: Starting ibbackup with command: xtrabackup --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/root/backup/inc_1 --innodb_log_file_size="50331648" --innodb_data_file_path="ibdata1:12M:autoextend" --tmpdir=/tmp --extra-lsndir='/tmp' --incremental-basedir='~/backup/full' --suspend-at-start
innobackupex: Waiting for ibbackup (pid=1802) to suspend
innobackupex: Suspend file '/root/backup/inc_1/xtrabackup_suspended_1'

xtrabackup: Error: cannot open ~/backup/full/xtrabackup_checkpoints
xtrabackup: error: failed to read metadata from ~/backup/full/xtrabackup_checkpoints
innobackupex: got a fatal error with the following stacktrace: at /usr/bin/innobackupex line 2711
 main::wait_for_ibbackup_file_create('/root/backup/inc_1/xtrabackup_suspended_1') called at /usr/bin/innobackupex line 2731
 main::wait_for_ibbackup_suspend('/root/backup/inc_1/xtrabackup_suspended_1') called at /usr/bin/innobackupex line 1977
 main::backup() called at /usr/bin/innobackupex line 1609
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2711.

As soon as I use absolute path i.e. /root/backup/inc1/ for --incremental and /root/backup/full/ for --incremental-basedir options for incremental backup it completes without any errors.

[Sergei Glushchenko (sergei.glushchenko)]

Looks like path expansion doesn't work?

https://www.gnu.org/software/bash/manual/html_node/Tilde-Expansion.html

[Sergei Glushchenko (sergei.glushchenko)]

https://github.com/percona/percona-xtrabackup/pull/297
https://github.com/percona/percona-xtrabackup/pull/299

[Shahriyar Rzayev (rzayev-sehriyar)]

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