Bug #74147 empty grid result, incompatibiliity with libglib_2.42
Submitted: 30 Sep 2014 3:43 Modified: 27 Jan 2015 16:01
Reporter: Dmitry Smirnov Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S2 (Serious)
Version:6.2.4 OS:Linux (Debian)
Assigned to: CPU Architecture:Any

[30 Sep 2014 3:43] Dmitry Smirnov
Description:
Just reported in Debian "Jessie":

    https://bugs.debian.org/cgi-bin/bugreport.cgi?bug=763356

Simple query like "SELECT * FROM" (e.g. "Select Rows - Limit 1000") reports "Query completed" but no result appears in result grid.
This is a regression introduced with one of the dependency libraries update -- Mysql Workbench 6.1.7 was working some time ago. Unfortunately I can't pinpoint the problem more precisely. During query the following is logged to console:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

How to repeat:
"Select Rows - Limit 1000" on any table in Debian "testing".
[30 Sep 2014 12:04] MySQL Verification Team
Thank you for the bug report. Please try version 6.2.3. Thanks.
[30 Sep 2014 23:10] Dmitry Smirnov
Thanks, Miguel, same thing in 6.2.3 but less noise on the console:

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

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

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

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

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

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

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

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

(mysql-workbench-bin:19062): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
~~~~
[1 Oct 2014 13:36] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=74163 marked as duplicate of this one.
[2 Oct 2014 1:17] Dmitry Smirnov
It's been reported that downgrading libglib2.0.0 from 2.42.01 to 2.40.0 solves this problem.
[6 Oct 2014 23:55] Dmitry Smirnov
Any update on this please? Incompatibility with libglib 2.42 is a major pain with the only option to downgrade the latter to version 2.40 in order to fix MySQL Workbench which is not usable otherwise.
Alfredo, maybe you have some ideas?
Thanks.
[8 Oct 2014 12:29] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=74261 marked as duplicate of this one.
[8 Oct 2014 14:33] Alfredo Kojima
Hi Dmitry, thanks for reporting. So once again glib makes backwards incompatible changes... We'll try to repeat that here and see if we can come up with a patch.
[15 Oct 2014 23:19] jon k
Any update on this issue?
[16 Oct 2014 12:11] Marcin Szalowicz
glib fix

Attachment: glib.diff (text/x-patch), 1.63 KiB.

[16 Oct 2014 12:30] Dmitry Smirnov
Thanks very much, Marcin -- your patch fixes the issue for me.
[16 Oct 2014 13:21] Niklas Larsson
+1 patch fixed issue for me as well (running glib 2.42.0-1)
[16 Oct 2014 19:04] jon k
works good here as well - thanks a lot!
[23 Oct 2014 10:11] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=74519 marked as duplicate of this one.
[23 Oct 2014 10:30] MySQL Verification Team
bugs.mysql.com/bug.php?id=74115 duplicate of this one.
[23 Oct 2014 23:04] Victor Hugo Quiroz Castro
So how do I use this fix? :)
[25 Oct 2014 15:35] Pavel Vorobiov
I can't find on my Ubuntu 14.10 file listmodel_wrapper.cpp

How can I use this patch?
[3 Nov 2014 10:37] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=74669 marked as duplicate of this one.
[6 Nov 2014 14:17] Edgar Hipp
@Victor Hugo Quiroz Castro 

* Download source from : http://dev.mysql.com/downloads/workbench/

* untar the source, `cd frontend` and do `git apply glib.diff`
[9 Nov 2014 0:45] Kieu Minh Canh
@ Edgar Hipp
I installed Workbench 6.3 on Opensuse 13.2 (before, When i installed on Opensuse 13.1 then worked) 
MySQL Workbench have same problem, Result Grid do not display.

Could you help me, how can i fix it.
Thanks.
[10 Nov 2014 10:04] MySQL Verification Team
bugs.mysql.com/bug.php?id=74760 marked as duplicate of this one.
[13 Nov 2014 21:55] Philip Olson
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.

