Bug #28496 Missing error messages for NDB error codes
Submitted: 17 May 2007 9:48 Modified: 21 Oct 2008 22:35
Reporter: Kristian Nielsen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S3 (Non-critical)
Version:5.1-telco OS:Any
Assigned to: li zhou CPU Architecture:Any

[17 May 2007 9:48] Kristian Nielsen
Description:
Missing error message for NDB error codes 1224 and 1227. The errors are thrown in DblqhMain.cpp, but there are no corresponding messages in ndberror.c.

How to repeat:
mysql> CREATE TABLE A (a int) ENGINE=ndb PARTITION BY KEY(a) PARTITIONS 16;
ERROR 1005 (HY000): Can't create table 'test.A' (errno: 1224)
mysql> show warnings
    -> ;
+-------+------+----------------------------------------------+
| Level | Code | Message                                      |
+-------+------+----------------------------------------------+
| Error | 1296 | Got error 1224 'Unknown error code' from NDB | 
| Error | 1005 | Can't create table 'test.A' (errno: 1224)    | 
+-------+------+----------------------------------------------+
2 rows in set (0.00 sec)

(Don't know how to get error 1227).

Suggested fix:
Add appropriate text to ndberror.c
[28 Apr 2008 9:02] 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/46101

ChangeSet@1.2578, 2008-04-28 16:32:45+00:00, lzhou@dev3-63.(none) +1 -0
  BUG#28496 Add error message for error code 1224 and 1227
[21 Oct 2008 12:51] ws lee
this bug is not yet fix?

In mysql5.1.27-ndb6.3.17 occurred same error.
[21 Oct 2008 12:56] 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/56686

2705 Jonas Oreland	2008-10-21
      ndb - bug#28496
[21 Oct 2008 15:42] Jonas Oreland
pushed into 62, 63 and 64
[21 Oct 2008 15:44] Jonas Oreland
6.2.17 and 6.3.19
[21 Oct 2008 16:43] ws lee
in addtion, what can i solve about error code 1224?

i can't create partitions over 8.

NoofReplica=2

create table test.a
(id int not null,primary key(id))
engine=ndbcluster
PARTITION BY KEY() 
PARTITIONS 9;

In NoofReplica=2, maximum partions is 8?
[21 Oct 2008 22:35] Jon Stephens
Documented bugfix in the NDB-6.2.17 and NDB-6.3.19 changelogs as follows:

        Error messages for NDBCLUSTER error codes 1224 and 1227 were missing.
[21 Oct 2008 22:38] Jon Stephens
Lee,

The problem raised in this bug report (missing error messages) has been fixed in the MySQL Cluster 6.2 and 6.3 trees.

While your issue is related to this one, it is a separate issue; please open a new bug. Thanks.
[21 Oct 2008 22:49] Jon Stephens
Note: NDB error codes listing (http://dev.mysql.com/doc/ndbapi/en/ndb-error-codes.html) also updated as part of documenting this fix.
[24 Oct 2008 1:18] Bugs System
Pushed into 5.1.28-ndb-6.2.17  (revid:jonas@mysql.com-20081021130033-awxkyjsip668sq1l) (version source revid:jonas@mysql.com-20081021130033-awxkyjsip668sq1l) (pib:5)
[24 Oct 2008 1:18] Bugs System
Pushed into 5.1.28-ndb-6.3.19  (revid:jonas@mysql.com-20081021130033-awxkyjsip668sq1l) (version source revid:jonas@mysql.com-20081021131310-ypz6rb6glgt74zeq) (pib:5)
[24 Oct 2008 1:18] Bugs System
Pushed into 5.1.28-ndb-6.4.0  (revid:jonas@mysql.com-20081021130033-awxkyjsip668sq1l) (version source revid:jonas@mysql.com-20081021132059-7qmkuuv9k5c313gp) (pib:5)
[12 Dec 2008 23:27] Bugs System
Pushed into 6.0.9-alpha  (revid:jonas@mysql.com-20081021130033-awxkyjsip668sq1l) (version source revid:tomas.ulin@sun.com-20081209185954-9svcixh2p5hsfi6w) (pib:5)