Bug #60222 workbench crashes when trying to synchronize
Submitted: 23 Feb 2011 13:36 Modified: 13 Feb 2012 18:23
Reporter: Phellipe Kelbert Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.31 OS:Linux (Ubuntu 10.04)
Assigned to: CPU Architecture:Any
Tags: crashing, synchronization, ubuntu, workbench

[23 Feb 2011 13:36] Phellipe Kelbert
Description:
i have a model and when i try to synchronize it the application just crashes.

investigation the problem, i executed it through this prompt command:
> mysql-workbench 1> mysql-wb.log 2> mysql-wb.log

the log file is attached due to it's size.

How to repeat:
it's just open the attached model file and try to synchronize it.
[23 Feb 2011 13:37] Phellipe Kelbert
log file

Attachment: mysql-wb.log (text/x-log), 56.48 KiB.

[23 Feb 2011 13:39] Phellipe Kelbert
model xml file (compressed)

Attachment: model.tar.gz (application/x-gzip, text), 29.99 KiB.

[23 Feb 2011 13:45] Valeriy Kravchuk
Please, check if the same crash happens with a newer version, 5.2.31.
[23 Feb 2011 17:26] Phellipe Kelbert
sorry, my ubuntu version actually is 10.04, not 10.10

workbench 5.2.31 is not available to version 10.04
[23 Feb 2011 18:28] Valeriy Kravchuk
I am sure it is available from dev.mysql.com. See http://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-gpl-5.2.31a-2ubu1004-i386... for example. 

I am also sure it is available as I have it installed on 32-but Ubuntu 10.04. Please, check.
[23 Feb 2011 19:12] Phellipe Kelbert
"available" meaning "downloadable" it really is. meaning "fully supported by ubuntu 10.04 by default" it's not. but i guess it's not your fault.

wb 5.2.31 requires the package libgdk-pixbuf2.0-0, which is available only at ubuntu 10.10 (maverick) repository. when i try to install wb's newer version ubuntu stops cause of the broken dependency.

i'll try to install that gdk library but if you guys have some tip, please tell me.

thanks in advance.
[23 Feb 2011 19:38] Phellipe Kelbert
i really believed i was working with ubuntu 10.10 not only when i created the bug report but even when i downloaded the wrong wb installer! my apologies for the noob fail.

now i have version 5.2.31 working and the crashes still happens. i've updated the "version" field at bug's description.
[24 Feb 2011 0:00] MySQL Verification Team
I couldn't repeat on Fedora 14 X86_64.
[24 Feb 2011 14:19] Phellipe Kelbert
@Miguel Solorzano 

with the same model file attached?
[24 Feb 2011 15:52] Valeriy Kravchuk
When I tried to synchronize your model with local MySQL 5.1.41 server (those coming with Ubuntu), I've got one error:

Executing SQL script in server
ERROR: Error 1005: Can't create table 'sisppg.bolsa_historico_situacao_bolsa' (errno: 121)

CREATE  TABLE IF NOT EXISTS `sisppg`.`bolsa_historico_situacao_bolsa` (
  `bolsa_historico_situacao_bolsa_id` INT(11) NOT NULL AUTO_INCREMENT ,
  `bolsa_bolsa_id` INT(11) NOT NULL ,
  `bolsa_situacao_bolsa_id` INT(11) NOT NULL ,
  `bolsa_motivo_finalizacao_id` INT(11) NULL DEFAULT NULL ,
  `data_atualizacao` TIMESTAMP NOT NULL ,
  `usuario_atualizacao` VARCHAR(20) NOT NULL ,
  PRIMARY KEY (`bolsa_historico_situacao_bolsa_id`) ,
  INDEX `fk_bolsa_bolsa_id` (`bolsa_bolsa_id` ASC) ,
  INDEX `fk_bolsa_situacao_bolsa_id` (`bolsa_situacao_bolsa_id` ASC) ,
  INDEX `fk_bolsa_motivo_finalizacao_id` (`bolsa_motivo_finalizacao_id` ASC) ,
  CONSTRAINT `fk_bolsa_bolsa_id`
    FOREIGN KEY (`bolsa_bolsa_id` )
    REFERENCES `sisppg`.`bolsa_bolsa` (`bolsa_bolsa_id` )
    ON DELETE RESTRICT
    ON UPDATE CASCADE,
  CONSTRAINT `fk_bolsa_situacao_bolsa_id`
    FOREIGN KEY (`bolsa_situacao_bolsa_id` )
    REFERENCES `sisppg`.`bolsa_situacao_bolsa` (`bolsa_situacao_bolsa_id` )
    ON DELETE RESTRICT
    ON UPDATE CASCADE,
  CONSTRAINT `fk_bolsa_motivo_finalizacao_id`
    FOREIGN KEY (`bolsa_motivo_finalizacao_id` )
    REFERENCES `sisppg`.`bolsa_motivo_finalizacao` (`bolsa_motivo_finalizacao_id` )
    ON DELETE RESTRICT
    ON UPDATE CASCADE)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1
COLLATE = latin1_swedish_ci

SQL script execution finished: statements: 16 succeeded, 1 failed

but no crash. So, the question is: what version of server are you trying to work with?
[24 Feb 2011 18:53] Phellipe Kelbert
@Valeriy Kravchuk

mysql server 5.0.32 running on debian 3.1
[24 Feb 2011 18:56] Phellipe Kelbert
the crash also happens on windows xp with:
 - service pack 3
 - .net framework 3.5
 - workbench 5.2.31

same mysql server used by ubuntu client.
[28 Feb 2011 12:30] MySQL Verification Team
Yes with the same file attached.
[15 Mar 2011 9:45] Valeriy Kravchuk
Can you try to upgrade your MySQL server? I had not got any crash (just the same error with one table as I reported before) with WB 5.2.33 when working with MySQL server 5.0.91.
[15 Mar 2011 10:28] Phellipe Kelbert
@Valeriy Kravchuk 

i tried to sync the model with a different server and this time i got no error.

the different server was running mysql server 5.1.49 over ubuntu server 10.10 x64

this way, i suppose the reported error doesn't belong exclusively to workbench but to the mix workbench + old mysql server.
[16 Mar 2011 0:43] MySQL Verification Team
Did you try with 5.2.33 how requested?. Thanks in advance.
[16 Mar 2011 11:30] Phellipe Kelbert
wb updated to 5.2.33 and the crash doesn't happen anymore. ran against server with mysql 5.0.32 on debian 3.1 -- the original one.

it worths to note that the database's content has changed since the first crash occurence.
[20 Mar 2011 18:53] Valeriy Kravchuk
So, let's assume the problem is no longer repeatable with 5.2.33. Please, re-open this bug report if you'll ever see similar crash again.