Announcement Module
No announcement yet.

Got "/ib_logfile0 is of different size" when doing stream backup

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

  • Got "/ib_logfile0 is of different size" when doing stream backup


    We got an error "InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytes" when doing stream backup on Ubuntu 12.04

    MySQL Server: 5.5.37-0ubuntu0.12.04.1
    Xtrabackup: 2.2.3-4982-1.precise

    Command: /usr/bin/innobackupex --ibbackup xtrabackup --password XXXX --user 'scalr' --stream xbstream /mnt/dbstorage/tmp


    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:
    140623 12:50:05  innobackupex: Connecting to MySQL server with DSN 'dbi:mysql:;mysql_read_default_group=xtrabackup' as 'scalr'  (using password: YES).
    140623 12:50:05  innobackupex: Connected to MySQL server
    140623 12:50:05  innobackupex: Executing a version check against the server...
    140623 12:50: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.12.04.1-log
    innobackupex: Created backup directory /mnt/dbstorage/tmp
    140623 12:50:06  innobackupex: Starting ibbackup with command: xtrabackup  --defaults-group="mysqld" --backup --suspend-at-end --target-dir=/tmp --tmpdir=/tmp --extra-lsndir='/tmp' --stream=xbstream
    innobackupex: Waiting for ibbackup (pid=7964) to suspend
    innobackupex: Suspend file '/tmp/xtrabackup_suspended_2'
    xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
    xtrabackup: uses posix_fadvise().
    xtrabackup: cd to /mnt/dbstorage/mysql-data
    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
    InnoDB: Error: log file ./ib_logfile0 is of different size 5242880 bytes
    InnoDB: than specified in the .cnf file 50331648 bytes!
    innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2672.

    $ my_print_defaults mysqld