Announcement

Announcement Module
Collapse
No announcement yet.

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

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

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

    Hello,

    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

    Log:

    Code:
    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
    
    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.

    Code:
    $ my_print_defaults mysqld
    --user=mysql
    --pid-file=/var/run/mysqld/mysqld.pid
    --socket=/var/run/mysqld/mysqld.sock
    --port=3306
    --basedir=/usr
    --datadir=/mnt/dbstorage/mysql-data
    --tmpdir=/tmp
    --lc-messages-dir=/usr/share/mysql
    --skip-external-locking
    --key_buffer=16M
    --max_allowed_packet=16M
    --thread_stack=192K
    --thread_cache_size=8
    --myisam-recover=BACKUP
    --query_cache_limit=1M
    --query_cache_size=16M
    --log_error=/var/log/mysql/error.log
    --expire_logs_days=10
    --max_binlog_size=100M
    --log-bin-index=/mnt/dbstorage/mysql-misc/binlog.index
    --sync_binlog=1
    --innodb_buffer_pool_size=16M
    --innodb_flush_log_at_trx_commit=1
    --log_bin=/mnt/dbstorage/mysql-misc/binlog
    --server-id=1
Working...
X