Percona XtraBackup moved to https://jira.percona.com/projects/PXB

xtrabackup doesn't report file name in error message

Bug #766033 reported by Baron Schwartz
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
Wishlist
Sergei Glushchenko
Percona XtraBackup moved to https://jira.percona.com/projects/PXB 1.9.2
2.0
Fix Released
Wishlist
Sergei Glushchenko
Percona XtraBackup moved to https://jira.percona.com/projects/PXB 1.9.2

Bug Description

XtraBackup has discovered corruption, but it doesn't say which file. This is really unhelpful -- can we make it report the file name it's trying to copy?

>> log scanned up to (3641358646355)
>> log scanned up to (3641358726531)
>> log scanned up to (3641358801203)
>> log scanned up to (3641358901725)
>> log scanned up to (3641358966742)
>> log scanned up to (3641359056359)
>> log scanned up to (3641359179243)
>> log scanned up to (3641359254766)
>> log scanned up to (3641359432127)
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Database page corruption detected at page 2047850.
retrying...
[01] xtrabackup: Error: 10 retries resulted in fail. Thisfile seems to be
corrupted.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.

Tags: cr fr i14619

Related branches

lp:~sergei.glushchenko/percona-xtrabackup/bug766033-filename-error
Stewart Smith (community): Approve
Diff: 50 lines (+31/-3)
2 files modified
src/xtrabackup.c (+3/-3)
test/t/bug766033.sh (+28/-0)
Revision history for this message
Baron Schwartz (baron-xaprb) wrote :

This is Percona customer case number 14619.

Alexey Kopytov (akopytov)
tags: added: cr
Changed in percona-xtrabackup:
assignee: nobody → Alexey Kopytov (akopytov)
status: New → In Progress
Revision history for this message
Alexey Kopytov (akopytov) wrote :

XtraBackup does report the file name when starting to copy the file:

xtrabackup_55 Ver undefined Rev undefined for 5.5.9 osx10.6 (i386)
[01] Copying ./ibdata1
     to /Users/kaa/src/percona/percona-xtrabackup/test/var/backup/2011-04-18_08-49-52/ibdata1
[01] ...done
[01] Copying ./incremental_sample/test.ibd
     to /Users/kaa/src/percona/percona-xtrabackup/test/var/backup/2011-04-18_08-49-52/incremental_sample/test.ibd

So it should be possible to figure out the file where the error has occurred. It's just that the log in the bug report is truncated.

Changed in percona-xtrabackup:
status: In Progress → Invalid
Revision history for this message
Alexey Kopytov (akopytov) wrote :

As discussed elsewhere, it would be nice to have XtraBackup mention the file name along with the error, e.g. "failed to copy test.ibd" rather than "failed to copy datafile."

Since that is a reasonable feature request, reopening the bug.

Changed in percona-xtrabackup:
status: Invalid → New
Valentine Gostev (longbow)
tags: added: fr
tags: added: i14619
Valentine Gostev (longbow)
Changed in percona-xtrabackup:
importance: Undecided → Wishlist
Stewart Smith (stewart)
Changed in percona-xtrabackup:
status: New → Triaged
Sergei Glushchenko (sergei.glushchenko)
Changed in percona-xtrabackup:
assignee: Alexey Kopytov (akopytov) → Sergei Glushchenko (sergei.glushchenko)
status: Triaged → In Progress
status: In Progress → Fix Committed
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-975

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

Other bug subscribers

Remote bug watches

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