Bug #39708 Falcon: non-descriptive error message when creating a big key
Submitted: 28 Sep 2008 10:34 Modified: 13 Dec 2008 10:06
Reporter: Philip Stoev Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S3 (Non-critical)
Version:6.0-falcon-team OS:Any
Assigned to: Sergey Vojtovich CPU Architecture:Any
Tags: F_ERROR HANDLING
Triage: Triaged: D4 (Minor)

[28 Sep 2008 10:34] Philip Stoev
Description:
When Falcon is started with --falcon-page-size=2K, maximum key length is 540 bytes, which is not sufficient to index even reasonably-sized utf8 columns.

This is mentioned in the documentation, however the the error message returned to the client is not descriptive.

How to repeat:
$ perl mysql-test-run.pl --start-and-exit --mysqld=--falcon-page-size=2K

mysql> CREATE TABLE t1 ( f1 varchar(140) CHARACTER SET utf8, key (f1) ) ENGINE=falcon;
ERROR 1005 (HY000): Can't create table 'test.t1' (errno: 213)

Suggested fix:
Map the falcon internal error to an appropriate server error code.
[1 Oct 2008 15:25] Godofredo Miguel Solorzano
I couldn't repeat this issue with mysql-6.0 tree.
[8 Oct 2008 17:49] Godofredo Miguel Solorzano
Thank you for the bug report.

mysql> CREATE TABLE test.t1 ( f1 varchar(140) CHARACTER SET utf8, key (f1) ) ENGINE=falcon;
No connection. Trying to reconnect...
Connection id:    1
Current database: test

ERROR 1005 (HY000): Can't create table 'test.t1' (errno: 213)
mysql>
[29 Oct 2008 12:44] 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/commits/57304

2887 Sergey Vojtovich	2008-10-29
      BUG#39708 - Falcon: non-descriptive error message when creating a big key
      
      When a table creation fails due to too long key, returned
      error message was very generic and unspecific.
      
      Return descriptive error message when table creation
      fails due to too long key.
[20 Nov 2008 12:56] Bugs System
Pushed into 6.0.8-alpha  (revid:svoj@mysql.com-20081029114114-9gdkdc6cknckb294) (version source revid:vvaintroub@mysql.com-20081031154948-p0kay8egouts5a89) (pib:5)
[13 Dec 2008 10:06] MC Brown
A note has been added to the 6.0.8 changelog: 

When creating a table with the FALCON engine where the size of the key in the index was larger than supported (the error message did not signify the severity of the problem. The message and error has been updated.