Synch problem on MySQL 4.0.17

[frankbatrach]

Just downloaded the latest SJA 2.0 to synch our master and slave databases. The synch process seemed to run OK (on a totally synched source/target pair) so as a quick test I tried changing a single record on the local DB. Unfortunately, although SJA runs without error the new record is not added to the target DB.

Environment:

Local: RedHat 8.0/MySQL 4.0.17-standard-log

Remote: SunOS 5.9/MySQL 4.0.17-log

My XML file is:

localhost

-removed-

-removed- 3306

dw

mysql1.dca1.superb.net

-removed-

-removed- 3306

differentworld_com_1

favorite

The structure of the favorite table is:

Column Information For – dw.favorite

---

Field Type Null Key Default Extra Privileges

---

---

---

---

---

---

---

IDTable tinyint(1) unsigned PRI 144 select,insert,update,references

IDRegion tinyint(1) unsigned PRI 0 select,insert,update,references

IDCountry smallint(2) unsigned PRI 0 select,insert,update,references

IDOwner int(4) unsigned PRI 0 select,insert,update,references

IDObject int(4) unsigned PRI (NULL) auto_increment select,insert,update,references

Parent varchar(24) binary YES MUL (NULL) select,insert,update,references

Property varchar(24) binary YES (NULL) select,insert,update,references

Index Information For – dw.favorite

---

Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment

---

---

---

---

---

---

---

---

---

---

---

---

favorite 0 PRIMARY 1 IDTable A (NULL) (NULL) (NULL) BTREE

favorite 0 PRIMARY 2 IDRegion A (NULL) (NULL) (NULL) BTREE

favorite 0 PRIMARY 3 IDCountry A (NULL) (NULL) (NULL) BTREE

favorite 0 PRIMARY 4 IDOwner A (NULL) (NULL) (NULL) BTREE

favorite 0 PRIMARY 5 IDObject A 5 (NULL) (NULL) BTREE

favorite 1 Parent 1 Parent A (NULL) (NULL) (NULL) YES BTREE

The output from the SJA job is:

SQLyog Job Agent Version 2.0

Copyright © Webyog. All Rights Reserved.

Sync started at Fri May 28 23:56:02 2004

Warning : Source and Target MySQL versions are not matching.

Source : 4.0.17-standard-log, Target : 4.0.17-log.

SJA may not work properly because of the difference in behaviour of concat_ws() across multiple MySQL versions.

Table SrcRows TgtRows Inserted Updated Deleted

========================= ======= ======= ======== ======= =======

favorite 5 4 0 0 No change

favorite 4 5 0 0 No change

Total time taken – 1 sec(s)

So although it sees that the source and target tables are different it doesn't actually update them. Anyone have any idea what I'm doing wrong?

[Ritesh]

I believe you are using SJA for Linux. As I can see, you are doing a 2-way sync. SJA should work in this situation.

Can you send me a backup of the database so that I can run a sync at my place?

[Author]

Posts