Bug #79495 Empty result grid when doing a SELECT
Submitted: 2 Dec 2015 13:59 Modified: 26 Jan 2016 10:45
Reporter: Jonas Thoursie Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S1 (Critical)
Version:6.3.5/6.3.6 OS:Red Hat
Assigned to: CPU Architecture:Any
Tags: empty result, rhel, workbench

[2 Dec 2015 13:59] Jonas Thoursie
Description:
I'm running Red Hat Enterprise Linux Client. After the latest upgrade to RHEL Client 7.2 I am not able to use MySQL Workbench as my default query application on Linux. When doing a simple select, the Result Grid is empty, without any information on what's wrong. 

If I start mysql-workbench from the command line, I get the following output in the console when running my query: 

$ mysql-workbench 
Ready.

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_scroll_to_cell: assertion 'tree_view->priv->model != NULL' failed

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:4334): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

How to repeat:
* Install RHEL 7.2
* Install mysql-workbench: 
sudo rpm -i mysql-workbench-community-6.3.5-1.el7.x86_64.rpm
* Run a simple SQL query in MySQL Workbench
[15 Dec 2015 8:35] István Tóth
After upgrading my Centos Machine to 7.2, I have the same symptoms.
I guess that this is caused by the rebase to Gnome 3.14.3.
[16 Dec 2015 11:34] MySQL Verification Team
Thank you for the bug report. Verified with 6.3.6.

[miguel@miguelbr ~]$ cat /etc/oracle-release 
Oracle Linux Server release 7.2

miguel@miguelbr ~]$ mysql-workbench 
Ready.

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_scroll_to_cell: assertion 'tree_view->priv->model != NULL' failed

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:7494): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
[17 Dec 2015 16:34] JONAH LIBSTER
Folks, I"m running CentOS 7 and just did an update 2 days ago and I have the same problem. Here is the code from my terminal from which I ran it and did a query:

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_scroll_to_cell: assertion 'tree_view->priv->model != NULL' failed

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

(mysql-workbench-bin:8262): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

Hope this helps get this issue fixed. I may compile the code which I've read may fix this...but that was earlier so can't be sure. Anyway, I'll be checking for updates to this bug.
[18 Dec 2015 9:15] Edwin Vandamme
Also no grid results on CentOS 7.1 after a yum upgrade with Workbench 6.3.6-1.
Saving the results to a file does render the correct results.
There is also no output in the actions pane.

Log after starting Workbench
Dec 18 09:47:48 localhost mysql-workbench.desktop: Ready.

Log after connecting to a MySQL server
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
Dec 18 09:48:10 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed

Log after executing a query
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_scroll_to_cell: assertion 'tree_view->priv->model != NULL' failed
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeModel) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragDest) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): GLib-GObject-WARNING **: attempting to add an interface (GtkTreeDragSource) to class (gtkmm__CustomObject_13GridViewModel) after class_init
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
Dec 18 09:48:45 localhost mysql-workbench.desktop: (mysql-workbench-bin:6278): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
[18 Dec 2015 9:29] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=79696 marked as duplicate of this one.
[18 Dec 2015 14:34] Kåre Veland
I also run into the same error after upgrading CentOS two days ago.  Interesting to observe than on Fedora 23 (Workstation), this error does not occur.
[20 Dec 2015 10:45] Muraleedhar Ramapai
Same error for me too.
Post centos 7.2 upgrade.
[5 Jan 2016 14:33] Gosku Liano
Same problem for me with Centos 7.2, not grid after update.
[13 Jan 2016 16:53] Michael Ward
CentOS 7.2 here as well.  Our users have reported this issue and we've replicated it on several machines with varying hardware (i.e. it's not a graphical driver issue specific to AMD/Nvidia, etc.).  We would appreciate a resolution, as some of our users are very dependent upon MySQL Workbench.  Thanks in advance to the developers who are working to resolve this :)
[13 Jan 2016 21:30] Miklos Balazsi
RHEL7.2/Workbench 6.3.6 same issue.
[15 Jan 2016 1:14] Marce Gonzalez
Centos7.2/Workbench 6.3.6 same issue.
[19 Jan 2016 9:09] Tom Nguyen
The same issue here is for version 6.3.6 build 511 CE (64 bits) on CentOS Linux release 7.2.1511 (Core)
[20 Jan 2016 18:46] Guillaume Yapi
Fresh install of centos 7.2 (1511) and Having the same issue.
[26 Jan 2016 2:39] Philip Olson
Fixed as of the upcoming MySQL Fabric 1.6.3 release, and here's the changelog entry:

The results grid remained empty after executing SELECT queries. A new GTK2
prerequisite was added, which is checked by the Yum repository. This
affected Enterprise Linux variants, including the Oracle Linux and CentOS
distributions. 

 This fix was released (pushed) after version
6.3.6 was initially released. Current users of 6.3.6 must reinstall
Workbench.

Thank you for the bug report.
[26 Jan 2016 8:03] Mike Olson
Linux 7 Rel 2 (fresh install from web)
MySQL Workbench (fresh install from web)

Re-installed multiple times since last comment about fix was posted. Still having the problem.
[26 Jan 2016 10:03] Edwin Vandamme
I just installed mysql-workbench-community-6.3.6-2.el7.x86_64.rpm and at first glance everything seems to be fine.
[26 Jan 2016 10:45] Jonas Thoursie
mysql-workbench-community-6.3.6-2.el7.x86_64.rpm seems to solve the issue. 

Thank you for the fix!
[26 Jan 2016 13:48] Miklos Balazsi
After reinstalled mysql-workbench-community-6.3.6-2.el7.x86_64 working with out any issue. 
Thank you for the fix.
[26 Jan 2016 16:01] Mike Olson
New release fixed it. That file wasn't available last night.
[26 Jan 2016 16:09] Philip Olson
@Mike, I suspect you are attempting to update via a Linux distribution's packages, as opposed to packages provided by mysql.com. In this regard, mysql-workbench is often the name used by distributions, while mysql-workbench-community is the name used by mysql.com. For details on using the official Yum repository (this is recommended), see:

http://dev.mysql.com/downloads/repo/yum/

Or, download it directly:

http://dev.mysql.com/downloads/workbench/
[27 Jan 2016 10:38] Gianluca Elmo
Just tried on a fresh installation of CentOS 7.2 running in VirtualBox. Everything is now wroking again as expected.

Thanks a lot!
[27 Jan 2016 11:07] Roberto Costa
Also working just fine for me!
Yesterday, I updated to mysql-workbench-community-6.3.6-2.el7.x86_64 in CentOS 7, and it started showing result set data again.

How could I know who fixed that and what was modified in workbench code?
[6 Feb 2016 16:49] Mario Gulli
doesn't works on slackware current. No grid has shown.
[11 Feb 2016 11:08] Marcin Szalowicz
Hello Roberto, 
there wasn't any change in the code. The fix is already in the code, you can find it here: 
https://github.com/mysql/mysql-workbench/blob/master/frontend/linux/linux_utilities/listmo...
The solution was to recompile Workbench on that particular OL version as there was glib update. 

Mario, 
I'm afraid we do not support Slackware, yet to fix this, the only thing you need to do is to recompile Workbench on your machine.
[11 Feb 2016 11:17] Roberto Costa
Thanks Marcin Szalowicz!
[27 Feb 2016 13:12] Mario Gulli
Hi Marcin,
thank you for your help. I know that slackaware is not supported. I've compiled the source applying patch, but I've a different glib version (2.46). Could you please help me to solve the problem with this version?

Thanks a lot.

Mario