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).