forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Sja Inserts And Then Deletes Rows
- This topic is empty.
-
AuthorPosts
-
-
February 22, 2006 at 9:58 pm #20656
peterlaursen
ParticipantOh .. those details .. hard to remember.
It is only the PK that matters. the 'ordinary' indexes don't play a role.
I am always sure that this is an issue that has been fixed. But I simply cannot recall details right now. I think a checksums issue with 'unsigned'
Latest verison is 5.02. Filename sja502.tar.gz. Uploaded to server 12-12-2005.
Would you mind trying latest build if you don't have it
-
February 22, 2006 at 10:43 pm #20657
peterlaursen
ParticipantAlso remember to check for next version soon.
There is an issue with PKs involving timestamps that has been solved.
-
February 27, 2006 at 4:01 am #20658
zgolus
Memberfirst of all – thanks for your reply!
You suggested that the issue might have something to do with PKs being unsigned, so I've changed it to default value, but that also didn't solve the problem; during last sync job it went like that:
Code:Sync started at Sun Feb 26 23:10:00 2006Table SrcRows TgtRows Inserted Updated Deleted
========================= ======= ======= ======== ======= =======
`lem_pl` 4159351 4156892 754907 2200 1554267Total time taken – 4189 sec(s)
any more ideas?
and btw – I'm using the latest SJA
-
February 27, 2006 at 5:22 am #20659
Ritesh
MemberIf the data is not confidential, then can you send me a dump of the data?
I cannot correctly comment on the issue without looking at the data.
-
-
AuthorPosts
- You must be logged in to reply to this topic.