MySQL Forums
Forum List  »  NDB clusters

error 4243 'Index not found' while adding constraint
Posted by: Vladislav Belogrudov
Date: January 28, 2015 07:58AM

Hi,

I am getting error 4243 'Index not found' from NDBCLUSTER") 'ALTER TABLE aggregate_metadata ADD CONSTRAINT uniq_aggregate_metadata0aggregate_id0key0deleted UNIQUE (aggregate_id, `key`, deleted)'

The table I try to add constraint to:

CREATE TABLE `aggregate_metadata` (
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
`deleted_at` datetime DEFAULT NULL,
`id` int(11) NOT NULL AUTO_INCREMENT,
`aggregate_id` int(11) NOT NULL,
`key` varchar(255) NOT NULL,
`value` varchar(255) NOT NULL,
`deleted` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `aggregate_id` (`aggregate_id`),
CONSTRAINT `FK_262_282` FOREIGN KEY(`aggregate_id`) REFERENCES `aggregates` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=ndbcluster DEFAULT CHARSET=utf8;

Can I workaround this problem? Anything to change in config.ini?

Thanks for any hints!
Vladislav

Options: ReplyQuote


Subject
Views
Written By
Posted
error 4243 'Index not found' while adding constraint
1871
January 28, 2015 07:58AM


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.