error 4243 'Index not found' while adding constraint
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
Subject
Views
Written By
Posted
error 4243 'Index not found' while adding constraint
1871
January 28, 2015 07:58AM
679
January 28, 2015 08:02AM
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.