Serius problem with SJA syncronization

[Anonymous]

hi i have a problem of synconization.

i've two server

A) SO Mandrake 10.1 – Mysql 4.0.20 istalled by mandrake RPM source (local server)

😎 SO Red Hat 9 – Mysql 3.23.58 (web server)

SJA version 4.0 istalled on server A

i need two sync.

1) Item table are updated in local server (A) and the web server must be syncronized.

for that i need one way sync.

2) order and custom tables are updated in local server and updated in web server so i need a two way sync.

for sync (1) i have the problem with one table… table articoli

i tried a one way sync and two way sync.

the item in source and target db are showed rightly and then the sync seems stalled…

i try to remove 'articoli' table on the xml conf.. and other tables seem work fine.

i try to repair / optimize / analyze / check table 'articoli' and the message are always 'ok'

i tied to truncate the table articoli from only one server…

the sync work fine without delay.. alla item are added… if i running another times the sja sync… i have the same problem… the item are showed and anyting else… i hane non error message and the sync don't go on.

for sync 2

i have a seagment fault when the sync arrive at table ordini_testa (head_order)

i have truncate the table and now seem work fine… but i don't know what happen when the number of record of this table will'be hight.

how can have a right sync?

can you help me?

i need as soon as possible a solution of that problem… for the moment i try to pach my need with a php script…

[Anonymous]

other problem…..

in my sync (1) the one way sync don't work fine….

i've start sync… (the db are had the same record) but for some table any record are deleted…

i've run aniway the sync… and… the sja insert the deleted record…. and at the same time it delete again that record…

Table SrcRows TgtRows Inserted Updated Deleted

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

articoli_categorie 29097 29097 0 0 0

articoli_consigliati 1052 1052 0 0 0

articoli_descrizioni 10380 10370 10 0 10

articoli_dettagli 7540 7540 0 0 0

categorie 361 361 0 0 0

categorie_associazioni 361 361 0 0 0

categorie_descrizioni 361 361 0 0 0

marche 601 601 0 0 0

varianti_descrizioni 138 137 1 0 1

variazioni 54080 54019 61 0 61

variazioni_descrizioni 46897 46893 4 0 4

so i tryed to do a two way sync… and that work fine..

Table SrcRows TgtRows Inserted Updated Deleted

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

articoli_categorie 29097 29097 0 0 No change

articoli_categorie 29097 29097 0 0 No change

articoli_consigliati 1052 1052 0 0 No change

articoli_consigliati 1052 1052 0 0 No change

articoli_descrizioni 10380 10370 10 0 No change

articoli_descrizioni 10380 10380 0 0 No change

articoli_dettagli 7540 7540 0 0 No change

articoli_dettagli 7540 7540 0 0 No change

categorie 361 361 0 0 No change

categorie 361 361 0 0 No change

categorie_associazioni 361 361 0 0 No change

categorie_associazioni 361 361 0 0 No change

categorie_descrizioni 361 361 0 0 No change

categorie_descrizioni 361 361 0 0 No change

marche 601 601 0 0 No change

marche 601 601 0 0 No change

varianti_descrizioni 138 137 1 0 No change

varianti_descrizioni 138 138 0 0 No change

variazioni 54080 54019 61 0 No change

variazioni 54080 54080 0 0 No change

variazioni_descrizioni 46897 46893 4 0 No change

variazioni_descrizioni 46897 46897 0 0 No change

i think that SJA have a lot of problem …. i hope that problem are fixed…

bye Michele

[Ritesh]

1.) Are you using Linux or Windows version of SQLyog?

2.) Run the query

Code:

select md5(concat_ws('A','B',''))

in both your server. Is the result returned same?

3.)

Quote:

i have the same problem… the item are showed and anyting else… i hane non error message and the sync don't go on.

What is the problem you are facing? What does SJA output during sync?

4.)

Quote:

i have a seagment fault when the sync arrive at table ordini_testa (head_order)

Can you mail me a dump of the table?

[Ritesh]

You have a private message.

[Anonymous]

1) i'm using linux version of SJA, the version 4.0, it is istalled into a local server with a Mandrake 10.1.

2)

On server (:cool: [local with mandrake]

mysql> select md5(concat_ws('A','B',''));

+

---

+

| md5(concat_ws('A','B','')) |

+

---

+

| 5fc810cf62601df84b7923b9964c53e6 |

+

---

+

1 row in set (0.00 sec)

On server (A) [webserver with red hat]

mysql> select md5(concat_ws('A','B',''));

+

---

+

| md5(concat_ws('A','B','')) |

+

---

+

| 9d5ed678fe57bcca610140957afab571 |

+

---

+

1 row in set (0.01 sec)

3)The output is the right output

a have something like this

Table SrcRows TgtRows Inserted Updated Deleted

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

articoli 11031 11031

and anithing else… the SJA count the item into a source.. count the item into a target and… stop… the process still alive… i must kill it… if i don't kill the process… the sync seem don't go on…

don't appair inserted '0' and updated '0' and delete '0'…

and don't process the other table…

if i truncate a table.. the sync go on in few second…

and i have something like this…

Table SrcRows TgtRows Inserted Updated Deleted

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

articoli 11031 0 11031 0 0 0

articoli_categorie 29097 29097 0 0 0

articoli_consigliati 1052 1052 0 0 0

etcetera…

4) i'll mail you the dumb of 'ordini_testa',

end 'articoli'… the table that made me a problem..

[Ritesh]

Quote:

mysql> select md5(concat_ws('A','B',''));

+

---

+

| md5(concat_ws('A','B','')) |

+

---

+

| 5fc810cf62601df84b7923b9964c53e6 |

+

---

+

1 row in set (0.00 sec)

On server (A) [webserver with red hat]

mysql> select md5(concat_ws('A','B',''));

+

---

+

| md5(concat_ws('A','B','')) |

+

---

+

| 9d5ed678fe57bcca610140957afab571 |

+

---

+

1 row in set (0.01 sec)

As you can see the results are different.

SJA will not work between those two MySQL versions. It is due to the fact that MySQL returns different result for concat_ws() function across multiple MySQL versions.

This is the reason that SJA is not syncing the data correctly.

[Anonymous]

@#!#!!

wel… 🙂 i'll try to upgrade the mysql server of Web Server to the version 4.0.20 as in local server and i'll try again…

thak you for your support

[Author]

Posts