Innobackupex:Error:xtrabackup child process has died At/usr/bin/innobackupex

Source: Internet
Author: User
Tags percona

Use Innobackupex for database backup to report the following error:
Innobackupex--compress--parallel=4--user=root--password=yoon/export/backup/
xtrabackup_56 version 2.1.9 for MySQL server 5.6.17 Linux (x86_64) (revision id:744)
Xtrabackup:uses posix_fadvise ().
XTRABACKUP:CD To/var/lib/mysql
Xtrabackup:open files limit requested 0, set to 1024
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
2016-01-21 21:41:29 7f343333b720 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 had died At/usr/bin/innobackupex line 2622.

In the production library backup is no problem, the virtual machine backup is a problem!

Percona says modify Profile path permissions:
Https://www.percona.com/forums/questions-discussions/percona-xtrabackup/13396-file-name-ib_ logfile0-innodb-file-operation-call-open-returned-os-error-71
[Email protected] mysql]# ls-ltr
Total 180
-rw-r--r--. 1 root root 2496 Jul
-rw-r--r--. 1 root root 17987 Jul COPYING
-rw-r--r--. 1 root root 104897 Jul install-binary
Drwxr-xr-x. 2 root root 4096 Dec 18:39 docs
Drwxr-xr-x. 3 root root 4096 Dec 18:39 include
Drwxr-xr-x. 4 root root 4096 Dec 18:39 man
Drwxr-xr-x. 3 root root 4096 Dec 18:39 data
Drwxr-xr-x. 3 root root 4096 Dec 18:39 Lib
Drwxr-xr-x. 2 root root 4096 Dec 18:39 scripts
Drwxr-xr-x. 2 root root 4096 Dec 18:39 bin
Drwxr-xr-x. Root root 4096 Dec 18:39 mysql-test
Drwxr-xr-x. 2 root root 4096 Dec 18:39 support-files
Drwxr-xr-x. Root root 4096 Dec 18:39 share
Drwxr-xr-x. 4 root root 4096 Dec 18:39 sql-bench
-rw-r--r--. 1 root root 943 Dec 18:39 my.cnf
Drwxr-xr-x. 2 root root 4096 Dec 18:40 etc
[[email protected] mysql]# chown-r mysql.mysql etc/problem still!

Error always prompt Ib_logfile0, in the configuration file Ib_logfile parameter is present:
Innodb:file./IB_LOGFILE0: ' Open ' returned OS error 71. Cannot continue operation

To back up the specified parameter file:
[Email protected] backup]# Innobackupex--compress--parallel=4--defaults-file=/export/servers/mysql/etc/my.cnf-- User=root--password=yoon/export/backup/


InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 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.


Get the latest version of Percona Xtrabackup, documentation, and help resources:
http://www.percona.com/xb/p


160121 22:12:52 innobackupex:connecting to MySQL server with DSN ' dbi:mysql:;mysql_read_default_file=/export/servers/ Mysql/etc/my.cnf;mysql_read_default_group=xtrabackup ' as ' root ' (using Password:yes).
160121 22:12:52 innobackupex:connected to MySQL server
160121 22:12:52 innobackupex:executing A version check against the server ...
160121 22:12:52 Innobackupex:done.
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.26-log


innobackupex:created Backup directory/export/backup/2016-01-21_22-12-52


160121 22:12:52 innobackupex:starting ibbackup with command:xtrabackup_56--defaults-file= "/export/servers/mysql/etc /my.cnf "--defaults-group=" mysqld "--backup--suspend-at-end--target-dir=/export/backup/2016-01-21_22-12-52-- Tmpdir=/export/data/mysql/tmp--compress--compress-threads=1--parallel=4
Innobackupex:waiting for Ibbackup (pid=5476) to suspend
Innobackupex:suspend file '/export/backup/2016-01-21_22-12-52/xtrabackup_suspended_2 '


