Bug #79515 Workbench closes the moment i try to connect
Submitted: 4 Dec 2015 4:47 Modified: 17 Dec 2015 16:29
Reporter: Supriyo Choudhury Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version: OS:Linux (RHEL 6)
Assigned to: CPU Architecture:Any

[4 Dec 2015 4:47] Supriyo Choudhury
Description:
I just installed mysql workbench and when i try to connect to the DB, it just get closed.

How to repeat:
Install Mysql workbench,launch workbench and try to connect to the DB,it just gets closed. But from the same if i try to use " Start Command Line" i do get it open the command line.

Install details 

Resolving Dependencies
--> Running transaction check
---> Package mysql-workbench-community.x86_64 0:6.3.5-1.el6 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

==================================================================================================================================================================================================
 Package                                                 Arch                                 Version                                   Repository                                           Size
==================================================================================================================================================================================================
Installing:
 mysql-workbench-community                               x86_64                               6.3.5-1.el6                               mysql-tools-community                                20 M

Transaction Summary
==================================================================================================================================================================================================
Install       1 Package(s)

Total download size: 20 M
Installed size: 118 M
Is this ok [y/N]: y
Downloading Packages:
mysql-workbench-community-6.3.5-1.el6.x86_64.rpm                                                                                                                           |  20 MB     00:13
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : mysql-workbench-community-6.3.5-1.el6.x86_64                                                                                                                                   1/1
  Verifying  : mysql-workbench-community-6.3.5-1.el6.x86_64                                                                                                                                   1/1

Installed:
  mysql-workbench-community.x86_64 0:6.3.5-1.el6

Complete!

