Xtrabackup InnoDB checksum mismatch

[JF Dignard]

Hi,

I'm new to using Xtrabackup and have the following issue. I'm using MariaDB 10.0.13 with Xtrabackup 2.1.9 on CentOS 6.6.

In MariaDB, I'm using innodb_checksum_algorithm crc32. When I try to do a backup using the following command it fails. When innodb_checksum_algorithm is using the default innodb value, backing up works using Xtrabackup.

/usr/local/xtrabackup/xtrabackup_base/bin/innobackupex --stream=tar --defaults-file=/usr/local/mariadb/mariadb_base/etc/my.cnf --galera-info --user=dbUser --password='dbPassword' --no-timestamp --ibbackup=/usr/local/xtrabackup/xtrabackup_base/bin/xtrabackup_55 /var/broadworks/persistent

The error message is the following:

InnoDB: Error: checksum mismatch in data file ./ibdata1
xtrabackup: Could not open or create data files.
xtrabackup: If you tried to add new data files, and it failed here,
xtrabackup: you should now edit innodb_data_file_path in my.cnf back
xtrabackup: to what it was, and remove the new ibdata files InnoDB created
xtrabackup: in this failed attempt. InnoDB only wrote those files full of
xtrabackup: zeros, but did not yet use them in any way. But be careful: do not
xtrabackup: remove old data files which contain your precious data!
xtrabackup: error: xb_load_tablespaces() failed witherror code 11
innobackupex: Error: The xtrabackup child process has died at /usr/local/xtrabackup/xtrabackup_base/bin/innobackupex line 2622.

The whole log is below:

InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013.  All Rights Reserved.


This software is published under
the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.


Get the latest version of Percona XtraBackup, documentation, and help resources:
http://www.percona.com/xb/redhatenterpriseserver


150505 12:35:07  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_file=/usr/local/mariadb/mariadb_base/etc/my.cnf;mysql_read_default_group=xtrabackup' as 'bwadmin'  (using password: YES).
150505 12:35:07  innobackupex: Connected to MySQL server
150505 12:35:07  innobackupex: Executing a version check against the server...
150505 12:35:08  innobackupex: Done.
IMPORTANT: Please check that the backup run completes successfully.
           At the end of a successful backup run innobackupex
           prints "completed OK!".


innobackupex: Using mysql server version 10.0.13-MariaDB-wsrep


innobackupex: Created backup directory /var/broadworks/persistent


150505 12:35:08  innobackupex: Starting ibbackup with command: /usr/local/xtrabackup/xtrabackup_base/bin/xtrabackup_55  --defaults-file="/usr/local/mariadb/mariadb_base/etc/my.cnf"  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp --tmpdir=/tmp --stream=tar
innobackupex: Waiting for ibbackup (pid=10785) to suspend
innobackupex: Suspend file '/tmp/xtrabackup_suspended_2'


/usr/local/xtrabackup/xtrabackup_base/bin/xtrabackup_55 version 2.1.9 for MySQL server 5.5.35 Linux (x86_64) (revision id: undefined)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/broadworks/persistent
xtrabackup: open files limit requested 0, set to 64000
xtrabackup: using the following InnoDB configuration:
xtrabackup:   innodb_data_home_dir = ./
xtrabackup:   innodb_data_file_path = ibdata1:10M:autoextend
xtrabackup:   innodb_log_group_home_dir = ./
xtrabackup:   innodb_log_files_in_group = 2
xtrabackup:   innodb_log_file_size = 50331648
>> log scanned up to (1657822)
InnoDB: Error: checksum mismatch in data file ./ibdata1
xtrabackup: Could not open or create data files.
xtrabackup: If you tried to add new data files, and it failed here,
xtrabackup: you should now edit innodb_data_file_path in my.cnf back
xtrabackup: to what it was, and remove the new ibdata files InnoDB created
xtrabackup: in this failed attempt. InnoDB only wrote those files full of
xtrabackup: zeros, but did not yet use them in any way. But be careful: do not
xtrabackup: remove old data files which contain your precious data!
xtrabackup: error: xb_load_tablespaces() failed witherror code 11
innobackupex: Error: The xtrabackup child process has died at /usr/local/xtrabackup/xtrabackup_base/bin/innobackupex line 2622.

Thanks for your help,

JF

[JF Dignard]

Hi,

I upgraded to Xtrabackup 2.2.10 and it worked.

Is it possible to find a release note which state when support for crcc32 was introduced in Xtrabackup?

Thanks,

JF

...