Announcement

Announcement Module
Collapse
No announcement yet.

File name ./ib_logfile0 InnoDB: File operation call: 'open' returned OS error 71.

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

  • File name ./ib_logfile0 InnoDB: File operation call: 'open' returned OS error 71.

    === Problem solved. See last comment. ===

    Like others, I have encountered an error with innobackupex stating cannot find path specified. I tried both version 2.1.7 and 2.0.8 with similar results. I am running MySQL 5.6.15 on RHEL 6.4. I have not used innobackupex on this machine before, although I have used it against 5.5 dbs on other machines.

    2.1.7 reported
    ------------------
    xtrabackup_56 version 2.1.7 for MySQL server 5.6.15 Linux (x86_64) (revision id: 721)
    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
    2014-02-18 15:55:31 7f38abdd7720 InnoDB: Operating system error number 2 in a file operation.
    InnoDB: The error means the system cannot find the path specified.
    InnoDB: File ./ib_logfile0: 'open' returned OS error 71. Cannot continue operation
    innobackupex: Error: The xtrabackup child process has died at /usr/bin/innobackupex line 2648.


    2.0.8 reported
    ------------------
    xtrabackup_56 version 2.0.8 for MySQL server 5.6.10 Linux (x86_64) (revision id: 587)
    xtrabackup: uses posix_fadvise().
    xtrabackup: cd to
    xtrabackup: Target instance is assumed as followings.
    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
    2014-02-18 15:59:33 7ffe84979720 InnoDB: Operating system error number 2 in a file operation.
    InnoDB: The error means the system cannot find the path specified.
    2014-02-18 15:59:33 7ffe84979720 InnoDB: File name ./ib_logfile0
    2014-02-18 15:59:33 7ffe84979720 InnoDB: File operation call: 'open' returned OS error 71.
    2014-02-18 15:59:33 7ffe84979720 InnoDB: Cannot continue operation.
    innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 386.

    The /etc/my.cnf file
    ------------------------
    [mysqld56]
    ## list temporary variables or settings here ##
    log_warnings = 2
    ##
    skip-slave-start
    basedir = /usr/local/mysql56/
    binlog-checksum = NONE
    binlog_format = MIXED
    connect_timeout = 60
    datadir = /db01/mysql56/
    default-storage-engine = InnoDB
    event_scheduler = ON
    expire_logs_days = 7
    group_concat_max_len = 99999
    innodb_autoextend_increment=64
    innodb_buffer_pool_size = 5G
    innodb_data_home_dir = /db01/mysql56
    innodb_file_format = barracuda
    innodb_file_per_table
    innodb_flush_log_at_trx_commit = 1
    innodb_io_capacity = 200
    innodb_log_file_size = 64M
    innodb_log_files_in_group=3
    innodb_log_group_home_dir=/db01/mysql56/
    innodb_purge_threads = 1
    innodb_stats_on_metadata= 0
    join_buffer_size = 4000000
    key_buffer_size = 256000000
    local-infile = 0
    log-bin = mysql-bin
    log-error = /var/log/mysqld56.log
    log-queries-not-using-indexes
    log-slave-updates
    long-query-time = 5
    master-info-repository = TABLE
    max_allowed_packet = 32M
    max_connect_errors = 9999
    max_connections = 400
    max_heap_table_size = 64000000
    myisam-recover = FORCE,BACKUP
    mysqladmin = /usr/local/mysql56/bin/mysqladmin
    mysqld = /usr/local/mysql56/bin/mysqld
    net_read_timeout = 120
    old_passwords = 0
    open_files_limit = 4410
    performance_schema = 1
    pid-file = /var/run/mysqld/mysqld56.pid
    plugin_dir = /opt/mysql56/plugins
    port = 3306
    query_cache_size = 16777216
    query_cache_type = ON
    relay-log = /db01/mysql56/relay-bin
    relay-log-index = /db01/mysql56/relay-bin.index
    relay-log-info-file = /db01/mysql56/relay-bin.info
    secure_auth = OFF
    server-id = 3002
    slave_net_timeout = 60
    slow_query_log
    slow_query_log_file = /var/log/mysqld56-slow.log
    socket = /var/run/mysqld/mysql.sock
    sort_buffer_size = 192000
    symbolic-links = 0
    sync_binlog = 1
    table_open_cache = 2000
    table_open_cache = 2000
    thread_cache_size = 108
    tmp_table_size = 64000000
    user = mysql

    Hope you can suggest how I can get the backup to run.

    Thank you!
    -dale
    Last edited by daleb; 02-20-2014, 04:03 PM.

  • #2
    Forgot to mention, this is on RHEL6. Everywhere else I am running MySQL 5.5 on RHEL5 and not encountering any problem with Xtrabackup/Innobackupex. Very satisfied with the product, excepting this little hiccup. :-)

    Comment


    • #3
      Can you please mention all your steps of the backup. Also, what's the output of

      $ xtrabackup --print-defaults

      Comment


      • #4
        By the way, the only difference i can see is innodb_log_files_in_group. Xtrabackup took it as innodb_log_files_in_group = 2 while in your my.cnf it set at innodb_log_files_in_group = 3. We need all your steps of backup to drill down the problem. Either it's happen on during taking backup or at apply-log stage.

        Comment


        • #5
          The output displays no arguments.

          # xtrabackup --print-defaults
          xtrabackup would have been started with the following arguments:

          #

          Comment


          • #6
            <username and password obfuscated for obvious security reasons>

            Ran this command:
            innobackupex --user='xxxxx' --socket=/var/run/mysqld/mysql.sock --password='xxxxx' --defaults-group=mysqld56 /db01/perconabackups

            Output of run:

            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.

            140220 13:49:46 innobackupex: Starting mysql with options: --password=xxxxxxxx --user='xxxxx' --socket='/var/run/mysqld/mysql.sock' --unbuffered --
            140220 13:49:46 innobackupex: Connected to database with mysql child process (pid=29490)
            140220 13:49:52 innobackupex: Connection to database server closed
            IMPORTANT: Please check that the backup run completes successfully.
            At the end of a successful backup run innobackupex
            prints "completed OK!".

            innobackupex: Using mysql Ver 14.14 Distrib 5.1.69, for redhat-linux-gnu (x86_64) using readline 5.1
            innobackupex: Using mysql server version Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

            innobackupex: Created backup directory /db01/perconabackups/2014-02-20_13-49-52
            140220 13:49:52 innobackupex: Starting mysql with options: --password=xxxxxxxx --user='xxxxx' --socket='/var/run/mysqld/mysql.sock' --unbuffered --
            140220 13:49:52 innobackupex: Connected to database with mysql child process (pid=29513)
            140220 13:49:54 innobackupex: Connection to database server closed

            140220 13:49:54 innobackupex: Starting ibbackup with command: xtrabackup_56 --defaults-group="mysqld56" --backup --suspend-at-end --target-dir=/db01/perconabackups/2014-02-20_13-49-52 --tmpdir=/tmp
            innobackupex: Waiting for ibbackup (pid=29519) to suspend
            innobackupex: Suspend file '/db01/perconabackups/2014-02-20_13-49-52/xtrabackup_suspended'

            xtrabackup_56 version 2.0.8 for MySQL server 5.6.10 Linux (x86_64) (revision id: 587)
            xtrabackup: uses posix_fadvise().
            xtrabackup: cd to
            xtrabackup: Target instance is assumed as followings.
            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
            2014-02-20 13:49:54 7fb4bac75720 InnoDB: Operating system error number 2 in a file operation.
            InnoDB: The error means the system cannot find the path specified.
            2014-02-20 13:49:54 7fb4bac75720 InnoDB: File name ./ib_logfile0
            2014-02-20 13:49:54 7fb4bac75720 InnoDB: File operation call: 'open' returned OS error 71.
            2014-02-20 13:49:54 7fb4bac75720 InnoDB: Cannot continue operation.
            innobackupex: Error: ibbackup child process has died at /usr/bin/innobackupex line 386.

            #

            Comment


            • #7
              Mirfan,

              I also opened Bug #1282270 if you want to note anything there.

              Thank you!
              -dale
              Last edited by daleb; 02-20-2014, 03:59 PM.

              Comment


              • #8
                Found the problem in my install. The /etc/my.cnf owner was root, group root, permissions 640. Changed ownership of file to mysql, left group root and left permissions alone.

                The hint was that you pointed out that the log file count was 2, not 3 as in my.cnf. Looked at /etc/my.cnf (ls -l /etc/my.cnf) and compared with system where innobackupex worked. Realized I had not set ownership properly.

                Sorry for the interruption!
                Last edited by daleb; 02-20-2014, 04:02 PM.

                Comment

                Working...
                X