innobackupex does not pass --tmpdir to xtrabackup

Reported by navigator93 on 2012-11-30
50
This bug affects 7 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup
Medium
Alexey Kopytov
2.0
Medium
Alexey Kopytov
2.1
Medium
Alexey Kopytov

Bug Description

This is using 2.0.3 on ubuntu 10.04
When invoking incremental backups through innobackupex, xtrabackup does not seem to get the --tmpdir argument passed to it so it always uses MYSQL TMPDIR. This can turn into filling the mysql tmp dir (which does not have enough room for a HUGE incremental change).

This has stopped us from reliably running incremental backups especially after heavy write volume times

root 3237 0.0 0.0 4096 588 pts/1 S+ 10:22 0:00 /bin/sh -c innobackupex --user=xtrabackup --password=<redacted> --no-timestamp --ibbackup=/usr/bin/xtrabackup --incremental-basedir=/backups/lsn/ --stream=xbstream --parallel 2 --extra-lsndir=/backups/lsn/ --tmpdir /backups/incremental/ --incremental /backups/incremental/ | pigz > /backups/incremental/inc.20121130_1022.xbs.gz
root 3238 1.5 0.0 37836 10968 pts/1 S+ 10:22 0:00 perl /usr/bin/innobackupex --user=xtrabackup --password=<redacted> --no-timestamp --ibbackup=/usr/bin/xtrabackup --incremental-basedir=/backups/lsn/ --stream=xbstream --parallel 2 --extra-lsndir=/backups/lsn/ --tmpdir /backups/incremental/ --incremental /backups/incremental/
root 3262 0.1 0.0 4096 604 pts/1 S+ 10:22 0:00 sh -c /usr/bin/xtrabackup --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/backups/incremental/ --extra-lsndir='/backups/lsn/' --incremental-basedir='/backups/lsn/' --parallel=2 --stream=xbstream
root 3263 32.1 0.1 256740 138552 pts/1 Sl+ 10:22 0:01 /usr/bin/xtrabackup --defaults-group=mysqld --backup --suspend-at-end --target-dir=/backups/incremental/ --extra-lsndir=/backups/lsn/ --incremental-basedir=/backups/lsn/ --parallel=2 --stream=xbstream

tags: added: innobackupex
description: updated
Alexey Kopytov (akopytov) wrote :

Confirmed. For some obscure reasons innobackupex converts it --tmpdir option to --target-dir when passing it to the xtrabackup binary.

Changed in percona-xtrabackup:
status: New → Triaged
importance: Undecided → Medium
Alexey Kopytov (akopytov) wrote :

Bug #1092186 was marked as a duplicate of this one.

Alexey Kopytov (akopytov) wrote :

Bug #1107543 was marked as a duplicate of this one.

summary: - incremental backups ignore --tmpdir argument
+ innobackupex does not pass --tmpdir to xtrabackup
Kurt Agius (kurteknikk) wrote :

Is there any way to temporarily work around this issue ? I really need to get this working quickly.

set tmpdir in my.cnf would work.
Don't forget to set back to original value.

--
Ren Xiaolei

2013/2/4 Kurt Agius <email address hidden>

> Is there any way to temporarily work around this issue ? I really need
> to get this working quickly.
>
> --
> You received this bug notification because you are subscribed to a
> duplicate bug report (1107543).
> https://bugs.launchpad.net/bugs/1085099
>
> Title:
> innobackupex does not pass --tmpdir to xtrabackup
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/percona-xtrabackup/+bug/1085099/+subscriptions
>

Kurt Agius (kurteknikk) wrote :

I was thinking to change it in the mysql my.cnf but i wasn't sure if it was safe enough since i'm working on a production system.
But then i realized i can just copy that config file, change it, and use the defaults file argument !

It seems to be working, at least i can continue, thanks a lot :)

Ovais Tariq (ovais-tariq) wrote :

You can also have a [xtrabackup] section in the my.cnf file, and you can specify the tmpdir there, for example the following works for me perfectly:
[xtrabackup]
tmpdir=/tmp/xb_tmp

tags: added: i29554
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers