List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:September 23 2011 4:49pm
Subject:Re: mysqldump: Got error: 1017: Can't find file:
View as plain text  
In the last episode (Sep 23), Shafi AHMED said:
> I have a mysql database of 200G size and the backup fails due to the foll.
> Issue.
> 
> mysqldump: Got error: 1017: Can't find file:
> './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLES
> 
> Can someone assist pls.?

$ perror 24
OS error code  24:  Too many open files

You need to bump up the max files limit in your OS.  It may be defaulting to
a small number like 1024.  If you can't change that limit, edit your my.cnf
and lower the table_open_cache number.  You'll lose performance though,
since mysql will have to stop accessing some tables to open others.

http://dev.mysql.com/doc/refman/5.5/en/not-enough-file-handles.html

-- 
	Dan Nelson
	dnelson@stripped
Thread
mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLESShafi AHMED23 Sep
Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLESJohan De Meersman23 Sep
Re: mysqldump: Got error: 1017: Can't find file:'./ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLESDan Nelson23 Sep
  • Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm'(errno: 24) when using LOCK TABLESPrabhat Kumar24 Sep
    • Re: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm'(errno: 24) when using LOCK TABLESSuresh Kuna24 Sep
      • RE: mysqldump: Got error: 1017: Can't find file: './ssconsole/ss_requestmaster.frm' (errno: 24) when using LOCK TABLESShafi AHMED26 Sep