MySQL Bugs: #92554: Hangs when connecting, can do nothing, just stop

Bug #92554	Hangs when connecting, can do nothing, just stop
Submitted:	25 Sep 2018 7:59	Modified:	5 Nov 2018 15:33
Reporter:	darius val	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	6.3.6	OS:	Ubuntu (Ubuntu 16.04.4 LTS)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
It hangs. I did not change mysql parameters, from command line connecting works, when I test connection in workbench, it also shows success.

Log:

10:45:26 [INF][      WBContext]: Parsing application arguments.
10:45:26 [INF][      WBContext]:     /usr/lib/mysql-workbench/mysql-workbench-bin
10:45:26 [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/darius/.mysql/workbench
	open at start: 
	open type: 
	run at startup: 
	run type: 
	Force SW rendering: No
	Force OpenGL: No
	quit when done: No
10:45:26 [INF][      WBContext]: WbContext::init
10:45:26 [INF][            WBA]: Looking for extension modules for WBA...
10:45:26 [INF][            WBA]: 0 extension modules found
10:45:26 [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
10:45:26 [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
10:45:26 [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
10:45:27 [WRN][            grt]: /home/darius/.mysql/workbench/connections.xml:26: link '9ea1ee8b-c096-11e8-9f9a-e89a8fe9e73f' <object GrtObject> key=owner could not be resolved
10:45:27 [INF][      WBContext]: System info:
 	MySQL Workbench Community (GPL) for Linux/Unix version 6.3.6 CE build 511 (64 bit)
	Configuration Directory: /home/darius/.mysql/workbench
	Data Directory: /usr/share/mysql-workbench
	Cairo Version: 1.14.6
	OS: Linux 4.15.0-34-generic
	CPU: 2x Intel(R) Pentium(R) CPU B960 @ 2.20GHz (1087.307MHz) - 7.65GiB RAM
	Distribution: Ubuntu 16.04.4 LTS

	Fips mode enabled: no

10:45:27 [INF][    WQE backend]: Found auto-save workspace /home/darius/.mysql/workbench/sql_workspaces/Local_instance_3306-1.autosave
10:55:52 [INF][      SqlEditor]: Opened connection 'Local instance 3306' to (Ubuntu) version 5.7.23-0ubuntu0.16.04.1
10:55:52 [INF][     AutoCCache]: Initializing autocompletion cache for Local_instance_3306

How to repeat:
I open mysqlworkbench, double click on rectangle to connect https://i.imgur.com/13kquPv.png

Thank you for the bug report. I could not repeat with latest version 8.0.12.

I tried updating to 6.3.10 - still same.

Can I update to 8 ? when I go to download page it shows that it is for ubuntu 18. Or will it still work with xubuntu 16?

Tried running install of version8 file, but it does not update to 8.

I assume the the connection is on a local development environment.
If you can access MySQL via terminal, then give a shot downgrading MySQL Workbench  back to version 6.2.50.
But first verify if you can access MySQL Server via terminal.

Yes, connection is on local dev environment. I can access via terminal, also I am constantly developing applications using mysql. So mysql works definitely.

Tried 6.5.0 but I get errors:

sudo dpkg -i mysql-workbench-community-6.2.5-1ubu1410-amd64.deb 
[sudo] password for darius: 
Selecting previously unselected package mysql-workbench-community.
(Reading database ... 426843 files and directories currently installed.)
Preparing to unpack mysql-workbench-community-6.2.5-1ubu1410-amd64.deb ...
Unpacking mysql-workbench-community (6.2.5-1ubu1410) ...
Replacing files in old package mysql-workbench (6.3.6+dfsg-0ubuntu1) ...
Replacing files in old package mysql-workbench-data (6.3.6+dfsg-0ubuntu1) ...
dpkg: dependency problems prevent configuration of mysql-workbench-community:
 mysql-workbench-community depends on libatkmm-1.6-1 (>= 2.22.1); however:
  Package libatkmm-1.6-1 is not installed.
 mysql-workbench-community depends on libcairomm-1.0-1 (>= 1.6.4); however:
  Package libcairomm-1.0-1 is not installed.
 mysql-workbench-community depends on libctemplate2; however:
  Package libctemplate2 is not installed.
 mysql-workbench-community depends on libglibmm-2.4-1c2a (>= 2.42.0); however:
  Package libglibmm-2.4-1c2a is not installed.
 mysql-workbench-community depends on libgtkmm-2.4-1c2a (>= 1:2.24.0); however:
  Package libgtkmm-2.4-1c2a is not installed.
 mysql-workbench-community depends on libpangomm-1.4-1 (>= 2.27.1); however:
  Package libpangomm-1.4-1 is not installed.
 mysql-workbench-community depends on libpcrecpp0 (>= 7.7); however:
  Package libpcrecpp0 is not installed.
 mysql-workbench-community depends on libsigc++-2.0-0c2a (>= 2.2.0); however:
  Package libsigc++-2.0-0c2a is not installed.

dpkg: error processing package mysql-workbench-community (--install):
 dependency problems - leaving unconfigured
Processing triggers for hicolor-icon-theme (0.15-0ubuntu1) ...
Processing triggers for shared-mime-info (1.5-2ubuntu0.1) ...
Processing triggers for gnome-menus (3.13.3-6ubuntu3.1) ...
Processing triggers for desktop-file-utils (0.22-1ubuntu5.1) ...
Processing triggers for mime-support (3.59ubuntu1) ...
Errors were encountered while processing:
 mysql-workbench-community

But in download page I saw this is for ubuntu 14 so that might be the reason of errors.

Today I decided to test how it goes with mysql in docker. And I was able to connect it works ok. 

And then tried to connect to non docker connection - and still same as earlier - hangs.