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

xtrabackup error executing old backup script

rhysrhys EntrantInactive User Role Beginner
Hello,

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

<pre>
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.
</pre>


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?

Comments

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.