GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

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

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

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

    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;ho st=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.

  • #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

    Comment


    • #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

      Comment


      • #4
        Declare datadir in my.cnf and restart mysql and try again.

        Comment

        Working...
        X