parallel option breaks incremental backups
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
High
|
Alexey Kopytov | ||
1.6 |
Fix Released
|
High
|
Alexey Kopytov | ||
2.0 |
Fix Released
|
High
|
Alexey Kopytov |
Bug Description
The --parallel option causes lots of different 'random' failures.
Overall the parallel option seems very unstable, the only way I can get working backups is to not use --parallel.
Without --parallel my backups and restores works.
I am using xtrabackup 1.6.2 with MySQL 5.5.10 on Ubuntu server 10.04 64 bit.
My server is configured as "innodb_
-------
An incremental backup with --parallel=4 succeeds without any errors.
But when later trying to restore such backups there are lots of corrupted .delta files.
Error messages look like this during the restore script fails:
Applying /media/
xtrabackup: error: /media/
xtrabackup: Error: xtrabackup_
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/
-------
Performing full backups with --parallel=4 also causes the backups to fail at random places.
Error messages then looks like this:
>> log scanned up to (843532850219)
>> log scanned up to (843532850219)
innobackupex: Error: ibbackup child process has died at /usr/bin/
Related branches
- Stewart Smith (community): Approve
-
Diff: 355 lines (+124/-51)8 files modifiedVERSION (+1/-1)
innobackupex (+1/-1)
test/inc/sakila-db/sakila-data.sql (+1/-22)
test/inc/sakila-db/sakila-schema.sql (+22/-0)
test/t/ib_binlog_info.sh (+14/-0)
test/t/xb_parallel.sh (+1/-1)
test/t/xb_parallel_incremental.sh (+58/-0)
xtrabackup.c (+26/-26)
- Stewart Smith (community): Approve
-
Diff: 316 lines (+108/-49)5 files modifiedtest/inc/sakila-db/sakila-data.sql (+1/-22)
test/inc/sakila-db/sakila-schema.sql (+22/-0)
test/t/xb_parallel.sh (+1/-1)
test/t/xb_parallel_incremental.sh (+58/-0)
xtrabackup.c (+26/-26)
Changed in percona-xtrabackup: | |
importance: | Undecided → High |
Changed in percona-xtrabackup: | |
assignee: | nobody → Patrick Crews (patrick-crews) |
Is your server under load when this is happening?
Also, if this is the case, could you describe the load (SELECT / INSERT / UPDATE / DELETE)? This will help us in duplicating / diagnosing the problem greatly.