Bug #9821 Eventually socket write error occurred when loading data from local drive

• Submitted: 11 Apr 2005 16:07
• Modified: 12 Apr 2005 14:15
• Reporter: Eugene Karpov
• Status: Can't repeat
• Category: Connector / J
• Severity: S1 (Critical)
• Version: 3.1.6
• OS: Windows (Windows XP SP2)
• CPU Architecture: Any

[11 Apr 2005 16:07] Eugene Karpov

Description:
Server MySQL 4.1.10.

Eventually Connector/J failed with the following exception:

Database error occurred: Communications link failure due to underlying exception:

** BEGIN NESTED EXCEPTION **

java.net.SocketException

MESSAGE: Software caused connection abort: socket write error

STACKTRACE:

java.net.SocketException: Software caused connection abort: socket write error
at java.net.SocketOutputStream.socketWrite0(Native Method)
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at java.io.BufferedOutputStream.write(BufferedOutputStream.java:106)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2618)
at com.mysql.jdbc.MysqlIO.send(MysqlIO.java:2551)
at com.mysql.jdbc.MysqlIO.sendFileToServer(MysqlIO.java:2716)
at com.mysql.jdbc.MysqlIO.readResultsForQueryOrUpdate(MysqlIO.java:1900)
at com.mysql.jdbc.MysqlIO.readAllResults(MysqlIO.java:1350)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1670)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2291)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2226)
at com.mysql.jdbc.Statement.execute(Statement.java:883)

** END NESTED EXCEPTION **

in SQL statement 'LOAD DATA LOCAL INFILE 'C:\\DOCUME~1\\user\\LOCALS~1\\Temp\\load27653.dat' REPLACE INTO TABLE tttt FIELDS TERMINATED BY ';' ESCAPED BY '`''.

I've tried to set net-read-timeout and net-write-timeout variables to higher values, but it didn't help. Disk containing MySQL data files has pretty much free space available (>6Gb).

How to repeat:
Load any semicolon-separated text file into remote MySQL server.

[12 Apr 2005 14:15] Mark Matthews

Loading files is part of our testsuite. You will need to post the DDL of the table(s) involved as well as sample files for us to be able to repeat why this isn't working for you.