MySQL Bugs: #61876: Synchronize Database crashes workbench after schema change

Bug #61876	Synchronize Database crashes workbench after schema change
Submitted:	15 Jul 2011 9:35	Modified:	26 Mar 2012 7:20
Reporter:	Thomas Lamy	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S3 (Non-critical)
Version:	5.2.34-7780	OS:	Linux (Debian Squeeze x86)
Assigned to:		CPU Architecture:	Any
Tags:	workbench synchronize crash

Description:
Synchronize Database crashes WB very often after doing random changes to tables, columns or indexes.
It makes no difference if the model was saved before.
It works most of the time afterwards, if running on the (previously saved) model file.
I guess it's something in my model file, which unfortunately I cannot post publicly.

Backtraces:
http://pastebin.com/qsBjBqTJ
http://pastebin.com/DxpDdM2Y

How to repeat:
Sorry, no exact repetition available.
Make changes to the database schema, and run Synchronize Database from the Database menu.

Do you have any triggers defined in your model?

No triggers.

I'm not allowed to publish the mwb, but attached it privately. Otherwise I guess it would be impossible to fix just from the traces

Just for completeness, I use the Ubuntu binary from mysql-workbench-gpl-5.2.34-1ubu1004-i386.deb

I couldn't repeat on Ubuntu 11.04. I got only some error when doing the synchronize.

I also get only errors while forward engineering and then sinchronizing this model to MySQL server version 5.1.41 on 32-bit Ubuntu 10.04.

WB is crashing for me also, I am running Fedora 15.

1. Open Workbench
2. double click localhost (or some db) under "Open Connection to Start Querying"
3. In SQL Editor tab that opens, click Database->Reverse Engineer and produce an EER Diagram.
4. In EER Diagram choose Database->Synchronize with Any Source... (no changes need to be made)
5. On click, Workbench should crash.

Thanks a lot for your report.
Reproduced as stated by Jeremey Hustman.
Fedora 15x64 WB: 5.2.35 

Terminal output:

[armando@Fedora15x64 ~]$ mysql_workbench
bash: mysql_workbench: command not found...
[armando@Fedora15x64 ~]$ mysql-workbench
Warning! Can't use connect with timeout in paramiko 1.7.7.1 (George)
Log levels '0111000'
Ready.

** Message: query.explain built-in command is being overwritten
** Message: mforms::ListBoxImpl::set_heading('Objects to Process') not implemented
** Message: mforms::ListBoxImpl::set_heading('Excluded Objects') not implemented
** Message: mforms::ListBoxImpl::set_heading('Objects to Process') not implemented
** Message: mforms::ListBoxImpl::set_heading('Excluded Objects') not implemented
** Message: mforms::ListBoxImpl::set_heading('Objects to Process') not implemented
** Message: mforms::ListBoxImpl::set_heading('Excluded Objects') not implemented
** Message: mforms::ListBoxImpl::set_heading('Objects to Process') not implemented
** Message: mforms::ListBoxImpl::set_heading('Excluded Objects') not implemented

(mysql-workbench-bin:2161): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion `node != NULL' failed

(mysql-workbench-bin:2161): Gtk-CRITICAL **: IA__gtk_tree_model_iter_n_children: assertion `GTK_IS_TREE_MODEL (tree_model)' failed

(mysql-workbench-bin:2161): Gtk-CRITICAL **: IA__gtk_tree_model_iter_n_children: assertion `GTK_IS_TREE_MODEL (tree_model)' failed
** Message: mforms::ListBoxImpl::set_heading('Objects to Process') not implemented
** Message: mforms::ListBoxImpl::set_heading('Excluded Objects') not implemented
** Message: mforms::ListBoxImpl::set_heading('Objects to Process') not implemented
** Message: mforms::ListBoxImpl::set_heading('Excluded Objects') not implemented

(mysql-workbench-bin:2161): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion `node != NULL' failed

(mysql-workbench-bin:2161): Gtk-CRITICAL **: gtk_tree_view_unref_tree_helper: assertion `node != NULL' failed
/usr/bin/mysql-workbench-bin: symbol lookup error: /usr/lib64/mysql-workbench/plugins/db.mysql.wbp.so: undefined symbol: _Z23createWbPluginDiffAlterPN3grt6ModuleENS_3RefI10db_CatalogEE

Hi Thomas,
Does the issue still happen with version 5.2.39?

Sorry I meant 5.2.38

Fixed as of 5.2.39, and here's the changelog:

The following sequence would crash Workbench:
"Database", "Reverse Engineer"
to generate an EER diagram, then "Database",
"Synchronize with Any Source", and then a
mouse-click would cause the crash.

Can't check any longer, since I moved on to a new job and no longer have access to the project in question

Sorry
Thomas