Announcement

Announcement Module
Collapse
No announcement yet.

xtrabackup Error on line 2622

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • xtrabackup Error on line 2622

    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.



    Last edited by Wishmaster; 08-21-2014, 06:26 AM.

  • #2
    somebody help

    Comment


    • #3
      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.

      Comment

      Working...
      X