xtrabackup备份报错

数据库版本mysql5.6.34，操作系统cenos6.8

mysql在使用xtrabackup进行全备时报错InnoDB: Error number 24 means 'Too many open files'.

InnoDB: Someoperating system error numbers are described at

InnoDB:http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html

InnoDB: Error:could not open single-table tablespace file ./bjml/t_trade_datatypes.ibd

InnoDB: We donot continue the crash recovery, because the table may become

InnoDB: corruptif we cannot apply the log records in the InnoDB log to it.

InnoDB: To fixthe problem and start mysqld:

InnoDB: 1) Ifthere is a permission problem in the file and mysqld cannot

InnoDB: open thefile, you should modify the permissions.

InnoDB: 2) Ifthe table is not needed, or you can restore it from a backup,

InnoDB: then youcan remove the .ibd file, and InnoDB will do a normal

InnoDB: crashrecovery and ignore that table.

InnoDB: 3) Ifthe file system or the disk is broken, and you cannot remove

InnoDB: the .ibdfile, you can set innodb_force_recovery > 0 in my.cnf

InnoDB: andforce InnoDB to continue crash recovery here.

innobackupex:Error: The xtrabackup child process has died at/usr/local/xtrabackup/bin/innobackupex line 2622.）

操作系统ulimit –a查看

操作系统ulimit -n 1024默认值

调整ulimit -n 65535

重新备份正常！