GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

error while prepare the incremental backups

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

  • error while prepare the incremental backups

    I tried full backup prepare
    ============================
    [root@mytestmachine]# xtrabackup_51 --prepare --apply-log-only --target-dir=/root/backup/allbackup/1/2012-09-09_00-12-52
    xtrabackup_51 version 2.0.2 for MySQL server 5.1.59 unknown-linux-gnu (x86_64) (revision id: 461)
    xtrabackup: cd to /root/backup/allbackup/1/2012-09-09_00-12-52
    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 = ibdata1:10M:autoextend
    xtrabackup: innodb_log_group_home_dir = ./
    xtrabackup: innodb_log_files_in_group = 2
    xtrabackup: innodb_log_file_size = 5242880
    xtrabackup: Temporary instance for recovery is set as followings.
    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 = 5242880
    xtrabackup: Starting InnoDB instance for recovery.
    xtrabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
    InnoDB: The InnoDB memory heap is disabled
    120913 13:34:32 InnoDB: Initializing buffer pool, size = 100.0M
    120913 13:34:32 InnoDB: Completed initialization of buffer pool

    [notice (again)]
    If you use binary log and don't use any hack of group commit,
    the binary log position seems to be:
    InnoDB: Last MySQL binlog file position 0 867857238, file name ./mysql-bin.002108

    xtrabackup: starting shutdown with innodb_fast_shutdown = 1
    120913 13:34:32 InnoDB: Starting shutdown...
    120913 13:34:32 InnoDB: Shutdown completed; log sequence number 412 872729100
    ==================================
    I facing the error while prepare the incremental backups
    This is the error I facing here
    [root@mytestmachine]# xtrabackup_51 --prepare --apply-log-only --incremental-lsn='412 872729100' --target-dir=/root/backup/allbackup/1/2012-09-09_00-12-52/ --incremental-dir=/root/backup/allbackup/2/2012-09-10_00-06- 25/
    xtrabackup: error: failed to read metadata from /root/backup/allbackup/2/2012-09-10_00-06-25//xtrabackup_che ckpoints

    mysql and os details
    ====================
    Mysql version details
    ======================
    # mysqld_multi --version
    mysqld_multi version 2.16 by Jani Tolonen
    # mysql --version
    mysql Ver 14.14 Distrib 5.5.23, for linux2.6 (x86_64) using readline 5.1

    linux OS details
    =================
    Linux version 2.6.35.13-32 (root@linux) (gcc version 4.2.4)/x86_64



    Kindly help me to figure out the problem

    Thanks
    raj

  • #2
    Raj ,

    You are using xtrabackup_51 for mysql 5.5.23, please take a look to this link that explains which binary you have to use for each mysql version.

    http://www.percona.com/doc/percona-xtrabackup/xtrabackup_bin /choosing_binary.html

    Martin.

    Comment


    • #3
      Hi Martin,

      Thank you very much. I will work according to this and let u know about the result.

      Thanks
      raj

      Comment


      • #4
        Hi Martin,

        I tried as u said but this results the following error

        xtrabackup_55 version 2.0.2 for Percona Server 5.5.16 Linux (x86_64) (revision id: 461)
        incremental backup from 1770399254661 is enabled.
        xtrabackup: cd to /root/backup/allbackup/1/2012-09-09_00-12-52/
        xtrabackup: This target seems to be already prepared.
        xtrabackup: error: This incremental backup seems not to be proper for the target.
        xtrabackup: Check 'to_lsn' of the target and 'from_lsn' of the incremental.

        I prepared the full backup using xtrabackup_51 but if I Try to prepare again for full backup using xtrabackup_55 means this shows this backup seems to be already prepared.I continue with incremental backup prepare means this shows the above error.So,how can i prepare full backup in fresh(I mean I need to prepare the full backup from beginning).Or do u have the any other suggestion for this lsn mismatch error.pls help me

        Thanks
        raj

        Comment


        • #5
          Raj,

          Remember to remove your old backup and start from scratch. Here you have a recipe to make an incremental backup with xtrabackup.

          http://www.percona.com/doc/percona-xtrabackup/howtos/recipes _xbk_inc.html

          Martin.

          Comment


          • #6
            Martin,

            Thanks for your valuable solution


            Thanks again
            raj

            Comment

            Working...
            X