Thread: Mysql cluster 7 - Desperate need help

Hi! when I try to alter my table using this command

ALTER TABLE t_library ADD f_date_updated datetime DEFAULT NULL;

I got this error:

ERROR 1005 (HY000): Can't create table 'db_crawler.#sql-47cf_29cff' (errno: 136)

Mysql cluster is up and running. I have 2 mgmt server, 2 node, 2 api

Which user you are using to alter the table...

if root..

The also try this...

SET FOREIGN_KEY_CHECKS = 0;
ALTER TABLE t_library ADD f_date_updated datetime DEFAULT NULL;
SET FOREIGN_KEY_CHECKS = 1;

If it do not work, then try this..
edit the cluster config.ini, then check this setting...
MaxNoOfOrderedIndexes=128

increase it to
MaxNoOfOrderedIndexes=1024

restart the cluster and nodes


Note: 1st method - not confirm, that, will it make the changes permanent....