Bug #77145 Hostgator & MySQL Workbench 6.3.3 connection
Submitted: 24 May 2015 14:51 Modified: 23 Nov 2017 20:10
Reporter: Raymar Duprey Email Updates:
Status: Patch pending Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.3.4 OS:MacOS (Yosemite)
Assigned to: CPU Architecture:Any
Tags: Hostgator, Macintosh, workbench

[24 May 2015 14:51] Raymar Duprey
Description:
Workbench 6.3.3 connects successfully to SQL server hosted in Hostgator where I can see all database schemas and sometimes tables, but when I trie to execute an SQL statement in tables (SELECT * FROM db.table) this errors appear:
ERROR 2006 : MySQL Server has gone away
ERROR 2013 : Lost connection to MySQL server during query

How to repeat:
Connect Workbench to MySQL Server hosted in Hostgator. Create some tables, then execute the SQL statement.

Suggested fix:
I downgrade to Workbench 6.2.5.0 build 397 it works fine for now.
[15 Sep 2015 21:58] MySQL Verification Team
Gone away on Yosemite

Attachment: gone_away.png (image/png, text), 582.30 KiB.

[15 Sep 2015 22:00] MySQL Verification Team
Thank you for the bug report.

I was able to repeat after some hours in idle condition I checked after 8 hours however could be less time on idle status.
[15 Sep 2015 22:06] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=77767 marked as duplicate of this one.
[28 Sep 2015 14:00] MySQL Verification Team
Please check with mysql.exe client command prompt if you get the same behavior than WorkBench. Thanks.
[29 Oct 2015 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[24 Dec 2015 23:17] Dean Householder
This is also happening on MySQL WorkBench 6.3.5 on Windows 10 connecting over SSH tunnel on a Digital Ocean server.  MySQL is not exposed publicly so tunneling is necessary.  This may or may not be part of the issue.  Perhaps SSH is what is terminating the session?
[25 Jan 2016 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".
[11 Apr 2016 19:58] Abram Adams
Having this issue on Windows 7 and MySQL Workbench 6.3.6 build 511 CE.  I've tried increasing the DBMS keep-alive setting in the workbench preferences to a very high number, but it still disconnects from the server frequently (after several minutes of inactivity).
[11 May 2016 0:21] Bilal Abdeen
I get exactly the same problem using the following. 
- MySQL Workbench 6.3.6 build 511 CS 64bit on MS Windows 10 
- Connecting to Hostgator
[11 May 2016 0:53] Bilal Abdeen
For the record, it provides the error message for any submission sent almost immediately after connecting. In other words, I connect successfully. Then, submit an SQL. It gives the error. 

I uninstalled Workbench 6.3.6 build 511 CS (64 bit), and installed version 6.2.4.12437 build 2427 (64 bit). It worked smoothly, using the existing connection settings.
[23 Nov 2017 20:10] MySQL Verification Team
Please check with version 6.3.10. Thanks.