msknapp
msknapp

Reputation: 1685

MySQL Workbench Closes Unexpectedly

I'm using CentOS 6.4, and did

sudo yum install mysql-workbench-community.x86_64

That installed MySQL workbench version 6.1

When I launch the application it lists MySQL Connections, and has a box for Local instance 3306.

When I double click that box the app just closes. WTH?


edit: it's printing this on the console

/usr/libexec/mysql-workbench/mysql-workbench-bin: symbol lookup error: /usr/lib64/mysql-workbench/libwbscintilla.so: undefined symbol: gtk_widget_get_realized

Upvotes: 4

Views: 15651

Answers (8)

Runsis
Runsis

Reputation: 847

What worked for me were very simple steps:

  1. Downloaded a previous version of MySQL Workbench just in case

  2. If it still shuts down when opening the app then verify that there is no app using mysql (for example a website you are building or whatever project you are working on) Stop them all

  3. Do not open the workbench and stop the mysql server in the command line:

    sudo service mysql stop

  4. Now with mysql stopped open MySQL Workbench and open any connection

  5. Once inside, MySQL should obviously not be running so now:

    sudo service mysql start

Voila!

Upvotes: 0

Ganesh Chandrasekaran
Ganesh Chandrasekaran

Reputation: 1936

As plan B you can also use dbeaver. It works on all OS.

https://dbeaver.io/download/

Upvotes: 1

Bob Zhang
Bob Zhang

Reputation: 63

Centos6.8, Mysql80, Mysqlworkbench8.0.17 I have encountered same problem。 tried to install other version, but not worked; tried to install gtk2, not worked as well. Finally, I thought maybe the version was not correspond, so I install gtk3, it's worked.

Upvotes: 0

Jack Pts
Jack Pts

Reputation: 179

If you've got the same issue like me with Workbench unexpectedly crashing while opening previous session with tables then just clean up sql_workspaces folder with their sub-directories:

rm -rf ~/.mysql/workbench/sql_workspaces/*

Unfortunately I have the repetition of this event every time so I created the alias in my ~/.bashrc (pro-)file:

alias fix_workbench='rm -rf /home/user/.mysql/workbench/sql_workspaces/*'

P.S.: My MySQL Workbench's version is: 8.0.12. The debug log is too long, including Register/Memory dumps and Backtrace.

Upvotes: 1

Prasad
Prasad

Reputation: 1

Had same issue CentOS 6.4 : /usr/libexec/mysql-workbench/mysql-workbench-bin: symbol lookup error: /usr/lib64/mysql-workbench/libwbscintilla.so: undefined symbol: gtk_widget_get_realized

Installed gtk2 devel libraries. yum install gtk2-devel

Problem solved.

Thanks

Prasad

Upvotes: 0

Aryal Sumu
Aryal Sumu

Reputation: 53

I too was experiencing same problem (on CentOS 6.4). I followed what they concluded on this bug report file. I installed the Workbench 6.0.9 release and the problem is gone.

Upvotes: 1

Pingui
Pingui

Reputation: 1496

If you've got the same issue like me with Workbench unexpectedly crashing it's easy to resolve:

Edit -> Preferences -> tab "general" and check "Force use of software based rendering for EER diagrams"

At least it's worth a try!

Upvotes: 4

Mike Lischke
Mike Lischke

Reputation: 53307

You better read what platforms are supported by MySQL Workbench: http://www.mysql.com/support/supportedplatforms/workbench.html. The Linux world is so shattered, it's very difficult to support all flavours. And of course always my own is certainly one that should be amongst the supported platforms...

Upvotes: 0

Related Questions