What's the statement on the failing line.
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
> the network is 100M ethernet (I plan to upgrade to
> 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
> in fact, the problem occurs with only two
> what's the problem ???
Senior Software Architect, MySQL AB
My blog: http://mikaelronstrom.blogspot.com