MySQL Bugs: #59007: Model synchronization fails

Bug #59007	Model synchronization fails
Submitted:	17 Dec 2010 19:22	Modified:	3 Jan 2011 7:53
Reporter:	Ondrej Dvoracek	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S1 (Critical)
Version:	5.2.31 CE	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
When we try to synchronize database model to real database, everything works fine until the step you should choose changes to apply. During prepering list of changes the app fails.
We have database with about 400 tables and some triggers.
I tried to reinstall to new version, but it still does not work.
Can you tell me what to do? We use this feater very often and need it for our development.

How to repeat:
I can only tell you, that we have 400 tables, some triggers, and the synchronization always fails.

Hello Ondrej,
the best way to reproduce your problem would be to have a look on your modelfile - but I'm aware that you might not be allowed to do that. Although you can attach files to the report and mark them as "private" so only internal devs can see/access those.
Is there some error-dlg you see when it comes to the problematic  step? If a bug dialog is displayed, please right-click somwhere inside that dialog and select "copy stack to clipboard" and add that information here?
please also add the output of Workbenchs "Help"->"System Info" Command
Thanks in advance

Hello, thank you for your replay.
I am not allowed to post you the model file.
During the failure the app shows dialog that something happend and I should report a bug.
Stack trace you adviced me to is following:

Exception = System.AccessViolationException
Message = Došlo k pokusu o čtení nebo zápis v chráněné paměti. Zpravidla se jedná o indikaci, že došlo k poškození další paměti.
FullText = System.AccessViolationException: Došlo k pokusu o čtení nebo zápis v chráněné paměti. Zpravidla se jedná o indikaci, že došlo k poškození další paměti.
   v sigc.internal.signal_emit0<void,sigc::nil>.emit(signal_impl* impl)
   v sigc.signal0<void,sigc::nil>.emit(signal0<void\,sigc::nil>* )
   v mforms.Wizard.next_clicked(Wizard* )
   v MySQL.Forms.WizardImpl.nextClick(Object sender, EventArgs arguments)
   v System.Windows.Forms.Control.OnClick(EventArgs e)
   v System.Windows.Forms.Button.OnClick(EventArgs e)
   v System.Windows.Forms.Button.WndProc(Message& m)
   v System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
   v System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
   v System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

The text is in czech language and it says that the app tried to read/write from/to protected part of memory.

The system info you asked to is following:

MySQL Workbench CE for Windows version 5.2.31

Configuration Directory: C:\Users\Ondra\AppData\Roaming\MySQL\Workbench

Data Directory: C:\Program Files\MySQL\MySQL Workbench 5.2 CE

Cairo Version: 1.8.8

Rendering Mode: OpenGL is available on this system, so OpenGL is used for rendering.

OpenGL Driver Version: 2.1.2

OS: Microsoft Windows Vista Home Premium Edition Service Pack 2 (build 6002), 32-bit

CPU: 2x Intel(R) Core(TM)2 CPU         T5300  @ 1.73GHz, 2.0 GiB RAM

Active video adapter: NVIDIA GeForce Go 7400 

Installed video RAM: 128 MB

Current video mode: 1280 x 800 x 4294967296 colors

Used bit depth: 32

Driver version: 7.15.11.7991

Installed display drivers: nvd3dum.dll

Current user language: Čeština (Česká republika)

Thank you for your help,
OD.

Thank you for the feedback. Don't need to be the original project file but if you are able to create one test case which allows to repeat the issue would be nice. Thanks in advance.

I'm afraid I'm not able to make any similar project, it's quite large and what's more, you would need a database I'm trying to synchronize the model with. When I tried to synchronize the model with older version of the database, everything worked, so there must be problem with some new changes, but every changes that were made to the database were only made by this synchronization. There were only added some tables, maybe some variable run out of memory.
I don't know now, I'll try some work around.
Thank you for your time.

I am changing the status for can't repeat if you are able to provide a way to be repeatable please reopen this bug report. Thanks in advance.

Hello, I finaly found out the reason:
it's because the unfinished foreign key, we were making some changes to the model and we forgot to change foreign keys, so there was a foreign key that had table selected, but not column.
Maybe it should drop any alert during synchronization or shouldn't allow to create such foreign keys.