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
6375
June 01, 2005 03:37AM
2730
June 01, 2005 01:21PM
2655
June 09, 2005 06:42AM
Re: cluster crash or error Duplicate entry '' for key 65
2749
June 10, 2005 06:18AM
2538
June 16, 2005 03:06AM
2465
June 16, 2005 06:28AM
2469
June 16, 2005 06:32AM
2559
June 20, 2005 05:46AM
6471
June 09, 2005 06:50AM
6372
June 09, 2005 07:57AM
3085
June 17, 2005 09:04AM
3040
June 20, 2005 05:56AM
2989
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.