Bug #28496 Missing error messages for NDB error codes
Submitted: 17 May 2007 11:48 Modified: 22 Oct 2008 0:35
Reporter: Kristian Nielsen
Status: Closed
Category:Server: Cluster Severity:S3 (Non-critical)
Version:5.1-telco OS:Any
Assigned to: Bugs System Target Version:
Triage: Triaged: D4 (Minor)

[17 May 2007 11: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 11: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 14:51] Lee Wonseok
this bug is not yet fix?

In mysql5.1.27-ndb6.3.17 occurred same error.
[21 Oct 2008 14: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 17:42] Jonas Oreland
pushed into 62, 63 and 64
[21 Oct 2008 17:44] Jonas Oreland
6.2.17 and 6.3.19
[21 Oct 2008 18:43] Lee Wonseok
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?
[22 Oct 2008 0: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.
[22 Oct 2008 0: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.
[22 Oct 2008 0: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 3: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 3: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 3: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)
[13 Dec 2008 0: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)