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
6166
June 01, 2005 03:37AM
2618
June 01, 2005 01:21PM
2553
June 09, 2005 06:42AM
2647
June 10, 2005 06:18AM
2451
June 16, 2005 03:06AM
2372
June 16, 2005 06:28AM
2377
June 16, 2005 06:32AM
2449
June 20, 2005 05:46AM
6301
June 09, 2005 06:50AM
6245
June 09, 2005 07:57AM
2902
June 17, 2005 09:04AM
2932
June 20, 2005 05:56AM
2886
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.