MySQL Forums
Forum List  »  NDB clusters

Re: cluster crash or error Duplicate entry '' for key 65
Posted by: Martin Skold
Date: June 10, 2005 06:18AM

Hi Pierre!

There is actually a known bug in the printout for duplicate keys for
cluster. If you are sending several values in one large insert, they
are batched (i.e. executed in parallel). If you then get a duplicate
key error, it will point to the last one in the batch, even though
this might not be the trouble row. What does your insert statement(s)
look like? Do you have any unique keys defined on the table?

We don't know yet how to fix this since saving all key values in a
batch would be too expensive.
Initially a more generic printout was used where the actual key
value was not returned, but we got a bug report that this was the
wrong error code and some application was not possible to port
to cluster.

You can try running your inserts towards another storage engine
and see what it says.

BR
Martin Skold

Options: ReplyQuote




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.