Thank you for the bug report.
[20 Nov 2014 21:14] Ricardo Almeida
I have just installed MySQL Workbench 6.2.4 release on Ubuntu 14.10

The issue remains the same. Very disappointing
[21 Nov 2014 9:33] Oleg Kalnichevski
The problem still persists with Ubuntu 14.10 and MySQL Workbench 6.2.4. Please consider re-opening the issue.
[21 Nov 2014 10:45] Pavel Vorobiov
I confirm that on ubuntu 14.10 this bug is still is.
[21 Nov 2014 21:13] Philip Olson
Confirmed and reopened.
[22 Nov 2014 13:17] MySQL Verification Team
So back to verified status.
[26 Nov 2014 14:00] Adrian Wilkins
Confirm that this doesn't work on 14.10 / Oracle deb repo build 

6.2.4.12437 build 2426 (64 bits)

libglib2.0-0 is unchanged since October (2.42.0-2)

Downloaded the source archive and confirmed that the patch as described in this ticket has been applied .. did the submitter have any other changes in his tree that may have been applicable?
[26 Nov 2014 15:17] Marcin Szalowicz
The situation right now is because of the way the patch works, packages for Ubuntu 14.04 with 6.2.4 will not have this fixed. As we do not ship 14.10 packages yet, users need to compile WB from the source.
Our packaging team is currently working, to get the 14.10 packages working.
[27 Nov 2014 8:06] David Seaward
FWIW the downstream package in the Ubuntu 14.10 repos (version 6.1.7) has been patched and is currently being tested. Results look positive.

https://bugs.launchpad.net/ubuntu/+source/mysql-workbench/+bug/1376154
[12 Dec 2014 6:25] Vishal Sahu
When can we expect a stable build which will work on ubuntu 14.10 ?
[24 Dec 2014 22:15] MySQL Verification Team
http://bugs.mysql.com/bug.php?id=75307 duplicate of this one.
[14 Jan 2015 7:43] Cyrille Giquello
http://bugs.mysql.com/bug.php?id=75499 is a duplicate of this bug
[16 Jan 2015 9:05] Cyrille Giquello
On Ubuntu 14.10 I'd try all version 6 available on http://dev.mysql.com/downloads/workbench and none works, all versions have an empty grid result after query.

A solution :

But with the Ubuntu software manager I'd installed mysql-workbench_6.1.7+dfsg-1_amd64.deb and this one works. So I can go back to work now ;-)
[16 Jan 2015 9:08] Cyrille Giquello
I forgot to add Ubuntu's package information, here they are :

Package: mysql-workbench
Priority: optional
Section: universe/database
Installed-Size: 81070
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Original-Maintainer: Dmitry Smirnov <onlyjob@debian.org>
Architecture: amd64
Version: 6.1.7+dfsg-1
Depends: libatkmm-1.6-1 (>= 2.22.1), libc6 (>= 2.14), libcairo2 (>= 1.13.0~20140204), libctemplate2, libgcc1 (>= 1:4.1.1), libgdk-pixbuf2.0-0 (>= 2.22.0), libgl1-mesa-glx | libgl1, libglib2.0-0 (>= 2.35.9), libglibmm-2.4-1c2a (>= 2.40.0), libgnome-keyring0 (>= 2.22.2), libgtk2.0-0 (>= 2.24.0), libgtkmm-2.4-1c2a (>= 1:2.24.0), liblua5.1-0, libmysqlclient18 (>= 5.5.24+dfsg-1), libmysqlcppconn7 (>= 1.1.3), libodbc1 (>= 2.3.1), libpango-1.0-0 (>= 1.18.0), libpangocairo-1.0-0 (>= 1.14.0), libpangomm-1.4-1 (>= 2.27.1), libpcre3, libpcrecpp0 (>= 7.7), libpython2.7 (>= 2.7), libsigc++-2.0-0c2a (>= 2.2.0), libstdc++6 (>= 4.6), libtinyxml2.6.2, libuuid1 (>= 2.16), libvsqlitepp3 (>= 0.3.13), libx11-6, libxml2 (>= 2.7.4), libzip2 (>= 0.10), python:any (>= 2.6.6-7~), python2.7, mysql-workbench-data (= 6.1.7+dfsg-1), virtual-mysql-client, python-mysql.connector, python-paramiko, python-pexpect, python-pyodbc (>= 2.1.8), python-pysqlite2
Recommends: ttf-bitstream-vera, mysql-utilities
Suggests: gnome-keyring
Filename: pool/universe/m/mysql-workbench/mysql-workbench_6.1.7+dfsg-1_amd64.deb
Size: 8529740
MD5sum: b41fc163ead043748b18b866dffc2c73
SHA1: 02560cad44b2a2b4792c1084e957973fe1936333
SHA256: f5763ee9c16b75d14b5e3681c1bfa9ada9a846e6972ba912da30642160610ca9
Description-fr: MySQL Workbench - un outil de modélisation, d'administration et de files d'attente visuelle de base de données
 MySQL Workbench est un outil de modélisation qui permet de concevoir et de
 générer des bases de données MySQL graphiquement. Il a également des
 modules de développement d'administration et de requête où vous pouvez
 gérer les instances du serveur MySQL et exécuter des requêtes SQL.
