Cannot backup in 11.5.3 #19

[HoracioS]

I got the following error when trying to backup:

Warning: mysql "forum"
Failed to pack files backup_forum_1_1310221723 in /var/lib/psa/dumps/domains/xxxxxxx.com/databases/forum_1 [ 106140502016 bytes free of 107374182400 bytes total on mount point 0]
Warning: mysql "forum"
mysqldump: Got error: 23: Out of resources when opening file './forum/vbp__trackerstatus.MYD' (Errcode: 24) when using LOCK TABLES

Any help?

Best regards,
Horacio

 

[abdi]

mysqldump: Got error: 23: Out of resources when opening file './forum/vbp__trackerstatus.MYD' (Errcode: 24) when using LOCK TABLES

According to here - "OS error code 24: Too many open files" which lines up with the more general error 23 "Out of resources".

So it seems as though you are running out of file handles. This is usually server-end setting/problem, either in MySQL, or in the OS itself.

Perhaps check/adjust the --open-files-limit setting in MySQL itself and see if that helps.

Also, perhaps try running the dump, while no one else is using the DB, with the --single-transaction setting instead of --Lock-File, as several people suggest this will work one table at a time instead of opening them all at once (therefore using less file handles).

Beyond that you'll probably have to find a root cause as to why this particular server is running out of resources. which would probably involve troubleshooting by disabling as many services/processes as possible and see if the dump goes through. Then figure out from there who the culprit is that's eating too many resources and perhaps not freeing them correctly.