MySQL Forums
Forum List  »  NDB clusters

Add index for mysql table with ndbcluster storage engine
Posted by: urgen sherpa
Date: May 28, 2016 10:54PM

I am having trouble while adding index on mysql table with ndbcluster storage engine below is the error . [mysqlcluster ver. 7.4 GA]

mysql> alter table `sks_staff_office` add index `pid_index` (pid);
ERROR 1296 (HY000): Got error 156 'Unknown error code' from NDBCLUSTER

mysql> create ONLINE index pid_index on sks_staff_office(pid);
ERROR 1296 (HY000): Got error 156 'Unknown error code' from NDBCLUSTER

mysql> alter online table `sks_staff_office` add index `pid_index` (pid);
ERROR 1296 (HY000): Got error 156 'Unknown error code' from NDBCLUSTER
the link i reffered to is

http://dev.mysql.com/doc/refman/5.6/en/alter-table-online-operations.html

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.