[root@db01 ~]# locate mysql-workbench-bin
/usr/libexec/mysql-workbench/mysql-workbench-bin
[root@db01 ~]# ldd /usr/libexec/mysql-workbench/mysql-workbench-bin
        linux-vdso.so.1 =>  (0x00007fffecdfe000)
        libmforms.so.6.3.5 => not found
        liblinux_utilities.so.6.3.5 => not found
        libsqlide.so.6.3.5 => not found
        libwbprivate.so.6.3.5 => not found
        libwbpublic.so.6.3.5 => not found
        libwbbase.so.6.3.5 => not found
        libgrt.so.6.3.5 => not found
        libcdbc.so.6.3.5 => not found
        libwbscintilla.so => not found
        libmdcanvasgtk.so.6.3.5 => not found
        libmdcanvas.so.6.3.5 => not found
        libmysqlparser.so.6.3.5 => not found
        libmysqlcppconn.so.7 => not found
        libctemplate.so.3 => not found
        libSM.so.6 => /usr/lib64/libSM.so.6 (0x0000003a06600000)
        libICE.so.6 => /usr/lib64/libICE.so.6 (0x0000003a05e00000)
        libX11.so.6 => /usr/lib64/libX11.so.6 (0x00000039fd200000)
        libXext.so.6 => /usr/lib64/libXext.so.6 (0x00000039fde00000)
        libfreetype.so.6 => /usr/lib64/libfreetype.so.6 (0x00000039ff200000)
        libgtk-x11-2.0.so.0 => /usr/lib64/libgtk-x11-2.0.so.0 (0x0000003fb3e00000)
        libgdk-x11-2.0.so.0 => /usr/lib64/libgdk-x11-2.0.so.0 (0x0000003fb4a00000)
        libcairo.so.2 => /usr/lib64/libcairo.so.2 (0x0000003a01a00000)
        libpango-1.0.so.0 => /usr/lib64/libpango-1.0.so.0 (0x0000003fb2e00000)
        libpangocairo-1.0.so.0 => /usr/lib64/libpangocairo-1.0.so.0 (0x0000003fb4600000)
        libpangoft2-1.0.so.0 => /usr/lib64/libpangoft2-1.0.so.0 (0x0000003fb3600000)
        libpangoxft-1.0.so.0 => /usr/lib64/libpangoxft-1.0.so.0 (0x0000003fb2a00000)
        libgdk_pixbuf-2.0.so.0 => /usr/lib64/libgdk_pixbuf-2.0.so.0 (0x0000003fb3a00000)
        libgthread-2.0.so.0 => /lib64/libgthread-2.0.so.0 (0x0000003fb1e00000)
        libgmodule-2.0.so.0 => /lib64/libgmodule-2.0.so.0 (0x0000003fb2200000)
        libgio-2.0.so.0 => /lib64/libgio-2.0.so.0 (0x0000003fb2600000)
        libatk-1.0.so.0 => /usr/lib64/libatk-1.0.so.0 (0x0000003fb4e00000)
        libgobject-2.0.so.0 => /lib64/libgobject-2.0.so.0 (0x0000003fb1a00000)
        libglib-2.0.so.0 => /lib64/libglib-2.0.so.0 (0x0000003fb1600000)
        libgtkmm-2.4.so.1 => /usr/lib64/libgtkmm-2.4.so.1 (0x0000003fb9e00000)
        libgdkmm-2.4.so.1 => /usr/lib64/libgdkmm-2.4.so.1 (0x0000003fbae00000)
        libpangomm-1.4.so.1 => /usr/lib64/libpangomm-1.4.so.1 (0x0000003fb8e00000)
        libcairomm-1.0.so.1 => /usr/lib64/libcairomm-1.0.so.1 (0x0000003a0c200000)
        libgiomm-2.4.so.1 => /usr/lib64/libgiomm-2.4.so.1 (0x0000003fbb200000)
        libatkmm-1.6.so.1 => /usr/lib64/libatkmm-1.6.so.1 (0x0000003fba600000)
        libglibmm-2.4.so.1 => /usr/lib64/libglibmm-2.4.so.1 (0x0000003fbaa00000)
        libsigc-2.0.so.0 => /usr/lib64/libsigc-2.0.so.0 (0x0000003a0be00000)
        librt.so.1 => /lib64/librt.so.1 (0x00000039fa200000)
        libpython2.6.so.1.0 => /usr/lib64/libpython2.6.so.1.0 (0x0000003a06200000)
        libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x0000003a03600000)
        libpcre.so.0 => /lib64/libpcre.so.0 (0x0000003a0a200000)
        libpcrecpp.so.0 => /usr/lib64/libpcrecpp.so.0 (0x0000003a0da00000)
        libzip.so.1 => /usr/lib64/libzip.so.1 (0x00007f5878830000)
        libz.so.1 => /lib64/libz.so.1 (0x00000039faa00000)
        libmysqlclient.so.20 => not found
        libpthread.so.0 => /lib64/libpthread.so.0 (0x00000039f9a00000)
        libdl.so.2 => /lib64/libdl.so.2 (0x00000039f9e00000)
        libgnome-keyring.so.0 => /usr/lib64/libgnome-keyring.so.0 (0x0000003fb5600000)
        libtinyxml.so.0 => /usr/lib64/libtinyxml.so.0 (0x00007f5878618000)
        libuuid.so.1 => /lib64/libuuid.so.1 (0x0000003a04600000)
        libantlr3c_wb.so => not found
        libvsqlitepp.so.3 => not found
        libGLU.so.1 => /usr/lib64/libGLU.so.1 (0x00007f5878397000)
        libGL.so.1 => /usr/lib64/libGL.so.1 (0x0000003a06e00000)
        libgdal.so.1 => not found
        libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x0000003a05600000)
        libm.so.6 => /lib64/libm.so.6 (0x00000039fa600000)
        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x0000003a05200000)
        libc.so.6 => /lib64/libc.so.6 (0x00000039f9600000)
        libxcb.so.1 => /usr/lib64/libxcb.so.1 (0x00000039fd600000)
        libXfixes.so.3 => /usr/lib64/libXfixes.so.3 (0x00000039ffa00000)
        libfontconfig.so.1 => /usr/lib64/libfontconfig.so.1 (0x00000039fea00000)
        libXrender.so.1 => /usr/lib64/libXrender.so.1 (0x00000039ff600000)
        libXinerama.so.1 => /usr/lib64/libXinerama.so.1 (0x00000039ffe00000)
        libXi.so.6 => /usr/lib64/libXi.so.6 (0x00000039fee00000)
        libXrandr.so.2 => /usr/lib64/libXrandr.so.2 (0x0000003a00200000)
        libXcursor.so.1 => /usr/lib64/libXcursor.so.1 (0x0000003a02a00000)
        libXcomposite.so.1 => /usr/lib64/libXcomposite.so.1 (0x0000003a01e00000)
        libXdamage.so.1 => /usr/lib64/libXdamage.so.1 (0x0000003a02e00000)
        libpixman-1.so.0 => /usr/lib64/libpixman-1.so.0 (0x0000003a03200000)
        libpng12.so.0 => /usr/lib64/libpng12.so.0 (0x00000039fe600000)
        libXft.so.2 => /usr/lib64/libXft.so.2 (0x00007f587817b000)
        libresolv.so.2 => /lib64/libresolv.so.2 (0x00000039fb600000)
        libselinux.so.1 => /lib64/libselinux.so.1 (0x00000039fb200000)
        /lib64/ld-linux-x86-64.so.2 (0x00000039f9200000)
        libutil.so.1 => /lib64/libutil.so.1 (0x0000003a07a00000)
        libdbus-1.so.3 => /lib64/libdbus-1.so.3 (0x00000039fbe00000)
        libglapi.so.0 => /usr/lib64/libglapi.so.0 (0x0000003a06a00000)
        libX11-xcb.so.1 => /usr/lib64/libX11-xcb.so.1 (0x00007f5877f77000)
        libxcb-glx.so.0 => /usr/lib64/libxcb-glx.so.0 (0x0000003a07600000)
        libxcb-dri2.so.0 => /usr/lib64/libxcb-dri2.so.0 (0x0000003a07200000)
        libXxf86vm.so.1 => /usr/lib64/libXxf86vm.so.1 (0x0000003a05a00000)
        libdrm.so.2 => /usr/lib64/libdrm.so.2 (0x00000039fe200000)
        libXau.so.6 => /usr/lib64/libXau.so.6 (0x00000039fca00000)
        libexpat.so.1 => /lib64/libexpat.so.1 (0x00000039fda00000)
