Not all the data was backed up into

[onlinesolutions]

Not all the data was backed up into /var/lib/psa/dumps/domains/xyz.com/databases/xyz successfully. Use of chdir('') or chdir(undef) as chdir() is deprecated at /usr/local/psa/PMM/agents/shared/Storage/Bundle.pm line 39.
mysqldump: Couldn't execute 'show table status like 'xyz'': Can't read dir of './xyz/' (errno: 24) (1018)

What is the issue?

 

[UFHH01]

Hi onlinesolutions,

this issue can be caused by some security limits configured over your operating system. In most cases, the standard limits are set to 1024 for open files, which might be to less for some ( big ) databases.

You could try to edit "/etc/security/limits.conf" and add:

mysql    soft nofile        6400
mysql    hard nofile        64000
mysql    soft nproc         6400
mysql    hard nproc         64000

After a reboot the new settings will apply and the issue should be gone.

In addition you could set as well a higher "global" open files limit, with an example setting like this:

*        soft nofile       4096
*        hard nofile       40960
*        soft nproc        4096
*        hard nproc        40960

 

[onlinesolutions]

Thanks for your answer. I did that already, but I still needed to increase open_files_limit in /etc/my.cnf for it to work properly.