cluster crash or error Duplicate entry '' for key 65
I'm trying to move a big database to ndb cluster
(my source file is an sql dump)
my cluster is configured with 1adm, 10 NDB nodes (2 replica)
and only 2 api but i plan to add some mode.
all theses computers are 3GHz P4 with 1Go RAM each
the network is 100M ethernet (I plan to upgrade to gigabit)
I'm trying to fill my tables with a huge list of INSERT commands.
mysql databasename <myfile.sql
it is VERY slow!
then, i tried to use a large number of process.
mysql databasename <myfile_part01.sql &
mysql databasename <myfile_part02.sql &
mysql databasename <myfile_part03.sql &
[...]
mysql databasename <myfile_part30.sql &
mysql databasename <myfile_part32.sql &
It's faster but sometimes i've got
ERROR 1062 at line 34567: Duplicate entry '' for key 65
I double checked everything and I'm absolutely sure there are no identical lines in the input files. I'm also absolutely sure that theses lines don't have empty fields nor value '65'
If I drop everything and do it again, the line number always change but the error "Duplicate entry '' for key 65" is always the same. It seems to be a random error (concurrent access error ?)
I thought 32 process inserting data was too much and tried reducing the number of concurrent insert process.
in fact, the problem occurs with only two process.
what's the problem ???
Subject
Views
Written By
Posted
cluster crash or error Duplicate entry '' for key 65
6270
June 01, 2005 03:37AM
2663
June 01, 2005 01:21PM
2594
June 09, 2005 06:42AM
2695
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
6370
June 09, 2005 06:50AM
6295
June 09, 2005 07:57AM
2932
June 17, 2005 09:04AM
2987
June 20, 2005 05:56AM
2934
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.