Bug #44755 Wrong error when hitting file size limit in AIX
Submitted: 8 May 2009 15:37
Reporter: Andrew Hutchings Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:5.1.30 OS:IBM AIX (5.3)
Assigned to: CPU Architecture:Any
Triage: Triaged: D4 (Minor)

[8 May 2009 15:37] Andrew Hutchings
Description:
When a MyISAM .MYD hits the maximum limit set by ulimit -f in AIX you get the following error:

090508 17:29:13 [ERROR] ../../mysql-5.1.30-aix5.3-powerpc/bin/mysqld: Incorrect key file for table './test/testing.MYI'; try to repair it
ERROR 126 (HY000) at line 3910: Incorrect key file for table './test/testing.MYI'; try to repair it

Instead of an OS error

How to repeat:
1. ulimit -f 1966
2. Insert 2M of data into a MyISAM table (even without indexes)