MySQL Forums
Forum List  »  NDB clusters

Duplicate entry '3841' for key 1 in query
Posted by: mikeh
Date: November 02, 2005 08:18AM

I am trying to get my site running in a cluster. I dumped the site, changed ENGINE from MyISAM to ndbcluster and reloaded.
All seemed well until I tried to update a table..

Duplicate entry '3841' for key 1 in query:
REPLACE INTO config (name, type,value,blob_value) VALUES ('root_url', 0, 'http://www.amazon.com';, NULL)

This is how table was created;

CREATE TABLE `config` (
`config_id` int(11) NOT NULL auto_increment,
`name` varchar(64) NOT NULL default '',
`type` smallint(6) default '0',
`value` varchar(255) default NULL,
`blob_value` blob,
PRIMARY KEY (`config_id`),
UNIQUE KEY `name` (`name`)
) ENGINE=ndbcluster DEFAULT CHARSET=latin1 AUTO_INCREMENT=3841 ;

Can anybody throw any light on this error, It happens for any update to this table.

Options: Reply• Quote


Subject
Views
Written By
Posted
Duplicate entry '3841' for key 1 in query
2826
November 02, 2005 08:18AM
1551
November 02, 2005 08:34AM
1594
November 08, 2005 03:22AM
1707
November 08, 2005 09:39PM
1680
November 14, 2005 02:56AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.