MySQL Bugs: #68774: MySQL workbench hang up while fetching table from remote dataserver

Bug #68774	MySQL workbench hang up while fetching table from remote dataserver
Submitted:	26 Mar 2013 8:00	Modified:	15 Jun 2013 0:38
Reporter:	zhifeng hu hu	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S1 (Critical)
Version:	5.2.44	OS:	Linux
Assigned to:		CPU Architecture:	Any

Description:
MySQL workbench hang up while fetching table from remote dataserver
even we using tcp/ip or tcp/ip over ssh tunnel, it always hang up and dead.
we can not retrive information from remote server. the remote server got much more scheme and table.

How to repeat:
MySQL workbench hang up while fetching table from remote dataserver
even we using tcp/ip or tcp/ip over ssh tunnel, it always hang up and dead.
we can not retrive information from remote server. the remote server got much more scheme and table.

Please try version 5.2.47. Thanks.

I may be experiencing a similar problem - unsure from the description.

Background: workbench 5.2.47 running under OS X 10.6.8  server MySQL 5.5.25a-log on RHEL

Symptom: Right-clicking on table name in Schemas list, or clicking disclosure triangle next to table name, causes application to hang.  Issuing DESCRIBE query in query window functions as expected, so I'm not certain the problem is actually with retrieving data from the server (particularly as it's not evident that the context menu generated by the right click requires data from the server).

@Charles,

Please describe your databases qty of tables, network speed?. Thanks.

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".

This problem was resolved by myself. it's not a mysql workbench bug.

See:
https://mariadb.atlassian.net/browse/MDEV-4390

Sorry for long times delay.
I had done many research about this problem.
I found some body faced the same problem with me .

http://bugs.mysql.com/bug.php?id=55008
http://bugs.mysql.com/bug.php?id=55356

I tried their solution. then i got fixed.

Ok, let's talk how it occurs.

I previous using Mysql 5.5.30, some day, i compiled the MariaDB 5.5.30, import my old databases;
I should have to run mysql_upgrade, but i did not .

What i do got fixed is just simple: 

type and run mysql_upgrade -h 127.0.0.1

then the mysql workbench working correct.

if you got upgrade from old to latest version MySQL or MariaDB,
you really should run mysql_upgrade, to check if your scheme got problems.
the mysql_upgrade tools will help you repair some problem.

i will keep watching it. see if it will appears next time.

sorry for the delay.

I'm not sure if this is an acceptable answer, but I am working with a table that is "wide" (ie large # of columns). It worked fine for months up until this week. Well, this week, I added a column to this table. A very small width column (varchar(2)) and it started hanging.

I can repeat the hang scenario if I recreate the table with that new column again.

I was comfortable with refactoring my table structure into multiple tables that reference each other. But I still think that my table is relatively small in width to what you may use, and MySQL should look into this.