MySQL Bugs: #10259: Lost connection with MySQL Server during LOAD INFILE

Bug #10259	Lost connection with MySQL Server during LOAD INFILE
Submitted:	29 Apr 2005 11:53	Modified:	2 Jul 2006 8:23
Reporter:	Jordi Garcia	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Command-line Clients	Severity:	S2 (Serious)
Version:	4.1.11	OS:	Windows (Win32)
Assigned to:		CPU Architecture:	Any

Description:
I have a program that executes several sentences using the same connection to the database server. When it gets to the following line:

LOAD DATA LOCAL INFILE "C:/Temp2.txt" INTO TABLE Temp2 LINES TERMINATED BY "\r\n";

my program raises an exception that says: "Lost connection to MySLQ Server".

I was using version 4.1.8 before and I had no problems with the same sentences and file. Actually I could solve the situation just moving back my server to version 4.1.8 (I had no time to test versions from 4.1.9 to 4.1.10).

The table Temp has only 3 fields (int, tinyint and int). The text file is well formatted for the structure of the table (3 numbers and 2 tabs per line) and its size is about 1.5Mb.

Its strage because it executed another "LOAD DATA LOCAL INFILE" sentence before that one with no errors (I noted that the size of the first one was about 0.5Mb).

How to repeat:
The problematic sentence is the 6th (the one mentioned before). Here comes the full sequence:

CREATE TEMPORARY TABLE Temp1 LIKE Sentences;

LOAD DATA LOCAL INFILE "C:/Temp1.txt" INTO TABLE Temp1 LINES TERMINATED BY "\r\n";

INSERT INTO Sentences
SELECT * FROM Temp1 ORDER BY SentenceId;

DROP TABLE Temp1;

CREATE TEMPORARY TABLE Temp2 LIKE SentenceTokens;

LOAD DATA LOCAL INFILE "C:/Temp2.txt" INTO TABLE Temp2 LINES TERMINATED BY "\r\n";

INSERT INTO SentenceTokens
SELECT * FROM Temp2 ORDER BY SentenceId,TokenOrder;

DROP TABLE Temp2;

Suggested fix:
while this issue is not fixed I can use release 4.1.8 safely.

Sample files and SQL to create tables

Attachment: BugFiles.part01.rar (application/octet-stream, text), 200.00 KiB.

Sample files and SQL to create tables

Attachment: BugFiles.part02.rar (application/octet-stream, text), 200.00 KiB.

Sample files and SQL to create tables

Attachment: BugFiles.part03.rar (application/octet-stream, text), 73.73 KiB.

Hi Jordi,

Can you please send us a reproducible test case with all the fields and tables that you used for this ?

Thanks

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".

Please, try to repeat with a newer version, 4.1.19, and inform about the results.

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".