Bug #50230 MySqlBulkLoader.load()

• Submitted: 11 Jan 2010 13:07
• Modified: 19 Jan 2010 11:35
• Reporter: Raffaele Palmieri
• Status: Not a Bug
• Category: Connector / NET
• Severity: S2 (Serious)
• Version: 6.2.0.0
• OS: Windows (XP Service Pack 3)
• CPU Architecture: Any
• Tags: client timeout handling lock table

[11 Jan 2010 13:07] Raffaele Palmieri

Description:
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,
regards,
Raffaele.

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