xtrabackup not handling barracuda compressed table format
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
| Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
Hello,
I am unable to run xtrabackup against a barracuda compressed table. Here is what happens:
xtrabackup --backup --target-
xtrabackup Ver 1.0 Rev 113 for 5.0.84 unknown-linux-gnu (x86_64)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /disk2/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
>> log scanned up to (243 3287007327)
Copying ./ibdata1
to /backup/ibdata1
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Error: 10 retries resulted in fail. This file seems to be corrupted.
xtrabackup: Error: xtrabackup_
xtrabackup: Error: failed to copy system datafile.
This happens on both machines where I am using the barracuda compressed table format with percona's mysql release. On the two machines where I am running stock mysql with innodb I am able to complete the backup successfully.
Changed in percona-xtrabackup: | |
assignee: | nobody → Aleksandr Kuzminsky (akuzminsky) |
vibhor (vibhor-chowdhary) wrote : | #2 |
An update on this. I built the xtrabackup binary using the source code using mysql-5.1.34.tar.gz (source) and the xtrabackup-
The build failed while compiling xtrabackup, so I had to edit the xtrabackup-
./xtrabackup --backup --target-
xtrabackup: tables regcomp(): Success
./xtrabackup Ver undefined Rev undefined for 5.1.34 unknown-linux-gnu (x86_64)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /disk2/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: use O_DIRECT
>> log scanned up to (88 3867384681)
Copying ./ibdata1
to /backup/ibdata1
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Database page corruption detected at page 64. retrying...
xtrabackup: Error: 10 retries resulted in fail. This file seems to be corrupted.
xtrabackup: Error: xtrabackup_
xtrabackup: Error: failed to copy system datafile.
Let me know if you need any more information. Perhaps my build method was flawed.
Regards
vibhor (vibhor-chowdhary) wrote : | #3 |
Forgot to add that I was unable to build the xtrabackup binary against the mysql-xtradb 5.1.34 source since patching fails. I will attempt to build against 5.1.34 with the InnoDB plugin.
I think that is the issue, since I didn't build it against the innodb-plugin (only vanilla mysql). So please disregard previous post.
Changed in percona-xtrabackup: | |
status: | New → Fix Committed |
status: | Fix Committed → Confirmed |
assignee: | Aleksandr Kuzminsky (akuzminsky) → Yasufumi Kinoshita (yasufumi-kinoshita) |
The fix have been pushed.
http://
Changed in percona-xtrabackup: | |
status: | Confirmed → Fix Committed |
Changed in percona-xtrabackup: | |
status: | Fix Committed → Fix Released |
Shahriyar Rzayev (rzayev-sehriyar) wrote : | #5 |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
Naturally, "for 5.0" version cannot treat Barracuda.
Building with InnoDB-Plugin is needed.