I am running Ubuntu 14.10 and MySQL Workbench v6.2.3-1ubu1404-amd64 (it`s last stable) and I am having issue with columns not displaying correctly (completely) - just blank space instead.
Is anybody experiencing the same problem? How to solve this?
Also experiencing issue in opensuse 13.2. It worked in opensuse 13.1.
I can confirm the behavior you are seeing. It doesn't work on Ubuntu 14.10 and works On Ubuntu 14.04. I use mysql-workbench on Debian Wheezy with the expected behavior. So your question caught my attention because it appeared to be a bug.
I ran it from the command line to see what was on the console. When using the EER Diagram Editor with a sample model I was greeted with a blank pane where columns and their attributes should be listed. The console shows these unexpected assertions:
(mysql-workbench-bin:52041): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_16ListModelWrapper) after class_init
(mysql-workbench-bin:52041): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_16ListModelWrapper) after class_init
(mysql-workbench-bin:52041): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
There were far more errors but I have cut the list short. These assertions suggest to me that there is a bug while creating the window pane where the column data. It isn't just the column data where this happens but on a majority of the panes at the bottom.
I work on an open source project that also had issues with Ubuntu 14.10 and it also involved Glib assertions appearing where they didn't occur before. The Glib developers have begun adding more assertions to their code to identify software bugs. It is possible that something similar applies here. In the case of the project I maintain the assertions were indicative of a problem in our project code and the newer versions of Glib made our code fail.
With that in mind I looked on the Ubuntu launchpad site. There is this bug report with the title Workbench not showing tables or query results in raring that was opened last year but people are now identifying the issue with 14.10 as well (many in the past week). I believe it is related to what you are seeing. I also observed there are nearly 3 dozen people at this time that have reported a problem. You could create an account and add yourself to the list of people experiencing a problem.
There is good news and bad news. The MySQL workbench developers have identified and fixed the problem in their latest builds. The MySQL bug report link has this to say:
Posted by developer:
Fixed as of the upcoming MySQL Workbench 6.2.4 release, and here's the changelog entry:
On Linux, the query result view did not populate with libglib version 2.42 and above.
Unfortunately Ubuntu doesn't have a patch or work around in their official repositories yet. I think you have a few options:
This is a known problem on Ubuntu 14.10 (there's a behavior change in glib). This bug has been fixed and the fix will be available in the next release. You can see this also in resultsets (blank results, even though a table has records).
To solve this, follow the below steps :
1. On the left hand side select "Table Tool".
2. Click the canvas, which creates a default table.
3. Select the table, right click it and select "Edit".
4. Select the "Columns" tab on the bottom.
5. Double click the "column name" text box and enter a column name.
6. Click "Apply Changes".. You should see the column in the table now.
Sometimes it happens to me also and i just double click another table and when i double click back the table with the problem the columns are displayed.
If after re-installing the packages you have the same problem, try removing the table figure from the diagram and drag it back again from the catalog tree. Not sure if it helps at all...
