MySQL Forums
Forum List  »  Backup

mysqldump reports error 24
Posted by: P Fudd
Date: January 09, 2005 02:43PM

Hi..

I've got an ISP, and all of our customers have databases in our mysql system.

My backup command is
mysqldump --force --opt -A -pxxxxxxxx' | gzip -c > /var/sqlbackup/mysqldump-`date +\%A`.sql.gz

This has worked fine for some time.

Now, however, we get an error message:
mysqldump: Got error: 1017: Can't find file: './usr_web22_1/invoices_va.frm' (errno: 24) when using LOCK TABLES
On different runs, it reports different files.

I've looked at the mysql documentation for this error; it's at
http://dev.mysql.com/doc/mysql/en/Not_enough_file_handles.html

I've looked at the startup script, put in '--open-files-limit=1024', restarted mysql, and the error is the same.

I've looked at the table_cache and max_connections system variables, which are 64 and 100, respectively.

My question is: what should I do now?

Since table_cache and max_connections are far less than 1024, do I reduce them even further?
Is there something else I should be looking at?

Thanks!

Options: ReplyQuote


Subject
Views
Written By
Posted
mysqldump reports error 24
9704
January 09, 2005 02:43PM
4774
January 09, 2005 02:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.