Bug #61945 | Synchronize Model feature has many bugs | ||
---|---|---|---|
Submitted: | 21 Jul 2011 17:15 | Modified: | 1 Jun 2013 22:18 |
Reporter: | Greg Ellis | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Workbench: Modeling | Severity: | S2 (Serious) |
Version: | v5.2.34 CE Revision 7780 | OS: | Windows (7 - 64 bit) |
Assigned to: | CPU Architecture: | Any |
[21 Jul 2011 17:15]
Greg Ellis
[21 Jul 2011 17:35]
Valeriy Kravchuk
Please, send the output of: select version(); from your MySQL server.
[21 Jul 2011 17:38]
Greg Ellis
Output for select version() of MySQL server is 5.5.8 and I get the same results on my other MySQL server which is 5.5.11 Thanks, Greg
[21 Jul 2011 17:41]
MySQL Verification Team
Could you please provide the model file (private if you wish). Thanks.
[21 Jul 2011 17:41]
Greg Ellis
One more thing. My shared hosting server is using MySQL 5.0.92-community Using my shared hosting server the synch doesn't stall at "Fetch Object Info", but the problem regarding the sync trying to recreate views, dropping them, and such still occurs.
[21 Jul 2011 17:44]
Greg Ellis
If I select "Only developers will be able to see the file" will that be private? I want to make sure no one else gets my database :)
[21 Jul 2011 19:20]
MySQL Verification Team
I couldn't repeat below the log: Executing SQL script in server SQL script execution finished: statements: 560 succeeded, 0 failed
[21 Jul 2011 19:22]
MySQL Verification Team
Yes regarding your question, only developers will see your database.
[21 Jul 2011 20:00]
Greg Ellis
Forward engineer works fine, but it is if you select "Database" then "Synchronize Model..." and go through the steps where I have problems. Were you able to do that with proper expected results? Thanks
[21 Jul 2011 21:19]
MySQL Verification Team
Synchronization
Attachment: siynchronization.png (image/png, text), 193.73 KiB.
[21 Jul 2011 21:20]
MySQL Verification Team
See prior attached picture. Thanks.
[21 Jul 2011 22:23]
Greg Ellis
what I see #1
Attachment: Untitled-1.jpg (image/jpeg, text), 455.26 KiB.
[21 Jul 2011 22:23]
Greg Ellis
what I see #2 (dropping view)
Attachment: Untitled-2.jpg (image/jpeg, text), 487.03 KiB.
[21 Jul 2011 22:24]
Greg Ellis
list of changes that workbench wants to make
Attachment: changes it wants to make.sql (application/octet-stream, text), 31.14 KiB.
[21 Jul 2011 22:27]
Greg Ellis
As you will see from the attached screenshots and sql change file, Workbench thinks that there have been changes to views and tables in on my database server , but, the tables and views are identical between my server and the model. I can't understand how this could be happening. Do you think it might be my mysql server configuration? I have tried uninstalling workbench and reinstalling and that didn't make any difference :( Thanks
[21 Jul 2011 23:02]
MySQL Verification Team
Thank you for the feedback. Indeed now running again I was able to get what are you reporting.
[12 Jul 2012 0:06]
David Dykstra
To add to this conversation, I have also found that when I make changes to the model, either changing the name of a table or adding a column to a table, the synchronization utility doesn't say there are any changes. Mac OS X 10.7.4
[16 Mar 2013 15:01]
James R
Has this even been addressed? I am seeing similar behavior in the latest version of Workbench where every time I synchronize the model, having made no changes, there is an index it always wants to alter. This is of concern mainly because I fear that Workbench is getting confused. The actual effect seems to be nothing. I suspect that the change already exists and so is ignored by the database, but I am concerned that a) this will not always be the case, and b) it junks up the synchornization SQL, making it harder to tell what is going on.
[11 Apr 2013 22:55]
Marc Ford
Any progress on this? I am using Workbench 5.2.47 on Mac and still have strange behaviors. 90% of my tables synch correctly. The others are a mix. A. Workbench says the DB needs to be updated with... ALTER TABLE `wb_incontrol_schema1`.`cc_build_files` CHANGE COLUMN `id_build_files` `id_build_files` INT(11) NULL DEFAULT NULL AUTO_INCREMENT ...but even after I run it manually. The next time I try to synchronize, it says I need it again. B. I have a new table in the schema. The source does not have it. The "Model and Database Differences" view shows no arrow. Even if I change it to force it to the source, no sql code is given, so I never get the table.
[1 Jun 2013 22:18]
Alfredo Kojima
The view synchrnization problem is because the server modifies the definition of the view when it's created. This is a duplicate of bug #65108