Bug #44755 Wrong error when hitting file size limit in AIX

• Submitted: 8 May 2009 15:37
• Reporter: Andrew Hutchings
• Status: Verified
• Category: MySQL Server: MyISAM storage engine
• Severity: S3 (Non-critical)
• Version: 5.1.30
• OS: IBM AIX (5.3)
• CPU Architecture: Any

[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)