Bug #79422 Error getting DDL for object - MySQL server has gone away
Submitted: 26 Nov 2015 11:05 Modified: 26 Nov 2015 13:38
Reporter: elzo valugi Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S5 (Performance)
Version:6.3.5 OS:Linux (Ubuntu 14.04.3 LTS)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[26 Nov 2015 11:05] elzo valugi
Description:
----[For better reports, please attach the log file after submitting. You can find it in /home/valugi/.mysql/workbench/log/wb.log]
07:07:57 [INF][      WBContext]: Parsing application arguments.
07:07:57 [INF][      WBContext]:     /usr/bin/mysql-workbench-bin
07:07:57 [INF][   WBContext UI]: Initializing workbench context UI with these values:
	base dir: /usr/share/mysql-workbench
	plugin path: /usr/lib/mysql-workbench/plugins
	struct path: /usr/share/mysql-workbench/grt
	module path: /usr/lib/mysql-workbench/modules
	library path: /usr/share/mysql-workbench/libraries
	user data dir: /home/valugi/.mysql/workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
07:07:57 [INF][      WBContext]: WbContext::init
07:07:58 [INF][            WBA]: Looking for extension modules for WBA...
07:07:58 [INF][            WBA]: 0 extension modules found
07:07:58 [WRN][            grt]: Could not load db.mysql.sqlide.grt.so: Could not open module /usr/lib/mysql-workbench/modules/db.mysql.sqlide.grt.so (/usr/lib/mysql-workbench/modules/db.mysql.sqlide.grt.so: undefined symbol: _ZTI10Sql_editor)	
07:07:58 [WRN][            grt]: /usr/share/mysql-workbench/data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
07:07:58 [WRN][            grt]: /usr/share/mysql-workbench/data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
07:07:58 [WRN][            grt]: /usr/share/mysql-workbench/data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
07:07:58 [WRN][            grt]: /home/valugi/.mysql/workbench/connections.xml:30: link 'b7d361b6-92c9-11e5-bb40-3085a98d4702' <object GrtObject> key=owner could not be resolved
07:07:58 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 6.3.5 CE build 201 (64 bit)
	Configuration Directory: /home/valugi/.mysql/workbench
	Data Directory: /usr/share/mysql-workbench
	Cairo Version: 1.13.1
	OS: Linux 3.13.0-68-generic
	CPU: 6x AMD Phenom(tm) II X6 1055T Processor (3259.001MHz) - 15,64GiB RAM
	Distribution: Ubuntu 14.04.3 LTS

	Fips mode enabled: no

07:07:59 [INF][     SSH tunnel]: Starting tunnel
07:07:59 [INF][     SSH tunnel]: Existing SSH tunnel not found, opening new one
07:07:59 [INF][     SSH tunnel]: Opening SSH tunnel to website.no:22
07:08:01 [INF][     SSH tunnel]: TunnelManager.wait_connection returned OK
07:08:01 [INF][sshtunnel.py:set_keepalive:502]: SSH KeepAlive setting skipped.
07:08:01 [INF][     SSH tunnel]: SSH tunnel connect executed OK
07:08:03 [INF][      SqlEditor]: Opened connection 'website' to (Debian) version 5.1.73-1+deb6u1-log
07:08:03 [INF][     AutoCCache]: Initializing autocompletion cache for website
12:18:43 [ERR][     AutoCCache]: Exception while running refresh task: Lost connection to MySQL server during query
12:18:43 [ERR][     AutoCCache]: Exception while running refresh task: MySQL server has gone away
12:18:43 [ERR][     AutoCCache]: Exception while running refresh task: MySQL server has gone away
12:18:43 [ERR][     AutoCCache]: Exception while running refresh task: MySQL server has gone away
12:18:43 [ERR][     AutoCCache]: Exception while running refresh task: MySQL 
09:02:30 [ERR][     AutoCCache]: Exception while running refresh task: MySQL server has gone away

[truncated]

10:59:05 [WRN][SqlEditorSchemaTree]: Unable to get DDL for website.view__fo_tradeError getting SQL definition for website.view__fo_trade: MySQL server has gone away
10:59:59 [WRN][SqlEditorSchemaTree]: Unable to get DDL for website.view__fo_tradeError getting SQL definition for website.view__fo_trade: MySQL server has gone away
11:00:22 [WRN][SqlEditorSchemaTree]: Unable to get DDL for website.view__fo_trade

How to repeat:
Just updated to 6.3.5 and the connection dies very very often, with no apparent reason. Sometimes while doing select queries, sometimes while viewing views code.
[26 Nov 2015 13:38] MySQL Verification Team
Thank you for the bug report. I couldn't repeat on my side please check the Manual about the error are you getting:

https://dev.mysql.com/doc/refman/5.1/en/gone-away.html