Bug #61660 error during the 'Synchronize Model'-process
Submitted: 27 Jun 2011 18:44 Modified: 8 Aug 2011 17:23
Reporter: Adam Bomba Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S3 (Non-critical)
Version:5.2.34 OS:Windows (XP)
Assigned to: CPU Architecture:Any
Tags: synchronize model

[27 Jun 2011 18:44] Adam Bomba 
Description:
I go within my model to Database > Synchronize Model ... than in the step after retrieving Object Information the program stops with an "unexpected error". The synchronize-process stops here.
In the retrieving step (the 4th step) the log shows OK.

How to repeat:
I hope in the same way.
[27 Jun 2011 20:30] MySQL Verification Team 
Could you please try version 5.2.34. Thanks.
[28 Jun 2011 17:50] Adam Bomba 
Hallo,

I found the reason:
it was because of a corrupt foreign key in one of my table, which causes a memory error.
After deleting this foreign key, the synchronizing process finished without errors.
"Message: Removed corrupt column defi"
[28 Jun 2011 18:30] Alfredo Kojima 
Do you still have a copy of such corrupt model? Could you upload it to this bug report so we can address the crash?
[5 Jul 2011 21:34] Adam Bomba 
Ok, I installed the newest version.
Now the error message changed in "MySQL Workbench detected a problem and must be shut down."
I send you the model and a screenshot from this message.
[5 Jul 2011 21:34] Adam Bomba 
error message box

Attachment: screenshot.jpg (image/jpeg, text), 92.58 KiB.
[5 Jul 2011 21:35] Adam Bomba 
the model file

Attachment: Model_Produktverwaltung.mwb (application/octet-stream, text), 20.82 KiB.
[6 Jul 2011 6:48] Valeriy Kravchuk 
With your .mwb on Mac I've just got error in the process:

Executing SQL script in server
ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL DEFAULT NULL ,
  `idDVB` INT(11) NULL DEFAULT NULL ,
  `idVidKodierung` I' at line 7

but no crash of any kind.
[6 Jul 2011 12:44] MySQL Verification Team 
On Windows I got the same error as well:

Executing SQL script in server

ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') NULL DEFAULT NULL ,

  `idDVB` INT(11) NULL DEFAULT NULL ,

  `idVidKodierung` I' at line 7
[8 Aug 2011 23:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".