List:Cluster« Previous MessageNext Message »
From:Jim Hoadley Date:May 3 2005 4:57pm
Subject:Re: Duplicate entry error
View as plain text  
Hi --

Have you tried this same query with MyISAM tables?
If your query works with MyISAM, and not with ndbcluster, 
then you're probably experiencing what I described in this post:

http://lists.mysql.com/cluster/1856

Which is a bug:

http://bugs.mysql.com/bug.php?id=9675

Supposed to be fixed in 4.1.12.

-- Jim Hoadley
   Sr Soft Eng
   Dealer Fusion, Inc






--- philong.nguyen@stripped wrote:
> Hello,
> 
> I am running MySQL Cluster 4.1.8 and I'm trying to do the following
> insert and it keeps complaining about duplicate entry '62.6.88.11-1/0.5'
> 
> INSERT INTO tab1 SELECT * FROM tab2;
> 
> Here is the definiton of tab1.
> mysql> describe tab1;
> +------------------+--------------+------+-----+---------+-------+
> | Field            | Type         | Null | Key | Default | Extra |
> +------------------+--------------+------+-----+---------+-------+
> | DeviceIP         | varchar(15)  |      | PRI |         |       |
> | InterfaceName    | varchar(255) |      | PRI |         |       |
> | ServiceSpeedConf | varchar(64)  | YES  |     | NULL    |       |
> | ServiceID        | varchar(160) | YES  |     | NULL    |       |
> | CustomerID       | varchar(16)  |      | 	|         |       |
> | NumConns         | int(11)      | YES  |     | NULL    |       |
> +------------------+--------------+------+-----+---------+-------+
> 
> An extract of tab2
> ...
> 
>   62.6.88.11 | 1/0.5         |                  |           | 88142
> |        1 |
> | 62.6.88.11 | 1/0.65        |                  |           | 88142
> |        1 |
> | 62.6.88.11 | 1/0.7         |                  |           | 88142
> |        1 |
> | 62.6.88.11 | 1/0.59        |                  |           | 88142
> |        1 |
> 
> ...
> 
> 
> There are NO keys defined in tab2.
> 
> Can someone tell me why it's complaining about duplicate key since the
> combination of "DeviceIP + InterfaceName" is different. This looks like
> it does not consider what is behind the "." in the InterfaceName field.
> 
> Thanks for your help,
> 
> Philong
> 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 
Thread
Duplicate entry errorphilong.nguyen3 May
Re: Duplicate entry errorJim Hoadley3 May