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: | |
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
[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.