Bug #71990 better error reporting for missing partitions

• Submitted: 10 Mar 2014 6:23
• Reporter: Shane Bester (Platinum Quality Contributor)
• Status: Verified
• Category: MySQL Server: DDL
• Severity: S4 (Feature request)
• Version: 5.6.11
• OS: Any
• CPU Architecture: Any

[10 Mar 2014 6:23] Shane Bester

Description:
When trying to view the structure of a partitioned tables, and some partitions are missing:

ERROR 1017 (HY000): Can't find file: 'a' (errno: 2 - No such file or directory)

The above is not useful. Firstly, the error is wrong, file "a" is not the file it tries to open, secondly nowhere in the message or error log does it say the real filename.  In this case it was one of the partitions *.ARZ  files.

How to repeat:
create a partitioned table and remove one of the files from the filesystem. Then try access the table.