Hide Forgot
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
Created attachment 527697 [details] Screenshot
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)
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...
Please answer my question in Comment 2.
No I haven't upgraded my DB and /var/lib/mysql/mysql_upgrade_info file not exist
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 :(