Bug #17154 load data infile hangs when duplicate key encountered

• Submitted: 6 Feb 2006 14:27
• Modified: 14 Feb 2006 9:28
• Reporter: Jonathan Miller
• Status: Closed
• Category: MySQL Cluster: Cluster (NDB) storage engine
• Severity: S2 (Serious)
• Version: 5.0->
• OS: Linux (Linux 32 Bit OS)
• Assigned to: Tomas Ulin
• CPU Architecture: Any

[6 Feb 2006 14: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 14: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 16: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 22:33] Tomas Ulin

see 17081

[7 Feb 2006 8:23] Tomas Ulin

pushed into 5.0.19

will be pushed into 5.1.7 one merge jam is released

[7 Feb 2006 9: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 9:53] Tomas Ulin

pushed to 5.1.7

[14 Feb 2006 9: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.