Bug #55419 | Lost connection / timeout to MySQL server during query after 900 seconds | ||
---|---|---|---|
Submitted: | 20 Jul 2010 23:52 | Modified: | 21 Jul 2010 14:24 |
Reporter: | Orlando Colamatteo | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Workbench: SQL Editor | Severity: | S2 (Serious) |
Version: | 5.2.25 CE | OS: | Windows (64-bit 7.0 Professional) |
Assigned to: | CPU Architecture: | Any | |
Tags: | Lost connection, timeout |
[20 Jul 2010 23:52]
Orlando Colamatteo
[21 Jul 2010 1:01]
MySQL Verification Team
Thank you for the bug report. What is the behaviour with the mysql client tool with the same query?. Thanks in advance.
[21 Jul 2010 5:45]
Orlando Colamatteo
It times out after 900 seconds using my local mysql command line client as well. I logged into the server and used the local command line client there and it succeeded in executing the query totaling 1000 seconds of execution time. I guess that rules out the database server settings and brings us back to a client setting, or possibly network??? I am not sure this is a Workbench issue now. Any leads would however be appreciated. Thanks for reading.
[21 Jul 2010 8:40]
Susanne Ebrecht
Hello Orlando, 900 seconds == 15 minutes. This sounds like TCP timeout. Anyway, this is not a bug at all and bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug. Support on using our products is available both free in our forums at http://forums.mysql.com/ and for a reasonable fee direct from our skilled support engineers at http://www.mysql.com/support/ Thank you for your interest in MySQL.
[21 Jul 2010 14:24]
Orlando Colamatteo
I started this question in the forums as I did not assume it was a bug, but was asked to open a bug. I agree that this issue is likely not the fault of Workbench or any MySQL software. Thanks for the tip.
[6 Jul 2011 14:19]
Ilguiz Latypov
Does the MySQL client library allow to change the timeout on TCP connections?
[5 Mar 2012 12:47]
Michelle Sollicito
Surely MySql workbench could at least give a meaningful error rather than just timing out - could it not say "TCP connection lost due to timeout" or something so people know what caused the problem?