Bug #50230 MySqlBulkLoader.load()
Submitted: 11 Jan 2010 13:07 Modified: 19 Jan 2010 11:35
Reporter: Raffaele Palmieri Email Updates:
Status: Not a Bug Impact on me:
Category:Connector / NET Severity:S2 (Serious)
Version: OS:Microsoft Windows (XP Service Pack 3)
Assigned to: CPU Architecture:Any
Tags: client timeout handling lock table

[11 Jan 2010 13:07] Raffaele Palmieri
When I try to import a very large text file in an InnoDB Table using MySqlBulkLoader.load and configure a normal timeout(100 s), the connector gives me: 
"Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding." , but on server by MySql Administrator GUI I can see the corresponding query 
"LOAD DATA INFILE etc. etc."
running again locking the destination table, that I cannot use to perform query against. 
From MySqlAdministrator if I try to kill active thread, the command state changes to "Killed" but thread remains active and table remains locked.  
I am using MySql Server 5.1.42-Community Edition on Windows XP SP 3.

How to repeat:
See description
[14 Jan 2010 17:27] Tonci Grgin
Hi Raffaele and thanks for your report.

Can you please attach small but complete test case (- the big file). It should definitely contain the connection string.
Also, I am interested in my.ini used to start server and any problems detected in error log.
[19 Jan 2010 11:31] Raffaele Palmieri
I am not able to repeat bug; maybe I gave to loader wrong parameters,
[19 Jan 2010 11:35] Tonci Grgin
No problem Raffaele. If you hit the problem again with repeatable test case, just attach it and reopen the report.