xtrabackup error executing old backup script

  • Filter
  • Time
  • Show
Clear All
new posts

  • xtrabackup error executing old backup script


    I've just started having a problem with a backup script, using xtrabackup, we have been using for several years. It exits after a few seconds with the following output...

    Forcing tar instead of tar4ibd

    InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
    and Percona Inc 2009-2011. All Rights Reserved.

    This software is published under
    the GNU GENERAL PUBLIC LICENSE Version 2, June 1991.

    IMPORTANT: Please check that the backup run completes successfully.
    At the end of a successful backup run innobackupex-1.5.1
    prints "completed OK!".

    innobackupex-1.5.1: Using mysql Ver 14.14 Distrib 5.5.15, for Linux (x86_64) using readline 5.1
    innobackupex-1.5.1: Using mysql server version Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.

    innobackupex-1.5.1: Created backup directory /home/vulf
    140630 12:09:12 innobackupex-1.5.1: Starting mysql with options: --password='rootpa55' --user='root' --unbuffered --
    140630 12:09:12 innobackupex-1.5.1: Connected to database with mysql child process (pid=9165)
    140630 12:09:16 innobackupex-1.5.1: Connection to database server closed

    140630 12:09:16 innobackupex-1.5.1: Starting ibbackup with command: xtrabackup_55 --backup --suspend-at-end --log-stream --target-dir=./ --use-memory=4G --parallel=6
    innobackupex-1.5.1: Waiting for ibbackup (pid=9200) to suspend
    innobackupex-1.5.1: Suspend file '/data/db//xtrabackup_suspended'

    xtrabackup: suspend-at-end is enabled.
    xtrabackup: uses posix_fadvise().
    xtrabackup: cd to /data/db/
    xtrabackup: Target instance is assumed as followings.
    xtrabackup: innodb_data_home_dir = /data/db
    xtrabackup: innodb_data_file_path = ibdata1:10M:autoextend
    xtrabackup: innodb_log_group_home_dir = /logs/run/innodb_logs
    xtrabackup: innodb_log_files_in_group = 3
    xtrabackup: innodb_log_file_size = 1363148800
    140630 12:09:16 InnoDB: Using Linux native AIO
    xtrabackup: use O_DIRECT
    140630 12:09:16 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
    InnoDB: Warning: io_setup() attempt 1 failed.
    InnoDB: Warning: io_setup() attempt 2 failed.
    InnoDB: Warning: io_setup() attempt 3 failed.
    InnoDB: Warning: io_setup() attempt 4 failed.
    InnoDB: Warning: io_setup() attempt 5 failed.
    140630 12:09:18 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
    InnoDB: You can disable Linux Native AIO by setting innodb_native_aio = off in my.cnf
    innobackupex-1.5.1: Error: ibbackup child process has died at /usr/bin/innobackupex-1.5.1 line 336.

    I did make a monitor modification to my /etc/my.cnf to resolve a separate issue but I can;t see it being related. I did however try reverting this but the problem persists. I've also tried setting innodb_native_aio = o in /etc/my.cnf to no avail (also innodb_use_native_aio = 0 as documented elsewhere).

    Any thoughts?

  • #2
    Fixed with this...

    sysctl fs.aio-max-nr=262144

    source: http://elenst.ru/mariadb/aio-max-nr-...in-particular/