• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

Not all the data was backed up into

onlinesolutions

Basic Pleskian
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?
 
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:
Code:
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:
Code:
*        soft nofile       4096
*        hard nofile       40960
*        soft nproc        4096
*        hard nproc        40960
 
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.
 
Back
Top