[PXB775] LP 1642826 INCREMENTAL BACKUP FAILS WITH RELATIVE PATH

[PXB-775] LP #1642826: incremental backup fails with relative path / xtrabackup doesn't expand tilde Created: 19/Jan/18  Updated: 19/Jan/18  Resolved: 19/Jan/18

Status:

Done

Project:

Percona XtraBackup

Component/s:

None

Affects Version/s:

None

Fix Version/s:

None

Type:

Bug

Priority:

High

Reporter:

lpjirasync (Inactive)

Assignee:

Unassigned

Resolution:

Fixed

Votes:

0

Labels:

migratedfromlp

Remaining Estimate:

Not Specified

Time Spent:

Not Specified

Original Estimate:

Not Specified

Launchpad URL:

https://bugs.launchpad.net/percona-xtrabackup/+bug/1642826

**Reported in Launchpad by Muhammad Irfan last update 17-12-2016 10:32:30

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.

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

FULL BACKUP:

1. 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:

1. 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.

Comment by lpjirasync (Inactive) [ 19/Jan/18 ]

**Comment from Launchpad by: Sergei Glushchenko on: 09-12-2016 09:48:38

Looks like path expansion doesn't work?

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

Comment by lpjirasync (Inactive) [ 19/Jan/18 ]

**Comment from Launchpad by: Sergei Glushchenko on: 12-12-2016 05:52:48

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