Bug #17154 load data infile hangs when duplicate key encountered
Submitted: 6 Feb 2006 15:27 Modified: 14 Feb 2006 10:28
Reporter: Jonathan Miller
Status: Closed
Category:Server: Cluster Severity:S2 (Serious)
Version:5.0-> OS:Linux (Linux 32 Bit OS)
Assigned to: Tomas Ulin Target Version:

[6 Feb 2006 15:27] Jonathan Miller
Description:
In debugging another issue, I ran into this one. The test below will hang mysql-test and
not return. Looking at TOP you see that the ndbd's are getting CPU time, but still the
test never returns.

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 1709 root      16   0  2740  612  528 S  0.3  0.0   7:29.38 nifd
14599 ndbdev    15   0  322m 161m 2876 S  0.3  5.3   0:02.01 ndbd
14615 ndbdev    15   0  322m 161m 2744 S  0.3  5.3   0:02.02 ndbd

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 1709 root      16   0  2740  612  528 S  0.3  0.0   7:29.44 nifd
14599 ndbdev    15   0  322m 161m 2876 S  0.3  5.3   0:02.13 ndbd
14615 ndbdev    15   0  322m 161m 2744 S  0.3  5.3   0:02.15 ndbd

How to repeat:
--disable_warnings
DROP TABLE IF EXISTS t1;
--enable_warnings
create table t1 (word char(20) not null PRIMARY KEY)ENGINE=NDB;
load data infile '../../std_data/words.dat' into table t1 ;
select count(*) from t1;
DROP TABLE t1;
[6 Feb 2006 15:46] Valeriy Kravchuk
Thank you for a problem report. Can you, please, try to repeat it on 5.1.7-beta and inform
about the results?
[6 Feb 2006 17:15] Tomas Ulin
verified in 5.1.7 

./mysql-test-run --start-and-exit --do-test=ndb

create table t1 (word char(20) not null PRIMARY KEY)ENGINE=NDB;
load data infile '../../std_data/words.dat' into table t1 ;

... hangs
[6 Feb 2006 23:33] Tomas Ulin
see 17081
[7 Feb 2006 9:23] Tomas Ulin
pushed into 5.0.19

will be pushed into 5.1.7 one merge jam is released
[7 Feb 2006 10:52] Bugs System
A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2225
[7 Feb 2006 10:53] Tomas Ulin
pushed to 5.1.7
[14 Feb 2006 10:28] Jon Stephens
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html

Additional info:

Documented fix in 5.1.7 changelog. Bug closed.