Not the answer you need?
Register and ask your own question!

xtrabackup Error on line 2622

WishmasterWishmaster EntrantCurrent User Role Beginner
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.

Comments

  • WishmasterWishmaster Entrant Current User Role Beginner
    somebody help
  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Have you ever had a successful backup of this server? It is complaining about corruption, which is not good. I would try doing a mysqldump of the data and load it into a new MySQL instance, then try to do a binary backup of the new server using Xtrabackup. Often a logical backup (mysqldump) can get around simple corruption, so it is worth a shot.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.