MySQL Bugs: #65489: Schemas in right panel are unable to fetch list of tables within databases

Bug #65489	Schemas in right panel are unable to fetch list of tables within databases
Submitted:	2 Jun 2012 3:31	Modified:	3 Aug 2012 15:41
Reporter:	Angel Rend?n	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: SQL Editor	Severity:	S3 (Non-critical)
Version:	5.2.40	OS:	Linux (Linux 3.2.0-24-generic)
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
Every time I pick a DB up to see the tables it contains, it gets stuck trying to fetch such list. This also happens to views and procedures.

How to repeat:
Open a SQL Editor and pick a DB up, select it to work with that DB via double clicking.
Expand the tree that shows the menu for Tables, Views and Procedures.
It changes those names to "fetching..." and it's unable to expand further avoiding you to see the tables or views or procedures.

What exact server version, 5.x.y, are you working with? Had you upgraded server from some older version recently?

The version is 5.2.40 rev 8790

Before I was working with ubuntu 11.10 but I don't remember the version I had installed before.

I formated my laptop and installed ubuntu 12.04 from the scratch and I just went to the download section of mysql and just installed this version. 

I thought it was going to work since as the previous version.

I meant MySQL server version, not Workbench version...

mysql  Ver 14.14 Distrib 5.5.22, for debian-linux-gnu (x86_64) using readline 6.2

Hello Angel.
Can you please try the following command in a MySQL Server command line terminal and let us know the result?
SHOW FULL TABLES FROM db_name;
Where "db_name" is the name of the data base that you are trying to expand.
Thanks

It was happening to all my DB's I can't reveal too much about the tables I have but after the command I got the table name and in the front it says BASE TABLE.

Nevertheless since I fixed the graphic environment it started worked. I guess it was when I installed properly the integrated intel graphic card and the NVidia Card I was able to use the workbench properly. Now I can see the tables in the left panel for all my DB's.

If there is something I can post here to give you more information about this apparent incompatibility between the mysql-workbench and this cards I'll be pleased to help:

~$ lspci -nn | grep -i vga
00:02.0 VGA compatible controller [0300]: Intel Corporation 2nd Generation Core Processor Family Integrated Graphics Controller [8086:0116] (rev 09)
01:00.0 VGA compatible controller [0300]: NVIDIA Corporation GF119 [GeForce GT 520M] [10de:1050] (rev ff)

Thanks for the time and help

Thank you very much Angel for your valuable information.