2012-11-30 16:25:41 |
navigator93 |
bug |
|
|
added bug |
2012-11-30 16:25:56 |
navigator93 |
tags |
|
innobackupex |
|
2012-11-30 16:26:50 |
navigator93 |
description |
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 |
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 |
|
2012-12-02 13:47:13 |
Alexey Kopytov |
percona-xtrabackup: status |
New |
Triaged |
|
2012-12-02 13:47:15 |
Alexey Kopytov |
percona-xtrabackup: importance |
Undecided |
Medium |
|
2012-12-02 13:47:22 |
Alexey Kopytov |
nominated for series |
|
percona-xtrabackup/2.0 |
|
2012-12-02 13:47:22 |
Alexey Kopytov |
bug task added |
|
percona-xtrabackup/2.0 |
|
2012-12-02 13:47:22 |
Alexey Kopytov |
nominated for series |
|
percona-xtrabackup/2.1 |
|
2012-12-02 13:47:22 |
Alexey Kopytov |
bug task added |
|
percona-xtrabackup/2.1 |
|
2012-12-02 13:47:29 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
New |
Confirmed |
|
2012-12-02 13:47:33 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
Confirmed |
Triaged |
|
2012-12-02 13:47:35 |
Alexey Kopytov |
percona-xtrabackup/2.0: importance |
Undecided |
Medium |
|
2013-01-28 06:42:58 |
Alexey Kopytov |
summary |
incremental backups ignore --tmpdir argument |
innobackupex does not pass --tmpdir to xtrabackup |
|
2013-02-18 10:53:25 |
Ovais Tariq |
tags |
innobackupex |
i29554 innobackupex |
|
2013-02-18 10:54:00 |
Ovais Tariq |
bug |
|
|
added subscriber Ovais Tariq |
2013-02-18 11:31:24 |
Alexey Kopytov |
percona-xtrabackup/2.0: milestone |
|
2.0.6 |
|
2013-02-18 11:31:29 |
Alexey Kopytov |
percona-xtrabackup/2.1: milestone |
|
2.1-pre-initial-release |
|
2013-03-06 09:20:50 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
Triaged |
In Progress |
|
2013-03-06 09:20:52 |
Alexey Kopytov |
percona-xtrabackup/2.0: assignee |
|
Alexey Kopytov (akopytov) |
|
2013-03-06 09:20:55 |
Alexey Kopytov |
percona-xtrabackup/2.1: assignee |
|
Alexey Kopytov (akopytov) |
|
2013-03-06 10:04:46 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
In Progress |
Fix Committed |
|
2013-03-06 10:04:49 |
Alexey Kopytov |
branch linked |
|
lp:~akopytov/percona-xtrabackup/bug1085099-2.0 |
|
2013-03-06 11:40:10 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
Triaged |
Fix Committed |
|
2013-03-06 11:40:15 |
Alexey Kopytov |
branch linked |
|
lp:~akopytov/percona-xtrabackup/bug1085099-2.1 |
|
2013-03-11 12:24:12 |
Alexey Kopytov |
percona-xtrabackup/2.1: status |
Fix Committed |
Fix Released |
|
2013-03-11 12:29:17 |
Alexey Kopytov |
percona-xtrabackup/2.0: status |
Fix Committed |
Fix Released |
|