Bug #57837 Lost connection with mySQL server during query longer then 30 seconds

• Submitted: 29 Oct 2010 8:48
• Modified: 29 Oct 2010 12:36
• Reporter: Sidney van de Stouwe
• Status: Duplicate
• Category: MySQL Workbench: SQL Editor
• Severity: S2 (Serious)
• Version: 5.2.29 win32
• OS: Windows (64)
• CPU Architecture: Any
• Tags: lost server connection, regression

[29 Oct 2010 8:48] Sidney van de Stouwe

Description:
After upgrade from 5.2.24-rc to 5.2.29 the following query timed out:

SELECT * FROM `gtpis_flow_results`.`ib_gauteng_industrial_basin` where ComIdx=66
INTO OUTFILE 'c:/users/sidney van de stouwe/documents/Gauteng-Durban 2050/Container-Tons.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';

The error was:
0	1	10:44:46	SELECT * FROM `gtpis_flow_results`.`ib_gauteng_industrial_basin` where ComIdx=66
INTO OUTFILE 'c:/users/sidney van de stouwe/documents/Gauteng-Durban 2050/Container-Tons.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'	Error Code: 2013
Lost connection to MySQL server during query	30.529 sec

How to repeat:
From the workbench execute the querry above. Make sure the query takes longer then 30 seconds to produce the result.

Suggested fix:
After uninstalling 5.2.29-Win32 and installing 5.2.24-rc the query executed fine again

[29 Oct 2010 12:36] Alfredo Kojima

This is a duplicate of bug #57449
The bug above also includes a workaround for this.