innobackupex fails on InnoDB cannot find the path specified File name ./ib_logfile0

MySQL & MariaDB Percona XtraBackup
1

I try to backup running (with no problem) MySQL instance, but percona hits error below which I can not overcome and do not understand the reason. Looks like InnoDB engine can not find it is own log…

Can some one help please? Any ideas?

Thanks
Ed

[I]innobackupex --parallel=6 --user=root --port=8091 --host=127.0.0.1 $TEMP_DEST --no-timestamp

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.

131107 09:37:21 innobackupex: Connecting to MySQL server with DSN ‘dbi:mysql:;mysql_read_default_group=xtrabackup;host=127.0.0.1;port=8091’ as ‘root’ (using password: NO).
131107 09:37:21 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.12-enterprise-commercial-advanced

innobackupex: Created backup directory /data/percona_backups/dbtuna/Thu_new

131107 09:37:21 innobackupex: Starting ibbackup with command: xtrabackup_56 --defaults-group=“mysqld” --backup --suspend-at-end --target-dir=/data/percona_backups/dbtuna/Thu_new --tmpdir=/tmp --parallel=6
innobackupex: Waiting for ibbackup (pid=15681) to suspend
innobackupex: Suspend file ‘/data/percona_backups/dbtuna/Thu_new/xtrabackup_suspended_2’

xtrabackup_56 version 2.1.5 for MySQL server 5.6.11 Linux (x86_64) (revision id: 680)
xtrabackup: uses posix_fadvise().
xtrabackup: cd to
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
2013-11-07 09:37:21 7fd957e1c720 InnoDB: Operating system error number 2 in a file operation.
InnoDB: The error means the system cannot find the path specified.
2013-11-07 09:37:21 7fd957e1c720 InnoDB: File name ./ib_logfile0
2013-11-07 09:37:21 7fd957e1c720 InnoDB: File operation call: ‘open’ returned OS error 71.
2013-11-07 09:37:21 7fd957e1c720 InnoDB: Cannot continue operation.
innobackupex: Error: The xtrabackup child process has died at /appdynamics/percona_xtrabackup/percona-xtrabackup-2.1.5-Linux-x86_64/bin/innobackupex line 2579.[/I]

2

Do you mean xtrabackup works for stock MySQL but fails on Percona Server ? Please send us the contents of my.cnf file and xtrabackup version you are using.

$ xtrabackup --version

3

Interesting fact - my-dbtuna.cnf (the my.cnf for the instance) does not have “datadir” parameter. Can that be the problem? Thanks.

> xtrabackup --version
xtrabackup version 2.1.5 for Percona Server 5.1.70 unknown-linux-gnu (x86_64) (revision id: 680)

> cat /appdynamics/AppD4db/mysql/my-dbtuna.cnf

The following options will be passed to all MySQL clients

[client]
#password = your_password
port = 8091
socket = /tmp/mysql.sock

Here follows entries for some specific programs

The MySQL server

[mysqld]
bind-address = 127.0.0.1
port = 8091
socket = /tmp/mysql.sock
key_buffer = 16M
max_allowed_packet = 64M
sort_buffer_size = 4M
read_buffer_size = 4M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 4M
thread_cache_size = 8
query_cache_size= 16M
max_connections=200
max_allowed_packet=128M
myisam_max_sort_file_size = 4292870144

Try number of CPU’s*2 for thread_concurrency

thread_concurrency = 8

server-id = 1

innodb_buffer_pool_size = 512M
#innodb_additional_mem_pool_size = 20M

Set …_log_file_size to 25 % of buffer pool size

innodb_log_file_size = 64M
innodb_log_buffer_size = 8M
#innodb_flush_log_at_trx_commit = 1
#innodb_lock_wait_timeout = 50
innodb_file_per_table

[mysqldump]
quick
max_allowed_packet = 16M

[mysql]
no-auto-rehash

Remove the next comment character if you are not familiar with SQL

#safe-updates

[isamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[myisamchk]
key_buffer = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M

[mysqlhotcopy]
interactive-timeout

4

Declare datadir in my.cnf and restart mysql and try again.