Description:
******************************************************************
ndb_mgm -e show:
Connected to Management Server at: 134.186.104.10:1186 Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=3 @134.186.104.10 (Version: 5.0.15, Nodegroup: 0)
id=4 @134.186.104.13 (Version: 5.0.16, Nodegroup: 0, Master)
[ndb_mgmd(MGM)] 2 node(s)
id=1 @134.186.104.10 (Version: 5.0.15)
id=2 @10.10.10.15 (Version: 5.0.16)
[mysqld(API)] 2 node(s)
id=5 @10.10.10.15 (Version: 5.0.16)
id=6 (not connected, accepting connect from any host)
******************************************************************
To my embarrassment, it does look like a version mismatch problem.
I should have noticed that... I must not have updated all of my ports on these systems Perhaps a more verbose error would help?
Doug Hunting
Software Engineer
-----Original Message-----
From: Stewart Smith [mailto:stewart@mysql.com]
Sent: Monday, December 19, 2005 4:41 PM
To: Doug Hunting
Cc: cluster@lists.mysql.com
Subject: RE: Cannot Create Index
On Mon, 2005-12-19 at 15:59 -0800, Doug Hunting wrote:
> mysql> ALTER TABLE City ADD INDEX `Population`(Population);
> ERROR 1025 (HY000): Error on rename of './world/City' to
> './world/#sql2-41ff-3d' (errno: 763)
> mysql> SHOW WARNINGS;
> +-------+------+------------------------------------------------------
> +-------+------+------
> ---------------+
> | Level | Code | Message
> |
> +-------+------+------------------------------------------------------
> +-------+------+------
> ---------------+
> | Error | 1296 | Got error 763 'Unknown error code' from NDB
> |
> | Error | 1025 | Error on rename of './world/City' to
> './world/#sql2-41ff-3d' (errno: 763) |
> +-------+------+------------------------------------------------------
> +-------+------+------
> ---------------+
> 2 rows in set (0.00 sec)
Seeing as it says "Unknown error code", please report a bug on this at least
- we should print a nice error message out for you. (this means you'll also
get notification on when we fix the bug)
The error code seems to be for IncompatibleVersion. Are all your nodes
running the same version? what's the output of ndb_mgm -e show ?
> --I am using the world.sql database with the engine changed to
> ENGINE=NDB --Both datanodes are using the same my.cnf file
>
> Let me know if there is any further information that I can provide
> that may be of more help
config.ini and the output of ndb_mgm -e 'show' would be useful
How to repeat:
see above
Suggested fix:
Proper error message
