innobackupex does not pass --tmpdir to xtrabackup

Bug #1085099 reported by navigator93
50
This bug affects 7 people
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
Medium
Alexey Kopytov
2.0
Fix Released
Medium
Alexey Kopytov
2.1
Fix Released
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

Related branches

tags: added: innobackupex
description: updated
Revision history for this message
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
Revision history for this message
Alexey Kopytov (akopytov) wrote :

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

Revision history for this message
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
Revision history for this message
Kurt Agius (kurteknikk) wrote :

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

Revision history for this message
Ren Xiaolei (julyclyde) wrote : Re: [Bug 1085099] Re: innobackupex does not pass --tmpdir to xtrabackup

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
>

Revision history for this message
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 :)

Revision history for this message
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
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

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

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.