[root@db01 ~]#
[4 Dec 2015 8:29] MySQL Verification Team
Hello Supriyo,

Thank you for the report.
Could you please provide complete WB log? Please see https://dev.mysql.com/doc/workbench/en/workbench-reporting-bugs.html

Also, did you install dependencies? Please see http://dev.mysql.com/doc/workbench/en/wb-installing-linux.html

Thanks,
Umesh
[5 Dec 2015 0:24] Supriyo Choudhury
Hi Umesh.
I did the install using yum repo and it installed all dependencies before the install.

Also tried to use the instructions for the log and here is the outcome.

    In shell, execute source /usr/bin/mysql-workbench   --- The shell gets closed

    In shell, execute gdb /usr/bin/mysql-workbench-bin

    In the gdb interface, type run

    In MySQL Workbench, repeat the crash

    In the gdb interface, type bt 

OUTPUT:- [root@db01 ~]# gdb /usr/bin/mysql-workbench-bin
GNU gdb (GDB) Red Hat Enterprise Linux (7.2-60.el6_4.1)
Copyright (C) 2010 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.  Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu".
For bug reporting instructions, please see:
<http://www.gnu.org/software/gdb/bugs/>...
/usr/bin/mysql-workbench-bin: No such file or directory.
(gdb) run
Starting program:  
No executable file specified.
Use the "file" or "exec-file" command.
(gdb) bt
No stack.
(gdb) glxinfo
Undefined command: "glxinfo".  Try "help".
(gdb) 

