MySQL Forums
Forum List  »  NDB clusters

Re: cluster crash or error Duplicate entry '' for key 65
Posted by: Mikael Ronström
Date: June 01, 2005 01:21PM

What's the statement on the failing line.

Rgrds Mikael

Pierre COLOMBIER wrote:
> 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 ???

Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:

Options: ReplyQuote

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.