Description-md5: b0f9e6da09ec27a9290e32ae9a69dcf0
Homepage: http://dev.mysql.com/workbench/
Bugs: https://bugs.launchpad.net/ubuntu/+filebug
Origin: Ubuntu
[27 Jan 2015 16:01] Mike Lischke
This is issue is fixed in our code repository. However, currently you have to build Ubuntu 14.10 binaries yourself from source code. We currently do not ship such binaries (only for 14.04), but will start delivering them with the next bug fix release.
[28 Feb 2015 17:25] Erik Johnson
On Fedora 21 this no longer works.  I've tried 6.0.9 then 6.1.7 and then 6.2.4
I get a blank query window
[28 Feb 2015 17:27] Erik Johnson
And my console output:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

(mysql-workbench-bin:29706): Gtk-CRITICAL **: IA__gtk_tree_view_set_model: assertion 'model == NULL || GTK_IS_TREE_MODEL (model)' failed
[3 Mar 2015 19:50] Erik Johnson
With 6.2.5 now out, the issue is gone.  The grids work as before.
[20 Dec 2015 10:38] Muraleedhar Ramapai
The bug is back after centos 7.2 upgrade.
3.10.0-327.3.1.el7.x86_64 #1 SMP Wed Dec 9 14:09:15 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
[28 Dec 2015 1:14] mariano Fernandez
The bug is back in centos 7 4.3.3-1.el7.elrepo.x86_64
[30 Dec 2015 17:50] Oleg Tarassov
Bug is back up on Red Hat Enterprise Linux Server release 7.2 (Maipo)
3.10.0-327.3.1.el7.x86_64

Thanks,

Oleg
[2 Jan 2016 11:46] Seth Friedman
I also confirm same in Centos 7 4.3.3-1.el7.elrepo.x86_64.
[6 Jan 2016 18:44] Maxime Chevailliot
Hello,
I also confirm same in Centos release 7.2.1511 (kernel : 3.10.0-327.3.1.el7.x86_64)
The bug is also existing with mysqlworkbench6.3.*.
thanks in advance.
[12 Feb 2016 10:17] Marcin Szalowicz
Hello Muraleedhar, Mariano, Oleg, Seth, Maxime, 

thank you for the feedback. 
This bug was fixed and new packages are available. 
Please find more information in the comments of this bug #79495
[12 Feb 2016 10:44] Maxime Chevailliot
Hello,
I confirm the fix.
mysql-workbench-community-6.3.6-2 is ok on CentOS 7.2.1511 
Many thanks !
[21 Sep 2017 2:20] Matheus Azevedo
version 6.2.5 has the same bug on CentOS 7.4.1708
[3 Oct 2017 9:46] Vladimir Usychenko
Same issue on Mac OS High sierra, v. 6.3.9