Hi all,
I have a problem when i trying create backup my database on my mysql server
ibdata1 size 145GB (zabbix and redmine) mysql 5.5.7 Innodb.
Error is occurs when copied about 50 per cent of the entire database.
innobackupex --defaults-file=/etc/mysql/my.cnf --no-timestamp --rsync /tmp/backup/mysqlXtra 2>&1
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/p
140821 15:13:06 innobackupex: Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_file=/etc/mysql/my.cnf;mysql_read_default_group=xtrabackup’ as ‘root’ (using password: YES).
140821 15:13:06 innobackupex: Connected to MySQL server
140821 15:13:06 innobackupex: Executing a version check against the server…
140821 15:13:06 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 5.5.37-0ubuntu0.13.10.1
innobackupex: Created backup directory /tmp/backup/mysqlXtra
140821 15:13:06 innobackupex: Starting ibbackup with command: xtrabackup_55 --defaults-file=“/etc/mysql/my.cnf” --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/tmp/backup/mysqlXtra --tmpdir=/tmp
innobackupex: Waiting for ibbackup (pid=19736) to suspend
innobackupex: Suspend file ‘/tmp/backup/mysqlXtra/xtrabackup_suspended_2’
xtrabackup_55 version 2.1.9 for Percona Server 5.5.35 Linux (x86_64) (revision id: undefined)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: open files limit requested 0, set to 1024
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 (1079534320259)
[01] Copying ./ibdata1 to /tmp/backup/mysqlXtra/ibdata1
log scanned up to (1079534364508)
log scanned up to (1079534433977)
log scanned up to (1079402252204)
log scanned up to (1079402260901)
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
log scanned up to (1079402295929)
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
[01] xtrabackup: Database page corruption detected at page 3518863, retrying…
[01] xtrabackup: Error: failed to read page after 10 retries. File ./ibdata1 seems to be corrupted.
[01] xtrabackup: Error: xtrabackup_copy_datafile() failed.
[01] xtrabackup: Error: failed to copy datafile.
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2622.