Bug #49986 load data from the pipe hang,can not stop the process.
Submitted: 30 Dec 2009 6:41 Modified: 30 Jan 2010 10:36
Reporter: Zhou Po Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Locking Severity:S5 (Performance)
Version:5.0.45 OS:Linux (Red Hat 4.1.2-44)
Assigned to: CPU Architecture:Any
Tags: load data pipe hang

[30 Dec 2009 6:41] Zhou Po 
Description:
when I load date into a table(MyISAM) from a pipe file.sometimes it will hang.and you can not stop the process.use show processlist,the status is NULL,Command is Killed.but the time is increasing.the table is locked!the table is locked until you kill the server and restart mysql.

How to repeat:

shell(1):
mkfifo /file/test-fifo
chmod 666 /file/test-fifo

shell(2):
create table test(a int);
load data infile '/file/test-fifo' into table test;

shell(1)
rm /file/test-fifo
[30 Dec 2009 10:36] MySQL Verification Team 
Thank you for the bug report. 5.0.45 is older are you tried latest release?. Thanks in advance.
[31 Jan 2010 0:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[12 Sep 2017 8:17] Pavel Katiushyn 
Just had same problem on 5.6