xtrabackup_56 version 2.1.9 for MySQL server 5.6.17 Linux (x86_64) (revision id:744)
Xtrabackup:uses posix_fadvise ().
XTRABACKUP:CD to/export/data/mysql/data/
Xtrabackup:open files limit requested 65535, set to 65535
Xtrabackup:using the following InnoDB configuration:
Xtrabackup:innodb_data_home_dir =/export/data/mysql/data
Xtrabackup:innodb_data_file_path = Ibdata1:2g;ibdata2:2g:autoextend
Xtrabackup:innodb_log_group_home_dir =/export/data/mysql/data
Xtrabackup:innodb_log_files_in_group = 3
Xtrabackup:innodb_log_file_size = 268435456
2016-01-21 22:12:52 7fa03bee9720 innodb:using Linux native AIO
Xtrabackup:using O_direct
>> Log scanned up to (1510934)
innodb:opened 4 undo Tablespaces
Xtrabackup:starting 4 threads for parallel data files transfer
[Compressing/export/data/mysql/data/ibdata1] To/export/backup/2016-01-21_22-12-52/ibdata1.qp
[Compressing/export/data/mysql/data/ibdata2] To/export/backup/2016-01-21_22-12-52/ibdata2.qp
[Compressing/export/data/mysql/undo/undo001 TO/EXPORT/BACKUP/2016-01-21_22-12-52/UNDO001.QP]
[Compressing/export/data/mysql/undo/undo002 TO/EXPORT/BACKUP/2016-01-21_22-12-52/UNDO002.QP]
[From] ... done
[... done]
>> Log scanned up to (1510934)
[Compressing/export/data/mysql/undo/undo003 TO/EXPORT/BACKUP/2016-01-21_22-12-52/UNDO003.QP]
[Compressing/export/data/mysql/undo/undo004 TO/EXPORT/BACKUP/2016-01-21_22-12-52/UNDO004.QP]
[From] ... done
[... done]
[Compressing]/mysql/innodb_index_stats.ibd to/export/backup/2016-01-21_22-12-52/mysql/innodb_index_ Stats.ibd.qp
[From] ... done
[Compressing]/mysql/innodb_table_stats.ibd To/export/backup/2016-01-21_22-12-52/mysql/innodb_table_ Stats.ibd.qp
[... done]
[Compressing]/mysql/slave_master_info.ibd to/export/backup/2016-01-21_22-12-52/mysql/slave_master_ Info.ibd.qp
[From] ... done
>> Log scanned up to (1510934)
[Compressing]/mysql/slave_relay_log_info.ibd To/export/backup/2016-01-21_22-12-52/mysql/slave_relay_log_ Info.ibd.qp
[... done]
[Compressing]/mysql/slave_worker_info.ibd to/export/backup/2016-01-21_22-12-52/mysql/slave_worker_ Info.ibd.qp
[From] ... done
>> Log scanned up to (1510934)
>> Log scanned up to (1510934)
>> Log scanned up to (1510934)
>> Log scanned up to (1510934)
[... done]
[[] ... done
xtrabackup:creating suspend file '/export/backup/2016-01-21_22-12-52/xtrabackup_suspended_2 ' with PID ' 5476 '


160121 22:12:59 innobackupex:continuing after ibbackup have suspended
160121 22:12:59 innobackupex:starting to lock all tables ...
160121 22:12:59 innobackupex:all tables locked and flushed to disk


160121 22:12:59 innobackupex:starting to backup Non-innodb tables and files
Innobackupex:in subdirectories of '/export/data/mysql/data/'
innobackupex:backing up files '/export/data/mysql/data//mysql/*. {Frm,isl,myd,myi,mad,mai,mrg,trg,trn,arm,arz,csm,csv,opt,par} ' (*)
>> Log scanned up to (1510934)
innobackupex:backing up files '/export/data/mysql/data//performance_schema/*. {Frm,isl,myd,myi,mad,mai,mrg,trg,trn,arm,arz,csm,csv,opt,par} ' (All files)
160121 22:13:00 innobackupex:finished backing up non-innodb tables and files


160121 22:13:00 innobackupex:waiting for log copying to finish


Xtrabackup:the Latest Check Point (for incremental): ' 1510934 '
xtrabackup:stopping log copying thread.
.>> Log scanned up to (1510934)


xtrabackup:creating suspend file '/export/backup/2016-01-21_22-12-52/xtrabackup_log_copied ' with PID ' 5476 '
Xtrabackup:transaction Log of LSN (1510934) to (1510934) was copied.
160121 22:13:01 innobackupex:all Tables Unlocked


Innobackupex:backup created in directory '/export/backup/2016-01-21_22-12-52 '
Innobackupex:mysql binlog position:filename ' mysql-bin.000007 ', position 120
160121 22:13:01 innobackupex:connection to database server closed
160121 22:13:01 innobackupex:completed ok!

Innobackupex:Error:xtrabackup child process has died At/usr/bin/innobackupex

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.