Not the answer you need?
Register and ask your own question!

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

egodlevskyegodlevsky EntrantInactive User Role Participant
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



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.

Comments

  • mirfanmirfan Database Administrator Inactive User Role Mentor
    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
  • egodlevskyegodlevsky Entrant Inactive User Role Participant
    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
  • mirfanmirfan Database Administrator Inactive User Role Mentor
    Declare datadir in my.cnf and restart mysql and try again.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.