# innobackupex-1.5.1 error in backup

**URL:** <https://forums.percona.com/t/innobackupex-1-5-1-error-in-backup/2143>\
**Category:** Percona XtraBackup\
**Created:** [April 27, 2011, 1:33pm UTC](https://forums.percona.com/t/innobackupex-1-5-1-error-in-backup/2143 "2011-04-27T13:33:31Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ferrelnavia](https://avatars.discourse-cdn.com/v4/letter/f/7bcc69/32.png) [@ferrelnavia](https://forums.percona.com/u/ferrelnavia)\
**Post date:** [April 27, 2011, 1:33pm UTC](https://forums.percona.com/t/innobackupex-1-5-1-error-in-backup/2143/1 "2011-04-27T13:33:31Z")

</div>

Hi,  
Im trying to get a full backup from my db’s in my slave server and im using :

$ innobackupex-1.5.1 --slave-info /mnt/data/tmp

and always in the same point show this error :  
[01] Copying ./emails/mail\_pending\_childrens#P#p47.ibd  
to /mnt/data/tmp/2011-04-26\_12-30-02/emails/mails\_pending\_child rens#P#p47.ibd  
[01] …done  
110426 12:45:11 InnoDB: Operating system error number 24 in a file operation.  
InnoDB: Error number 24 means ‘Too many open files’.  
InnoDB: Some operating system error numbers are described at  
InnoDB: [http://dev.mysql.com/doc/refman/5.1/en/operating-system-erro r-codes.html](http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html)  
InnoDB: File name /mnt/data/tmp/2011-04-26\_12-30-02/emails/mails\_pending\_child rens#P#p48.ibd  
InnoDB: File operation call: ‘create’.  
110426 12:45:11 InnoDB: Operating system error number 24 in a file operation.  
InnoDB: Error number 24 means ‘Too many open files’.  
InnoDB: Some operating system error numbers are described at  
InnoDB: [http://dev.mysql.com/doc/refman/5.1/en/operating-system-erro r-codes.html](http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html)  
[01] xtrabackup: error: cannot open /mnt/data/tmp/2011-04-26\_12-30-02/emails/mails\_pending\_child rens#P#p48.ibd  
[01] xtrabackup: Error: xtrabackup\_copy\_datafile() failed.  
[01] xtrabackup: Warning: failed to copy, but continuing.  
110426 12:45:11 InnoDB: Operating system error number 24 in a file operation.  
InnoDB: Error number 24 means ‘Too many open files’.  
InnoDB: Some operating system error numbers are described at  
InnoDB: [http://dev.mysql.com/doc/refman/5.1/en/operating-system-erro r-codes.html](http://dev.mysql.com/doc/refman/5.1/en/operating-system-error-codes.html)  
110426 12:45:11 InnoDB: Fatal error: cannot open ./emails/mails\_pending\_childrens#P#p49.ibd  
.InnoDB: Have you deleted .ibd files under a running mysqld server?  
110426 12:45:11 InnoDB: Assertion failure in thread 1455479104 in file fil/fil0fil.c line 675  
InnoDB: Failing assertion: 0  
InnoDB: We intentionally generate a memory trap.  
InnoDB: Submit a detailed bug report to [http://bugs.mysql.com.](http://bugs.mysql.com)  
InnoDB: If you get repeated assertion failures or crashes, even  
InnoDB: immediately after the mysqld startup, there may be  
InnoDB: corruption in the InnoDB tablespace. Please refer to  
InnoDB: [http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html](http://dev.mysql.com/doc/refman/5.1/en/forcing-recovery.html)  
InnoDB: about forcing recovery.  
innobackupex-1.5.1: Error: ibbackup child process has died at /usr/bin/innobackupex-1.5.1 line 542.

This is some lines in the my.cnf file :

# InnoDB Settings

innodb\_file\_per\_table  
innodb\_data\_home\_dir = /mnt/data/innodb/  
innodb\_data\_file\_path = dbdata01:750M:autoextend  
innodb\_log\_group\_home\_dir = /mnt/data/logs/  
innodb\_buffer\_pool\_size = 50G  
innodb\_additional\_mem\_pool\_size = 100M  
innodb\_log\_file\_size = 100M  
innodb\_log\_buffer\_size = 6M  
innodb\_flush\_log\_at\_trx\_commit = 2  
innodb\_lock\_wait\_timeout = 60  
innodb\_thread\_concurrency = 0  
innodb\_support\_xa = 1  
innodb\_rollback\_on\_timeout = 1  
innodb\_flush\_method = O\_DIRECT  
innodb\_open\_files = 5000  
innodb\_read\_ahead = linear  
innodb\_read\_io\_threads = 24  
innodb\_write\_io\_threads = 8  
innodb\_file\_format = Barracuda

Any ideas?

---

<div class="post-metadata">

**Author:** ![xaprb](https://avatars.discourse-cdn.com/v4/letter/x/49beb7/32.png) [@xaprb](https://forums.percona.com/u/xaprb)\
**Post date:** [May 1, 2011, 2:12pm UTC](https://forums.percona.com/t/innobackupex-1-5-1-error-in-backup/2143/2 "2011-05-01T14:12:34Z")

</div>

You need to increase ulimit -n for the backup user.

---

<div class="post-metadata">

**Author:** ![ferrelnavia](https://avatars.discourse-cdn.com/v4/letter/f/7bcc69/32.png) [@ferrelnavia](https://forums.percona.com/u/ferrelnavia)\
**Post date:** [May 2, 2011, 1:19pm UTC](https://forums.percona.com/t/innobackupex-1-5-1-error-in-backup/2143/3 "2011-05-02T13:19:01Z")

</div>

Hi, i already changed to double my limits with ulimit -n ###, but its stuck in the same part with the same ptoblem … here what i changed

[root@FNM security]# ulimit -a  
core file size (blocks, -c) 0  
data seg size (kbytes, -d) unlimited  
scheduling priority (-e) 0  
file size (blocks, -f) unlimited  
pending signals (-i) 999424  
max locked memory (kbytes, -l) 32  
max memory size (kbytes, -m) unlimited  
open files (-n) 2048 ← Before 1024  
pipe size (512 bytes, -p) 8  
POSIX message queues (bytes, -q) 819200  
real-time priority (-r) 0  
stack size (kbytes, -s) 10240  
cpu time (seconds, -t) unlimited  
max user processes (-u) unlimited  
virtual memory (kbytes, -v) unlimited  
file locks (-x) unlimited