Bug 745471

Summary: MySQL Workbench not loading tables
Product: [Fedora] Fedora Reporter: Radamanf <radamanf>
Component: mysql-workbenchAssignee: Remi Collet <fedora>
Status: CLOSED INSUFFICIENT_DATA QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: high Docs Contact:
Priority: unspecified    
Version: 15CC: fedora
Target Milestone: ---   
Target Release: ---   
Hardware: x86_64   
OS: Linux   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2012-01-05 16:11:30 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Attachments:
Description Flags
Screenshot none

Description Radamanf 2011-10-12 13:21:12 UTC 
Description of problem:
When opening Workbench to see database tables data it didn't display tables in DB, so I should select default DB, then click Schemas refresh button without opening selected DB and then open - it displays tables, in any other cases it won't.

Version-Release number of selected component (if applicable):
MySQL Workbench version 5.2.35 rev 7915

How reproducible:
Start new Workbench with 12 databases and more than 30 tables in each

Steps to Reproduce:
1. Create at least 12 DB with about 30 tables inside in each (It's working fine with 1-2 DB's)
2. Try to open any DB to see tables
3. They will be in fetching state infinitely
  
Actual results:
fetching tables without any result

Expected results:
Should display tables without any workarounds 

Additional info:
Example in attachment
Comment 1 Radamanf 2011-10-12 13:22:22 UTC 
Created attachment 527697 [details]
Screenshot
Comment 2 Remi Collet 2011-12-19 15:51:12 UTC 
Please try latest version as Version 5.2.36 is now available in the updates

https://admin.fedoraproject.org/updates/FEDORA-2011-16997/mysql-workbench-5.2.36-1.fc15

If you MySQL database is upgraded from an earlier version, have you run the mysql_upĝrade script ? (check /var/lib/mysql/mysql_upgrade_info content)
Comment 3 Radamanf 2011-12-22 12:04:40 UTC 
STATUS URGENT!!!

NEW version is even worse !!! ver 5.2.36 rev 8542 (on Fedora15)

Now I cannot even manually refresh tables for them to be shown, now I cannot see tables at all!!!!!!!!!!!!!!!!!!!!

I've created new table in my existing DB it appeared, then I've done refresh at new table disappeared as with the rest!!!!!

Replicate bug

Create at least 13 Databases with about 25 tables in each, each should hold lots of data about 1Gb for 5 of DB will be enough.



How I can downgrade it?????

It's working if I have 1 DB as on my server, but on local PC I need to have all databases in one and it's now impossible to read table list on them, shame...
Comment 4 Remi Collet 2011-12-22 15:39:35 UTC 
Please answer my question in Comment 2.
Comment 5 Radamanf 2012-01-05 12:28:17 UTC 
No I haven't upgraded my DB and /var/lib/mysql/mysql_upgrade_info file not exist
Comment 6 Radamanf 2012-01-05 16:11:30 UTC 
Thank you it's working, sorry I should try to execute script to update DB, now it's 5.5.18

> sudo mysql_upgrade

I've done upgrade on Databases and now they are working again, but this should be done somehow obvious way, or you will get lot's of bugs like this :(