# Backup error: log file ./ib\_logfile0 is of different size 268435456 bytes

**URL:** <https://forums.percona.com/t/backup-error-log-file-ib-logfile0-is-of-different-size-268435456-bytes/3142>\
**Category:** Percona XtraBackup\
**Created:** [December 10, 2013, 5:29am UTC](https://forums.percona.com/t/backup-error-log-file-ib-logfile0-is-of-different-size-268435456-bytes/3142 "2013-12-10T05:29:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Clark](https://avatars.discourse-cdn.com/v4/letter/c/6de8d8/32.png) [@Clark](https://forums.percona.com/u/Clark)\
**Post date:** [December 10, 2013, 5:29am UTC](https://forums.percona.com/t/backup-error-log-file-ib-logfile0-is-of-different-size-268435456-bytes/3142/1 "2013-12-10T05:29:53Z")

</div>

After using a percona optimized .cnf file the backup fails

## CNF:

# Generated by Percona Configuration Wizard ([http://tools.percona.com/](http://tools.percona.com/)) version REL5-20120208

[client]

# CLIENT

port = 3306  
socket = /var/run/mysqld/mysqld.sock

[mysqld]

# GENERAL

user = mysql  
default\_storage\_engine = InnoDB  
pid\_file = /var/run/mysqld/mysqld.pid  
socket = /var/run/mysqld/mysqld.sock  
basedir = /usr/local/mysql  
tmpdir = /tmp

# MyISAM

key\_buffer\_size = 32M  
myisam\_recover = FORCE,BACKUP

# SAFETY

max\_allowed\_packet = 16M  
max\_connect\_errors = 1000000  
skip\_name\_resolve  
sql\_mode = STRICT\_TRANS\_TABLES,NO\_AUTO\_CREATE\_USER,NO\_ENGINE\_SUBSTITUTION  
sysdate\_is\_now = 1  
innodb = FORCE  
innodb\_strict\_mode = 1  
bind\_address = 127.0.0.1

# DATA STORAGE

datadir = /var/lib/mysql

# BINARY LOGGING

log\_bin = /var/lib/mysql/mysql-bin  
expire\_logs\_days = 14  
max\_binlog\_size = 100M  
sync\_binlog = 1

# CACHES AND LIMITS

tmp\_table\_size = 32M  
max\_heap\_table\_size = 32M  
query\_cache\_type = 0  
query\_cache\_size = 0  
max\_connections = 500  
thread\_cache\_size = 50  
open\_files\_limit = 65535  
table\_definition\_cache = 1024  
table\_open\_cache = 2048

# INNODB

innodb\_flush\_method = O\_DIRECT  
innodb\_log\_files\_in\_group = 2  
innodb\_log\_file\_size = 256M  
innodb\_flush\_log\_at\_trx\_commit = 2  
innodb\_file\_per\_table = 1  
innodb\_buffer\_pool\_size = 6G

# LOGGING

log\_error = /var/lib/mysql/mysql-error.log  
log\_queries\_not\_using\_indexes = 1  
slow\_query\_log = 1  
slow\_query\_log\_file = /var/lib/mysql/mysql-slow.log

lc\_messages\_dir = /opt/mysql/server-5.6/share/english

## LOG:

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.

131210 11:53:50 innobackupex: Connecting to MySQL server with DSN ‘dbi:mysql:;mysql\_read\_default\_group=xtrabackup’ as ‘root’ (using password: YES).  
131210 11:53:50 innobackupex: Connected to MySQL server  
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.6.14-log

innobackupex: Created backup directory /var/www/dyntest.dk

131210 11:53:50 innobackupex: Starting ibbackup with command: xtrabackup\_56 --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/tmp --tmpdir=/tmp --stream=tar  
innobackupex: Waiting for ibbackup (pid=6728) to suspend  
innobackupex: Suspend file ‘/tmp/xtrabackup\_suspended\_2’

xtrabackup\_56 version 2.1.5 for MySQL server 5.6.11 Linux (x86\_64) (revision id: undefined)  
xtrabackup: uses posix\_fadvise().  
xtrabackup: cd to /var/lib/mysql  
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 268435456 bytes  
InnoDB: than specified in the .cnf file 50331648 bytes!  
innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2579.