Announcement

Announcement Module
Collapse
No announcement yet.

Xtrabackup prepare warning

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

  • Xtrabackup prepare warning


    Hi,
    I tried to compressed backup & recovery test.
    The backup compression was successfully finished. But, When I execute "prepare" the backup-set, it was failed.
    (It could not found binary log file and position. )

    - MySQL version is 5.6.10
    - xtrabackup-2.0.6

    I hope someone who know about this warning, help me.


    1. When I tried backup, I executed this command.

    ./percona-xtrabackup-2.0.6/bin/xtrabackup_56 --defaults-file=/etc/my.cnf --target-dir=/backup1/Compress_Back --backup --compress

    ./xtrabackup_56 version 2.0.6 for MySQL server 5.6.10 Linux (x86_64) (revision id: undefined)
    xtrabackup: uses posix_fadvise().
    xtrabackup: cd to /data1/mysql
    xtrabackup: Target instance is assumed as followings.
    xtrabackup: innodb_data_home_dir =
    xtrabackup: innodb_data_file_path = /data1/ibdata1:5G;
    xtrabackup: innodb_log_group_home_dir = /data1/mysqllog
    xtrabackup: innodb_log_files_in_group = 3
    xtrabackup: innodb_log_file_size = 225443840
    2013-05-13 10:49:19 2ab938f72f90 InnoDB: Using Linux native AIO
    >> log scanned up to (79082747)
    [01] Compressing /data1/ibdata1 to /backup1/Compress_Back/ibdata1.qp
    >> log scanned up to (79082747)
    >> log scanned up to (79082747)
    >> log scanned up to (79082747)
    >> log scanned up to (79082747)
    >> log scanned up to (79082747)
    >> log scanned up to (79082747)
    [01] ...done
    [01] Compressing ./hong/ttt.ibd to /backup1/Compress_Back/./hong/ttt.ibd.qp
    >> log scanned up to (79082747)
    [01] ...done
    [01] Compressing ./hong/xxx.ibd to /backup1/Compress_Back/./hong/xxx.ibd.qp
    [01] ...done
    [01] Compressing ./mysql/slave_worker_info.ibd to /backup1/Compress_Back/./mysql/slave_worker_info.ibd.qp
    [01] ...done
    [01] Compressing ./mysql/slave_master_info.ibd to /backup1/Compress_Back/./mysql/slave_master_info.ibd.qp
    [01] ...done
    [01] Compressing ./mysql/slave_relay_log_info.ibd to /backup1/Compress_Back/./mysql/slave_relay_log_info.ibd.qp
    [01] ...done
    [01] Compressing ./mysql/innodb_index_stats.ibd to /backup1/Compress_Back/./mysql/innodb_index_stats.ibd.qp
    [01] ...done
    [01] Compressing ./mysql/innodb_table_stats.ibd to /backup1/Compress_Back/./mysql/innodb_table_stats.ibd.qp
    [01] ...done
    xtrabackup: The latest check point (for incremental): '79082747'
    xtrabackup: Stopping log copying thread.
    .>> log scanned up to (79082747)


    2. execute prepare command, it was failed.

    ./percona-xtrabackup-2.0.6/bin/xtrabackup_56 --defaults-file=/etc/my.cnf --target-dir=/backup1/Compress_Back --prepare
    ./xtrabackup_56 version 2.0.6 for MySQL server 5.6.10 Linux (x86_64) (revision id: undefined)
    xtrabackup: cd to /backup1/Compress_Back
    xtrabackup: This target seems to be already prepared.
    xtrabackup: notice: xtrabackup_logfile was already used to '--prepare'.
    xtrabackup: Temporary instance for recovery is set as followings.
    xtrabackup: innodb_data_home_dir = ./
    xtrabackup: innodb_data_file_path = /data1/ibdata1:5G;
    xtrabackup: innodb_log_group_home_dir = ./
    xtrabackup: innodb_log_files_in_group = 3
    xtrabackup: innodb_log_file_size = 225443840
    2013-05-13 10:53:51 2ab24e32ef90 InnoDB: Using Linux native AIO
    xtrabackup: Temporary instance for recovery is set as followings.
    xtrabackup: innodb_data_home_dir = ./
    xtrabackup: innodb_data_file_path = /data1/ibdata1:5G;
    xtrabackup: innodb_log_group_home_dir = ./
    xtrabackup: innodb_log_files_in_group = 3
    xtrabackup: innodb_log_file_size = 225443840
    2013-05-13 10:53:51 2ab24e32ef90 InnoDB: Using Linux native AIO
    xtrabackup: Starting InnoDB instance for recovery.
    xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
    InnoDB: Progress in MB: 100 200
    InnoDB: Progress in MB: 100 200
    InnoDB: Progress in MB: 100 200

    [notice (again)]
    If you use binary log and don't use any hack of group commit,
    the binary log position seems to be:

    xtrabackup: ################################################## ######
    xtrabackup: # !!WARNING!! #
    xtrabackup: # The transaction log file is corrupted. #
    xtrabackup: # The log was not applied to the intended LSN! #
    xtrabackup: ################################################## ######
    xtrabackup: The intended lsn is 79082747
    xtrabackup: starting shutdown with innodb_fast_shutdown = 1



    Last edited by jmhong; 05-12-2013, 10:32 PM.

  • #2
    See http://www.percona.com/doc/percona-x...ompressed.html

    Comment


    • #3
      Can I use only innobackupex when compress the backup-set ? I'd like to use xtrabackup binary.. ( innodb tables backup only )

      Comment

      Working...
      X