Lost connection to MySQL server during query

[Beach Ball]

MySQL loses the connection during the loading of large data sets into a table. For example, the following command:

load data infile '/tmp/invoices.txt' into table Invoices;

ends in the following error:

ERROR 2013 (HY000): Lost connection to MySQL server during query

I have searched different forums and read reports that this is a MySQL bug that has been fixed; however, the version of MySQL in Ubuntu 8.0.4 is too old to contain this fix.

See http://forums.mysql.com/read.php?93,269108,270139#msg-270139

Is there any way to get the fixed implemented for MySQL running on Ubuntu 8.0.4? This is a mission critical server that it is running on.

[Beach Ball (surfin10)]

Additionally, this bug doesn't affect just the ability to import large data sets. It also affects the ability to perform ALTER functions. I received the same error when trying to rename a column on a table containing several million rows.

[Chuck Short (zulcss)]

Once we determine what the fix is then yes it should be possible. Can you please attach your mysql confgiuration files?

Thanks
chuck

[Beach Ball (surfin10)]

Chuck, I have attached the my.cnf file.

The system is running Ubuntu 8.04 Server, 64-bit, with all updates. It has 12GB of RAM.

Thank you.

[Chuck Short (zulcss)]

How big is the file you are trying to import btw?

Regards
chuck

[Beach Ball (surfin10)]

Chuck Short,

Sorry this took so long to respond. I had to find the original file I was trying to import. It is 7.82 GB.

[Chuck Short (zulcss)]

Can you try this using mysql 5.1.

thanks
chuck

[Beach Ball (surfin10)]

Chuck Short,

I was able to load the same data into MySQL 5.1, running on Ubuntu 10.04 64-bit server, today without encountering the same problem.

Thanks.

[Chuck Short (zulcss)]

Closing bug report then.