Bug #67624 Synchronization Issues
Submitted: 17 Nov 2012 23:05 Modified: 28 Nov 2012 15:13
Reporter: Anthony Cirinelli Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.44 OS:Windows (Microsoft Windows 7 Home Premium Edition Service Pack 1 (build 7601), 64-bit)
Assigned to: CPU Architecture:Any
Tags: WBBugReporter

[17 Nov 2012 23:05] Anthony Cirinelli
Description:
Everytime I try to synchronize the workbench model with mysql, it drops all foreign keys and re-adds them. It also occassionally drops columns, and re-adds them, which erases data. This only started happening when I updated to 5.2.44.

----- Developer Notes -----

MySQL Workbench CE for Windows version 5.2.44  revision 9933
Configuration Directory: C:\Users\Anthony\AppData\Roaming\MySQL\Workbench
Data Directory: C:\Program Files (x86)\MySQL\MySQL Workbench 5.2 CE
Cairo Version: 1.8.8
OS: Microsoft Windows 7 Home Premium Edition Service Pack 1 (build 7601), 64-bit
CPU: 4x Intel(R) Core(TM)2 Quad CPU    Q6600  @ 2.40GHz, 6.0 GiB RAM
Active video adapter (0): NVIDIA GeForce GT 240
Installed video RAM: 1024 MB
Current video mode: 1920 x 1080 x 4294967296 colors
Used bit depth: 32
Driver version: 9.18.13.697
Installed display drivers: nvd3dumx.dll,nvwgf2umx.dll,nvwgf2umx.dll,nvd3dum,nvwgf2um,nvwgf2um
Current user language: English (United States)

How to repeat:
Create two tables, one with a primary key and the other with a corresponding foreign key, syncronize the model.
[19 Nov 2012 15:53] MySQL Verification Team
Duplicate of http://bugs.mysql.com/bug.php?id=67304 . Thanks.
[21 Nov 2012 23:47] Anthony Cirinelli
It appears that data is occasionally erased (from the delete and add of columns), and that scares me..
[28 Nov 2012 15:13] Anthony Cirinelli
I have the same version (5.2.44) installed on my laptop and this bug does not occur. I tried reinstalling on my desktop, but the error did not go away. I had upgraded the version on my laptop. The version on my desktop was a fresh install on a new copy of windows.