Re: cluster crash or error Duplicate entry '' for key 65
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
Subject
Views
Written By
Posted
6714
June 01, 2005 03:37AM
2888
June 01, 2005 01:21PM
2814
June 09, 2005 06:42AM
Re: cluster crash or error Duplicate entry '' for key 65
2874
June 10, 2005 06:18AM
2664
June 16, 2005 03:06AM
2609
June 16, 2005 06:28AM
2616
June 16, 2005 06:32AM
2740
June 20, 2005 05:46AM
6621
June 09, 2005 06:50AM
6571
June 09, 2005 07:57AM
3218
June 17, 2005 09:04AM
3185
June 20, 2005 05:56AM
3157
June 23, 2005 10:26AM
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.