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
6269
June 01, 2005 03:37AM
2661
June 01, 2005 01:21PM
2594
June 09, 2005 06:42AM
Re: cluster crash or error Duplicate entry '' for key 65
2694
June 10, 2005 06:18AM
2486
June 16, 2005 03:06AM
2409
June 16, 2005 06:28AM
2412
June 16, 2005 06:32AM
2482
June 20, 2005 05:46AM
6369
June 09, 2005 06:50AM
6295
June 09, 2005 07:57AM
2932
June 17, 2005 09:04AM
2987
June 20, 2005 05:56AM
2932
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.