MySQL Bugs: #67113: Synchronize with any datasource

Bug #67113	Synchronize with any datasource
Submitted:	6 Oct 2012 13:37	Modified:	12 Dec 2012 7:57
Reporter:	Christian Jacobs	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench: Administration	Severity:	S3 (Non-critical)
Version:	5.2.44	OS:	Windows (Microsoft Windows XP Professional Service Pack 3 (build 2600))
Assigned to:		CPU Architecture:	Any
Tags:	WBBugReporter

Description:
When you go thru the synchronize with any datasource, you come the point where you have to select which tables & stored procedures shall be updated.
It also shows the commands which have to be selected.
When you come to the next screen, it shows you the summary with the all necessary sql statements.

Issue: it just shows you the standard 3 lines at the beginning and at the end. The statements itself are not listed. The synchronization will not be completed.

How to repeat:
Go thru the process of sychronize with any datasource, select tabels / sp's for synchronization, check the summary sql statement (empty), execute it.
When you run the process again, you can see that the tables/ sp's are not synchronized.

Duplicate of http://bugs.mysql.com/bug.php?id=67111.

Hi Miguel,

I appreciate your quick response but ticket #67111 and #67113 are not the same.

Regarding #67111: I attached some screenshots to visualize it.
Eample:
First run: I use the pre-selected suggested connection for source (db01).
I change the connection for destination (db02).
Second run: The pre-selected suggested connection has changed to db02 but I haven't changed it.
=> It saves the last change but source and destination not independent.

Regarding #67113: Synchronize with any source doesn't execute the synchronization.
When I select one table pair to synchronize, it shows me the sql statement below.
When I'm going to the next screen it shows me just the following standard lines but not the sql statements.

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';

<<MISSING SQL STATEMENTS>>>

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

When I click on execute, it doesn't execute the synchronization.
You can proof it when you run the process again and the tables are not synchronized.

Thanks a lot for your report.
Can you please share with us a dump of the DBs that you use to reproduce this problem?
Also, can you please let us know the MySQL Server version and OS of the DB01 and DB02?
Thanks.

Hi,

Please find below the answers to your question:

db1 5.5.25-log SLES 11
db2 5.5.25-log SLES 11

regarding dump:
I can't give you a full dump but I attached an extract of a dump.

My guess:
I don't think it has something to do with the server.
When I select the tables for synchronization, it shows the correct sql-statement (if I copy it and execute it manually, it works) but it doesn't show up in the summary (all sql-statements for all tables to be synced). It seems it doesn't take over the statements. When I check the general-log on the server, I can see that it just executes the standard commands like SET @DEFAULT... but not the sql-statements for the tables.

I hope this helps!
Christian

bug being analyzing

Syncing.