innobackupex returns exit code 0 when it fails
Bug #1406091 reported by
Miguel Angel Nieto
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Expired
|
Undecided
|
Unassigned |
Bug Description
A user with 2.0.8 reported that when innobackupex fails with the following errors:
xtrabackup: error: expected log block no. 684572520, but got no. 698728224 from the log file.
xtrabackup: error: it looks like InnoDB log has wrapped around before xtrabackup could process all records due to either log copying being too slow, or log files being too small.
xtrabackup: Error: xtrabackup_
or
141228 0:49:20 InnoDB: Operating system error number 24 in a file operation.
InnoDB: Error number 24 means 'Too many open files'.
It returns exit code 0. I remember that a similar bug was reported while ago, but I cannot find if so I don't know if it is fixed or not.
tags: | added: i49443 |
no longer affects: | percona-xtrabackup/2.2 |
no longer affects: | percona-xtrabackup/2.1 |
no longer affects: | percona-xtrabackup/2.0 |
To post a comment you must log in.
Unable to reproduce the same with xtrabackup 2.0.8 on both the scenarios.
root@desktop: /home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin# ./innobackupex --user=root --password=root --ibbackup= /home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin/ xtrabackup_ 56 /home/nilnandan /backup/
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
and Percona LLC and/or its affiliates 2009-2013. All Rights Reserved.
...
innobackupex: Using mysql Ver 14.14 Distrib 5.6.21-70.1, for debian-linux-gnu (x86_64) using EditLine wrapper
Warning: Using a password on the command line interface can be insecure.
innobackupex: Using mysql server version Copyright (c) 2009-2014 Percona LLC and/or its affiliates
innobackupex: Created backup directory /home/nilnandan /backup/ 2015-01- 06_12-31- 21
150106 12:31:21 innobackupex: Starting mysql with options: --password=xxxxxxxx --user='root' --unbuffered --
150106 12:31:21 innobackupex: Connected to database with mysql child process (pid=13166)
150106 12:31:23 innobackupex: Connection to database server closed
150106 12:31:23 innobackupex: Starting ibbackup with command: /home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin/ xtrabackup_ 56 --defaults- group=" mysqld" --backup --suspend-at-end --target- dir=/home/ nilnandan/ backup/ 2015-01- 06_12-31- 21 --tmpdir=/tmp nilnandan/ backup/ 2015-01- 06_12-31- 21/xtrabackup_ suspended'
innobackupex: Waiting for ibbackup (pid=13173) to suspend
innobackupex: Suspend file '/home/
/home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin/ xtrabackup_ 56 version 2.0.8 for MySQL server 5.6.10 Linux (x86_64) (revision id: 587) data_home_ dir = ./ data_file_ path = ibdata1: 10M:autoextend log_group_ home_dir = ./ log_files_ in_group = 2 log_file_ size = 1048576 /backup/ 2015-01- 06_12-31- 21/ibdata1 copy_logfile( ) failed. /home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin# /home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin# echo $? /home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin#
xtrabackup: uses posix_fadvise().
xtrabackup: cd to /var/lib/mysql
xtrabackup: Target instance is assumed as followings.
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
xtrabackup: innodb_
>> log scanned up to (1873735705)
InnoDB: Allocated tablespace 3, old maximum was 0
[01] Copying ./ibdata1 to /home/nilnandan
>> log scanned up to (1875519844)
>> log scanned up to (1876433279)
...
>> log scanned up to (1896730431)
xtrabackup: error: log block numbers mismatch:
xtrabackup: error: expected log block no. 3704552, but got no. 3708640 from the log file.
xtrabackup: error: it looks like InnoDB log has wrapped around before xtrabackup could process all records due to either log copying being too slow, or log files being too small.
xtrabackup: Error: xtrabackup_
innobackupex: Error: ibbackup child process has died at ./innobackupex line 386.
root@desktop:
root@desktop:
2
root@desktop:
With 'Too many open files' error,
root@desktop: /home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin# ./innobackupex --user=root --password=root --ibbackup= /home/nilnandan /Downloads/ percona- xtrabackup- 2.0.8/bin/ xtrabackup_ 56 /home/nilnandan /backup/
...
innobackupex: Usi...