Extract from the log file when i try to open the connection.

00:18:07 [INF][      WBContext]: Parsing application arguments.
00:18:07 [INF][      WBContext]:     /usr/libexec/mysql-workbench/mysql-workbench-bin
00:18:07 [INF][   WBContext UI]: Initializing workbench context UI with these values:
        base dir: /usr/share/mysql-workbench
        plugin path: /usr/lib64/mysql-workbench/plugins
        struct path: /usr/share/mysql-workbench/grt
        module path: /usr/lib64/mysql-workbench/modules
        library path: /usr/share/mysql-workbench/libraries
        user data dir: /root/.mysql/workbench
        open at start:
        open type:
        run at startup:
        run type:
        Force SW rendering: No
        Force OpenGL: No
        quit when done: No
00:18:07 [INF][      WBContext]: WbContext::init
00:18:07 [INF][            WBA]: Looking for extension modules for WBA...
00:18:07 [INF][            WBA]: 0 extension modules found
00:18:07 [WRN][            grt]: /usr/share/mysql-workbench/data/table_templates.xml:21: link 'com.mysql.rdbms.mysql.datatype.timestamp' <object db.SimpleDatatype> key=simpleType could not be resolved
00:18:07 [WRN][            grt]: /usr/share/mysql-workbench/data/table_templates.xml:106: link 'com.mysql.rdbms.mysql.datatype.varchar' <object db.SimpleDatatype> key=simpleType could not be resolved
00:18:07 [WRN][            grt]: /usr/share/mysql-workbench/data/table_templates.xml:229: link 'com.mysql.rdbms.mysql.datatype.int' <object db.SimpleDatatype> key=simpleType could not be resolved
00:18:07 [WRN][            grt]: /root/.mysql/workbench/connections.xml:25: link '8c22090e-9ae5-11e5-a399-005056a26fb8' <object GrtObject> key=owner could not be resolved
00:18:07 [INF][      WBContext]: System info:
        MySQL Workbench Community (GPL) for Linux/Unix version 6.3.5 CE build 201 (64 bit)
        Configuration Directory: /root/.mysql/workbench
        Data Directory: /usr/share/mysql-workbench
        Cairo Version: 1.8.8
        OS: Linux 3.8.13-16.2.1.el6uek.x86_64
        CPU: 16x Intel(R) Xeon(R) CPU E5-2690 v2 @ 3.00GHz (3000.000MHz) - 47.17GiB RAM
        Distribution: Oracle Linux Server release 6.5

        Fips mode enabled: no

00:18:07 [INF][    WQE backend]: Found auto-save workspace /root/.mysql/workbench/sql_workspaces/-2.autosave
00:18:07 [INF][    WQE backend]: Found auto-save workspace /root/.mysql/workbench/sql_workspaces/-1.autosave
00:18:07 [INF][    WQE backend]: Found auto-save workspace /root/.mysql/workbench/sql_workspaces/clarion-1.autosave
00:18:07 [INF][    WQE backend]: Found auto-save workspace /root/.mysql/workbench/sql_workspaces/Local_instance_3306-1.autosave
00:18:11 [INF][      SqlEditor]: Opened connection 'Local instance 3306' to MySQL Cluster Community Server (GPL) version 5.6.27-ndb-7.4.8-cluster-gpl
00:18:11 [INF][     AutoCCache]: Initializing autocompletion cache for Local_instance_3306

Regards
Supriyo
[8 Dec 2015 21:52] Supriyo Choudhury
Any updates please.
[17 Dec 2015 14:45] MySQL Verification Team
I couldn't repeat with release 6.3.6 on OL 7.2.
[17 Dec 2015 16:27] Supriyo Choudhury
we are using Oracle Linux Server release 6.5
[17 Dec 2015 16:29] Supriyo Choudhury
And the Workbench version "mysql-workbench-community-6.3.5-1.el6.x86_64"