MySQL Forums
Forum List  »  NDB clusters

13million row drop index failure
Posted by: Adam D
Date: September 22, 2005 05:23PM

This table has 13million odd rows, I thought dropping an index would be as quick as dropping a table, but it seems to have to manipulate each row. It took forever, it ran overnight, so i typed in show warnings in case it didnt work and i got this back.

mysql> drop index someId on tablename;
ERROR 1296 (HY000): Got error 1 'Unknown error code' from ndbcluster
mysql> show warnings;
+-------+------+----------------------------------------------------------------------------------------------+
| Level | Code | Message |
+-------+------+----------------------------------------------------------------------------------------------+
| Error | 1296 | Got error 1 'Unknown error code' from ndbcluster |
| Error | 1296 | Got error 4116 'Operation was not defined correctly, probably missing a key' from NDB |
| Error | 1296 | Got error 4116 'Operation was not defined correctly, probably missing a key' from ndbcluster |
| Error | 1180 | Got error 4116 during COMMIT |
+-------+------+----------------------------------------------------------------------------------------------+
4 rows in set (0.00 sec)

# perror --ndb 4116
OS error code 4116: Operation was not defined correctly, probably missing a key: Permanent error: Application error

Ive never sucsessfully changed the structure of this table of 13million rows - I always get some form of error. Anyone have an idea as to whats happened here and or how to configure cluster so that sctructure changes are possible on such a large table.

Options: ReplyQuote


Subject
Views
Written By
Posted
13million row drop index failure
2309
September 22, 2005 05:23PM


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.