# Xtrabackup 2.3.x Creating Log Files With Incorrect Size

**URL:** <https://forums.percona.com/t/xtrabackup-2-3-x-creating-log-files-with-incorrect-size/4521>\
**Category:** Percona XtraBackup\
**Created:** [November 16, 2015, 11:51am UTC](https://forums.percona.com/t/xtrabackup-2-3-x-creating-log-files-with-incorrect-size/4521 "2015-11-16T11:51:25Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![suwalski](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/suwalski/32/1098_2.png) [@suwalski](https://forums.percona.com/u/suwalski)\
**Post date:** [November 16, 2015, 11:51am UTC](https://forums.percona.com/t/xtrabackup-2-3-x-creating-log-files-with-incorrect-size/4521/1 "2015-11-16T11:51:25Z")

</div>

Hello,

I’ve been using innobackupex weekly for years now without any issue on a fairly large database (1.6T).

With recent versions, my backup fails to create a launchable database after the --apply-log step. Yes, the command definitely reaches the “completed OK!” stage. I do not see anything unusual in the output.

The backup-my.cnf file has the correct parameters:

```auto
# This MySQL options file was generated by innobackupex.

# The MySQL server
[mysqld]
innodb_checksum_algorithm=innodb
innodb_log_checksum_algorithm=innodb
innodb_data_file_path=ibdata1:1024M:autoextend
innodb_log_files_in_group=2
innodb_log_file_size=268435456
innodb_fast_checksum=false
innodb_page_size=16384
innodb_log_block_size=512
innodb_undo_directory=.
innodb_undo_tablespaces=0

```

However, after the process completes, I’m left with:

```auto
-rw-r--r-- 1 mysql mysql 50331648 Nov 15 16:24 ib_logfile0
-rw-r--r-- 1 mysql mysql 50331648 Nov 15 16:24 ib_logfile1

```

At this point, mysql fails to start:

```auto
InnoDB: Error: log file ./ib_logfile0 is of different size 0 50331648 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
151115 16:24:54 [ERROR] Plugin 'InnoDB' init function returned error.
151115 16:24:54 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
151115 16:24:54 [ERROR] Unknown/unsupported storage engine: InnoDB
151115 16:24:54 [ERROR] Aborting

```

Deleting the files allows the database to start, albeit with some potentially serious warnings:

```auto
151116 11:13:05 InnoDB: Log file ./ib_logfile0 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile0 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
151116 11:13:06 InnoDB: Log file ./ib_logfile1 did not exist: new to be created
InnoDB: Setting log file ./ib_logfile1 size to 256 MB
InnoDB: Database physically writes the file full: wait...
InnoDB: Progress in MB: 100 200
151116 11:13:08 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
151116 11:13:08 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...

```

My analysis:

It occurs to me that 50331648÷1024÷1024=48, so the log file size is getting a bad value somewhere along the way. This value does not show up anywhere in my.cnf. But it is worth noting that the 256M logfile size is specified under a mysqld\_multi configuration, in the [mysqld1] section. Perhaps it is not getting parsed somewhere.

Thanks for looking.

---

<div class="post-metadata">

**Author:** ![suwalski](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/suwalski/32/1098_2.png) [@suwalski](https://forums.percona.com/u/suwalski)\
**Post date:** [December 21, 2015, 10:24am UTC](https://forums.percona.com/t/xtrabackup-2-3-x-creating-log-files-with-incorrect-size/4521/2 "2015-12-21T10:24:41Z")

</div>

This is still happening with 2.3.3. I’ve opened up a bug: [url][https://bugs.launchpad.net/percona-xtrabackup/+bug/1528271[/url]](https://bugs.launchpad.net/percona-xtrabackup/+bug/1528271%5B/url%5D)
