Bug #15020 "Can't find files" message incorrect for error 24
Submitted: 17 Nov 2005 15:01 Modified: 2 Feb 2006 5:05
Reporter: Jonathan Miller Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:5.1.2 OS:Linux (Linux)
Assigned to: Magnus Blåudd CPU Architecture:Any

[17 Nov 2005 15:01] Jonathan Miller
Description:
Looking http://bugs.mysql.com/15019 you will see the following errors:

051116 16:19:38 [ERROR] /home/ndbdev/jmiller/builds/libexec/mysqld: Can't find
file: '.
/cluster_replication/binlog_index.frm' (errno: 24)

errno: 24 is actually:
OS error code  24:  Too many open files

So the message is not correct in stating that it can't find the file, it just can not open the file.

How to repeat:
See http://bugs.mysql.com/15019

Suggested fix:
Change message:
051116 16:19:38 [ERROR] /home/ndbdev/jmiller/builds/libexec/mysqld: Can not open file: './cluster_replication/binlog_index.frm' (errno: 24)
[2 Dec 2005 9:01] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/32951
[19 Jan 2006 10:35] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/internals/33370
[24 Jan 2006 11:42] Magnus Blåudd
Error message will now say "Could not open file (errno: 24)"
Pushed to 5.0.19 and 5.1.6
[24 Jan 2006 11:45] Magnus Blåudd
Not pushed to 5.1 yet. Only to 5.0.19
[26 Jan 2006 2:10] Mike Hillyer
When you say not pushed in 5.1 yet do you imply that it will be pushed in the near future? If I add a changelog entry I also need to close the bugreport, which would be the wrong course of action if this bug is also to be fixed in 5.1. Changing status to Need Doc Info.
[26 Jan 2006 16:35] Magnus Blåudd
Pushed to 5.1.6 as well.
[2 Feb 2006 5:05] Mike Hillyer
Documented in 5.0.19, 5.1.6 changelogs:

<listitem>
        <para>
          NDB Cluster returned incorrect <literal>Can't find
            file</literal> error for OS error 24, changed to
          <literal>Too many open files</literal>. (Bug #15020)
        </para>
      </listitem>